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]
- Analysis of JDBC connection to MySQL
- 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
- Duplicate entry ‘787192513’ for key ‘primary’
- solve com.mysql.jdbc . exceptions.jdbc4 .MySQLSyntaxErrorException:
- Syntax error, insert “}” to complete ClassBody
- The route addition failed: Either the interface index is wrong or the gateway do es not lie on the s
- Cursor window allocation of 2048 kb failed
- mysql ERROR 1050 (42S01): Table already exists
- An error 1064 is reported when pymysql accesses the image
- syntax error near unexpected token `then’ problem solution
- SQL Error: 0, SQLState: 08S01 & Communications link failure
- Error 1064 in MySQL password change
- Hive SQL syntax error and corresponding solutions
- MySQL error code ‘1064’ troubleshooting process
- Loading class `com.mysql.jdbc.Driver‘. This is deprecated. The new driver class is `com.mysql.cj.jdb