insert into class (id,name,path,click,addDate,parent,lastChildClass) values ('~F','fh','e:\fh',1,curdate(),'~','0')
以上语句在MYSQL中执行通过,没有问题,但是在.NET中调用这个语句时抛出异常“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 '~','0')" at line 1”
这是怎么回事?
以上语句在MYSQL中执行通过,没有问题,但是在.NET中调用这个语句时抛出异常“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 '~','0')" at line 1”
这是怎么回事?
不转义?
这样
打出来看看是什么。