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:
- Ora-00947: not enough values
- DB2 SQL error: sqlcode = – 803, sqlstate = 23505, sqlerrmc = 2 [solution]
- Error 1136 (21s01): column count doesn’t match value count at row 1
- MySQL – ERROR 1146 (42S02): Table ‘mysql.user’ doesn’t exist
- Mysql error 1452 – Cannot add or update a child row: a foreign key constraint fails
- The route addition failed: Either the interface index is wrong or the gateway do es not lie on the s
- Syntax error, insert “}” to complete ClassBody
- Cursor window allocation of 2048 kb failed
- mysql ERROR 1050 (42S01): Table already exists
- SQL Error: 0, SQLState: 08S01 & Communications link failure
- An error 1064 is reported when pymysql accesses the image
- Loading class `com.mysql.jdbc.Driver‘. This is deprecated. The new driver class is `com.mysql.cj.jdb
- syntax error near unexpected token `then’ problem solution
- MySQL error code ‘1064’ troubleshooting process
- How to Fix SQL Error: 1054, SQLState: 42S22 Unknown column ‘markcardex0_.art_service_time’ in ‘field list’
- Perfectly solve the 1366 error of saving Chinese in MySQL
- Solve MySQL error 1064 (42000)
- Arithmetic overflow error converting identity to data type int
- Solution to MySQL Error 1130 problem