Mysql5.7.26 temporary table exception record
No1: once the temporary table in the stored procedure is created successfully, if the field name is changed later
Without restarting the mysql server
Inserting data into this temporary table prompts that the corresponding modified field name does not exist
Error message: Unknown column 'column_name' in' field list'
This error occurs when using jdbc connection execution.
No2:
All procedures have one of the compilation errors, and the wrong procedure calls the same procedure called in the task
Scheduled tasks in java call procedures without errors, so scheduled tasks will still fail.