Shulou(Shulou.com)06/01 Report--

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.

Welcome to subscribe "Shulou Technology Information " to get latest news, interesting things and hot topics in the IT industry, and controls the hottest and latest Internet news, technology news and IT industry trends.