MySQL Forums
Forum List  »  Newbie

Advanced Search
New Topic

Re: generate some tables
Posted by: Shantanu Oak
Date: March 25, 2005 07:08AM

CREATE TABLE newtable1
SELECT id, alarm, description
FROM OLDTABLE
WHERE id=1

Change the New Table name to newtable3 and id = 3 and so on...

Navigate: Previous Message• Next Message
Options: Reply• Quote


Subject
Written By
Posted
generate some tables
David Montaño
March 07, 2005 05:07PM
Re: generate some tables
Shantanu Oak
March 25, 2005 07:08AM


Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.