This problem was found when I was doing a database initialization tool recently, that is, it can be correctly executed when an SQL Statement is executed in a Statement. If Multiple SQL statements are executed at the same time, an SQL syntax error will be reported, it hurts your mind. After searching on the Internet, there are two solutions: 1. the simplest method is to set the allowMultiQueries parameter to true in the MySQL connection string. 2. Split the SQL Statement into multiple SQL statements using a semicolon in the program, use the addBatch method of Statement, and finally exectebatch. Conclusion: The first method is the simplest. I hope this will be helpful to my friends who will encounter such problems in the future. This problem was found when I was doing a database initialization tool recently, that is, it can be correctly executed when an SQL Statement is executed in a Statement. If Multiple SQL statements are executed at the same time, an SQL syntax error will be reported, it hurts your mind.
You can find two solutions on the Internet:
1. The simplest way is to set the allowMultiQueries parameter to true in the MySQL connection string.
2. Split the SQL Statement into multiple SQL statements using a semicolon in the program, use the addBatch method of Statement, and finally exectebatch.
Conclusion: The first method is the simplest.
I hope this will be helpful to my friends who will encounter such problems in the future.