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:
- Mybatis-plus automatically generates code error [Solved]
- Mybatis plus method querytotal execution error of SQL
- Springboot + mybatis + logback does not print SQL problems on the console
- Macro generated_ UCLASS_ Body () and generated_ Analysis of body ()
- Mybatis database error java.sql.SQLException : Error setting driver on UnpooledDataSource. Caus
- Cause: java.sql.SQLSyntaxErrorException: You have an error in your SQL syntax； check the
- Mybatis openSession.commit () manually submit data and openSession.commit (true) automatically submit data
- The jar package download of Maven project appears (could not transfer artifact. Org mybatis:mybatis ）
- Error: Failed to execute goal org.mybatis.generator:mybatis-generator-maven-plugin:1.3.2
- Failed to retrieve plugin descriptor for org.mybatis.generator :mybatis-generator
- SAP SQL error “SQL code: -10692“ occurred while accessing table “ZTXXXX“.
- Spring data JAP SQL error:17059 SQL State:99999
- The collapse pits of VTK projects that are not generated by cmake
- Example of public key signature and verification generated with fabric case
- Matlab: Three forms of random number generated (Rand, Randi and Randn)
- This function has none of deterministic, no SQL, or reads SQL data in its error records
- T omcat:removeGeneratedFiles Failed to delete the generated java file solution
- DB2 SQL ERROR: SQLCODE=-803, SQLSTATE=23505, SQL
- SQL 2005 remote connection error (provider: SQL network interface, error: 28 – the server does not support the requested protocol
- IntelliJ idea / eclipse automatically generate author annotation signature