Commands related to MySQL operations

• Copy the table and copy two data into the new table

Create Table  like t_comments_sample; #拷贝表结构 Insert  into Select *  from 1,2; #复制两条数据

• MySQL Workbench Execution Procedure Error

Error:

Workaround:

SET = 0; #因为MySql运行在safe-update mode, this mode will cause the non-primary key conditions can not be executed updates or delete command, need to modify the following database mode call ' TEDP '. ' P_ Phone_comments ' (); #执行存储过程

Commands related to MySQL operations