Size=14.6667 px] (1064), there is an error in your SQL syntax; Please check with your MySQL server version corresponding manuals, in order to get near the line 1 "\ xA9g Yi" near use correct grammar
[size=14.6667 px] who can help us see
SELECT the uid FROM common_member WHERE username='a' ゞ Yi '

CodePudding user response:

Single quotation marks is not matching

CodePudding user response:

SELECT the uid FROM common_member WHERE username=' ゞ Yi '



Red part quotes one more, if the data contained in single quotes, so write twice to escape, namely:

SELECT the uid FROM common_member WHERE username='a' 'ゞ Yi'

CodePudding user response:

Query: CREATE TABLE t_dept (id INT (11) the NOT NULL AUTO_INCREMENT, the deptName VARCHAR (30) DEFAULT NULL, address VARCHAR (40) DEFAULT N... Error code: 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


The great spirit, to overcome,