INSERT INTO t_t VALUES(NULL,‘2013-1-1’,‘a’,1,MD5(‘123456’),ENCODE(‘abcd’,‘aa’));
没有空格存在依旧报错
ENCODE does not exist 0.000 sec.
INSERT INTO t_t VALUES(NULL,‘2013-1-1’,‘a’,1,PASSWORD(‘123456’));
也不知道是哪里有编辑错误,找到头晕。
23:47:22 INSERT INTO classic VALUEs (1,PASSWORD(1234)) 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 ‘(1234))’ at line 1 0.000 sec