Monday, April 5, 2010

How to save query output as a table

Answer:

We need to use insert command followed by the select query

See the command

INSERT INTO mysql_interview SELECT * FROM source_table

No comments:

Post a Comment