今天在做一个任务,使用MySQL数据库MySQL建表语句 create table gisinfo(
ID int(10) primary key auto_increment,
webserviceURL varchar (255),
webserviceName varchar (255),
webserviceInfo varchar (255)
);MySQL插入语句intsert into gisinfo(webserviceURL,webserviceName,webserviceInfo) values(
"http://localhost:8080/webService/services/GISWebService?wsdl","giswebservice","
test");然后就是异常ERROR 1064 (42000): 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 'intse
rt into gisinfo(webserviceURL,webserviceName,webserviceInfo) values("http:/' at
line 1记得java在处理‘/’之类的特殊的标记是要进行特别的处理的,MySQL也要么?改怎么弄啊?先谢谢大家了。
ID int(10) primary key auto_increment,
webserviceURL varchar (255),
webserviceName varchar (255),
webserviceInfo varchar (255)
);MySQL插入语句intsert into gisinfo(webserviceURL,webserviceName,webserviceInfo) values(
"http://localhost:8080/webService/services/GISWebService?wsdl","giswebservice","
test");然后就是异常ERROR 1064 (42000): 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 'intse
rt into gisinfo(webserviceURL,webserviceName,webserviceInfo) values("http:/' at
line 1记得java在处理‘/’之类的特殊的标记是要进行特别的处理的,MySQL也要么?改怎么弄啊?先谢谢大家了。
解决方案 »
免费领取超大流量手机卡,每月29元包185G流量+100分钟通话, 中国电信官方发货