Insert into select and select INTO

1.INSERT into SELECT statement

Statement form: Insert into target_table (field1,field2,...) Select Value1,value2,... from source_table

The target table target_table must exist, and because the target table Table2 already exists, we can insert a constant in addition to the fields source_table the source table.

2.SELECT into from statement

Statement form: SELECT vale1, value2 into target_table from source_table

The target table target_table does not exist because the table target_table is created automatically at insert time and the specified field data in source_table is copied to target_table.

MySQL does not support a SELECT INTO statement to directly back up the table structure and data:

execution: SELECT * into sms_log_216 from Sms_log WHERE couponid like ' -216% '

Error:

Error code:1327
Undeclared variable:sms_log_216

Workaround: CREATE TABLE sms_log_216 (SELECT * from Sms_log WHERE couponid like '-216% ')