Mysql to create a user password in the parentheses after the password always shows a syntax error-CodePudding

Home > database > Mysql to create a user password in the parentheses after the password always shows a syntax error

Mysql to create a user password in the parentheses after the password always shows a syntax error

Time：10-14

INSERT INTO mysql. The user (Host, user, Password) VALUES (" % ", "FENG", "(" FENG"));
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 '(" FENG ")) at line 1

CodePudding user response:

Statement itself is no problem, said the execution details, version,

Page link：https//www.codepudding.com/database/65299.html

Prev:MYSQL database to save the date format for int, I want to switch to text format date, how to do it.

Next:Number query elective courses for students' c05109 'student id, name and your final course

Tags：

MySQL

Links：
CodePudding