mysql文件导入数据库出错_SQL文件导入Myslq数据库出错，在线等大神解救！！！倾尽所有分回馈！...

[Err]1064-YouhaveanerrorinyourSQLsyntax;checkthemanualthatcorrespondstoyourMySQLserverversionfortherightsyntaxtousenear';--------------------------------Viewstructureforv...

[Err] 1064 - You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near ';

-- ----------------------------

-- View structure for vw_count

-- -------' at line 1

[Err] INSERT INTO `videomessage` VALUES ('115155', '410100A1614028852_01', 'videos', 'REMOTE_CTRL_CMD_02@83@D:\\Files\\videos\\2014\\12\\12\\410100A1614028852_01_4.asf', 'D:\\Files\\videos\\2014\\12\\12\\410100A1614028852_01_4.asf', '\\videos\\2014\\12\\12\\410100A1614028852_01_4.asf', '2014-12-12 16:29:20', '2014-12-12 16:29:21', null, null, '豫AP5306', '02', '3', '\'1\'', '\'3\'', '0', '3');

-- ----------------------------

-- Function structure for GET_STATION_NAME

-- ----------------------------

DROP FUNCTION IF EXISTS `GET_STATION_NAME`;

CREATE DEFINER=`root`@`%` FUNCTION `GET_STATION_NAME`() RETURNS varchar(60) CHARSET utf8

BEGIN

DECLARE STANAME VARCHAR(60);

SELECT STA_NAME INTO STANAME FROM STATION ORDER BY ID limit 1;

RETURN STANAME;

END

(这才是其中一部分，有意解决的请留下QQ我把全部日志传给你，谢了大神)

展开