Mybatis automatically generated SQL error

first of all, I want to make it clear that the tool is not wrong, I’m sure your hair is wrong, yes, it’s me, let’s look at my fault

SQL: Insert into T_ADMINISTRATIVE (A_ID, s_ID, A_import_TZZl, A_import_tz_remark, A_import_file_route, A_expert_Lzzl, A_expert_Lz_remark, a_expert_file_route, A_risk_pgzl, A_risk_pgremark, A_risk -file_route, ssh_zl, ssh_remark, ssh_file_route, A_node_status, a_del_status) values (?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?)
### Cause: com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException: 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 ‘- file_route, ssh_zl,
ssh_remark, ssh_file_route, a_node_status,
a_de’ at line 4

insert increase error, at the beginning because it was a SQL statement problem, until finally confirm that it is not SQL problem, go back to the table you created (created garbage)

file-route. File_route. All right, just rebuild it.


Read More: