Several errors encountered in MySQL and their solutions

MySQL encountered several errors and solutions 1. [ERR] 1064-you has an error in your SQL syntax; Check the manual-corresponds to your MySQL server version for the right syntax-use-near ' xxx ' on line 1

　 WORKAROUND: Replace All "'" with "• (Change all the English single quotes to the dot above the TAB key)

2.[err] 1100-table ' xxx ' was not locked with LOCK TABLES

solution: Add unlock TABLES; This code

3.[ERR] 1063-incorrect column specifier for column ' xxx '

　Solution: Int: max=255, not super; float: it must be used: float (m,n), m for the display length, and n for the number of decimal digits.

PS: Note the "--" sign must be followed by a space, otherwise it will be an error.

"I would be better off if I had other problems later."

Several errors encountered in MySQL and their solutions