Insert small details, big problems, insert details, problems

Insert small details, big problems, insert details, problems

The on-site reporting process cannot be viewed today. No data is found in the Process Table. Yesterday, we performed the step of deleting junk data. The general process is:

Create table bak_test a as select * from test;

Create table test_temp (id..., name..., code ,...);

Insert into test_temp select * from test where flag = 1; -- the error is returned because the order of the company environment and field is inconsistent.

Rename test to test_bak;

Rename test_temp to test;

So do not be lazy. Be sure to add detailed fields, inser into test_temp (id, name, code ....) select id, name, code .... from test where flag = 1;