在Mysql中进行数据insert操作时,出现的1064错误
错误提示为:You have an error in your SQL syntax;check the manual that corresponds to your MySQL server version for the right syntax to user near’4’,’1’,’6’,’2252’);
Insert into hrswrun values (‘316’,’svchost.exe’,’0.0’’C:/WI’ at line
1代码:insert into hrswrun values('216','raysat_3dsmax2010_32server.exe','0.0','D:\Program Files\Autodesk\3ds Max 2010\mentalray\satellite\','','4','1','6','2252');
insert into hrswrun values('316','svchost.exe','0.0','C:\WINDOWS\system32\','-k LocalService','4','1','9','4296');
注:出问题的这行为第三行,前句话已经顺利执行。第三句话开始报错。这段数据是从程序中直接导出的。求解答!!!
错误提示为:You have an error in your SQL syntax;check the manual that corresponds to your MySQL server version for the right syntax to user near’4’,’1’,’6’,’2252’);
Insert into hrswrun values (‘316’,’svchost.exe’,’0.0’’C:/WI’ at line
1代码:insert into hrswrun values('216','raysat_3dsmax2010_32server.exe','0.0','D:\Program Files\Autodesk\3ds Max 2010\mentalray\satellite\','','4','1','6','2252');
insert into hrswrun values('316','svchost.exe','0.0','C:\WINDOWS\system32\','-k LocalService','4','1','9','4296');
注:出问题的这行为第三行,前句话已经顺利执行。第三句话开始报错。这段数据是从程序中直接导出的。求解答!!!
Query OK, 1 row affected (0.00 sec)
'截至2012-07-27 16:19:56 用户结帖率0.00% 当您的问题得到解答后请及时结贴.
http://topic.csdn.net/u/20090501/15/7548d251-aec2-4975-a9bf-ca09a5551ba5.html
http://topic.csdn.net/u/20100428/09/BC9E0908-F250-42A6-8765-B50A82FE186A.html
http://topic.csdn.net/u/20100626/09/f35a4763-4b59-49c3-8061-d48fdbc29561.html8、如何给分和结贴?
http://community.csdn.net/Help/HelpCenter.htm#结帖