I want to copy the selected fields,
eg:SELECT * FROM table1 where flag='1';
to another table ,table2
can anyone plz help me
Jump to Post
INSERT INTO newtable (field1, field2) SELECT field1, field2 FROM oldtable WHERE flag = '1'
thanks a lot :)
Please consider to mark this thread solved.
We're a friendly, industry-focused community of 1.18 million developers, IT pros, digital marketers, and technology enthusiasts learning and sharing knowledge.