SELECT uid FROM common_member WHERE username ='a'ゞYi'
红色部分单引号多了一个,如果在数据中包含单引号,那么写两次来转义,也就是:SELECT uid FROM common_member WHERE username ='a‘'ゞYi'
查询:CREATE TABLE t_dept ( id INT(11) NOT NULL AUTO_INCREMENT, deptName VARCHAR(30) DEFAULT NULL, address VARCHAR(40) DEFAULT N...错误代码: 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 'KEY (id) ) ENGINE=INNODB AUTO_INCREMENT=1 DEFAULT CHARSET=utf8' at line 5 大神们,求解决。
红色部分单引号多了一个,如果在数据中包含单引号,那么写两次来转义,也就是:SELECT uid FROM common_member WHERE username ='a‘'ゞYi'
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 'KEY (id)
) ENGINE=INNODB AUTO_INCREMENT=1 DEFAULT CHARSET=utf8' at line 5
大神们,求解决。