Com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxError Exception

1. Error description

Com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxError Exception:you has an error on your SQL syntax check the manual that Corr Esponds to your MySQL server version for the right syntax to use near ' notnull,user_name varchar (255)) ' on line 1

2. Cause of Error

StringBuilder sql = new StringBuilder (); Sql.append ("CREATE Table T_you_su_ta ("); Sql.append ("ID int primary key,"); Sql.append ("user_id int notnull,") sql.append ("user_name varchar (255))");

When you create a database table in the stitching, you want to make the user_id not empty, defined as "Notnull"

3. Solutions

When stitching user_id, it should be changed to "user_id int not NULL"

Com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxError Exception