MySql field name and reserved word conflict solution I just found that two fields in the database table I designed use the reserved word (add, comment ). An error occurred during insert and update. I remember that SQL server seems to be surrounded. So I tried it and it turns out that it won't work in mySql. After a simple search on the Internet, we found that brackets were used. Later, I thought that the SQL statement generated by MySql Administrator would enclose all the table names in single quotes. After trying it out, it still won't work. But the generated symbol can be copied. Make sure that the symbol is not a single quotation mark. The marker ('is the key on the front of Number 1 ). Solve this problem. The following is a summary:
In Mysql, when the table name, field name, or database name conflict with the reserved word, you can use the marker (') in an SQL statement.
