MySQL-Analysis of related problems encountered when using MySQL

Problem:

An error occurred when importing the database table downloaded from quartz official website, mysql[tables_mysql_innodb.sql], the error message is as follows
mysql Error number #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 '
tyenginepe=innodb;

Cause of the problem:
tyenginepe is wrong, change it to engine That's good. I checked on the Internet and said that it is because the keyword is used as a field and needs to be framed using the symbol ` (that is, the key next to the numeric key 1, the upper left corner of the keyboard), for example: option requires `option`

The above is the detailed content of MySQL-Analysis of related problems encountered when using MySQL. For more information, please follow other related articles on the PHP Chinese website!