Hi ,
I want to copy the selected fields,
eg:SELECT * FROM table1 where flag='1';
to another table ,table2
can anyone plz help me
rahulroshan
0
Light Poster
Recommended Answers
Jump to Posthttp://dev.mysql.com/doc/refman/5.5/en/insert-select.html
INSERT INTO newtable (field1, field2) SELECT field1, field2 FROM oldtable WHERE flag = '1'
All 3 Replies
pritaeas
2,194
¯\_(ツ)_/¯
Moderator
Featured Poster
http://dev.mysql.com/doc/refman/5.5/en/insert-select.html
INSERT INTO newtable (field1, field2) SELECT field1, field2 FROM oldtable WHERE flag = '1'
rahulroshan
0
Light Poster
thanks a lot :)
pritaeas
2,194
¯\_(ツ)_/¯
Moderator
Featured Poster
Please consider to mark this thread solved.
Be a part of the DaniWeb community
We're a friendly, industry-focused community of developers, IT pros, digital marketers, and technology enthusiasts meeting, networking, learning, and sharing knowledge.