MYSQL Small Problem Collection

-Using MySQL to build tables from Springframework, the server uses Tomcat, and the JDBC DataSource is configured correctly in both Server.xml and context.xml.

The compilation passed, but the deployment encountered the following error, and the table in MySQL could not be automatically created:

Com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException:You has an error in your SQL syntax; Check the manual-corresponds to your MySQL server version for the right syntax-use-near ' OPTION Sql_select_limit=d Efault ' at line 1

Reason: MySQL 5.0+ version requires the corresponding driver version of mysql-connector-java-5.1.36, the corresponding version of the jar package into the Tomcat lib, you can use the normal MySQL through the springframework from the dynamic build table.

MYSQL Small Problem Collection