RE: [PHP] Move data from one MySql table to another?

OK say you old table is this create table old_table ( id int auto_increment, name varchar(100), address varchar(200), comments text); and you new table is: create table new_table ( id int auto_increment, name varchar(200), address varchar(200)); To populate new_table from old_table you can give it this SQL: INSERT INTO new_table (name, address) VALUES SELECT name, address FROM old_table; Hope that helps - James > -----Original Message----- > From: YoBro [mailto:nospam@brochures.co.nz] > Sent: March 22, 2001 3:20 PM > To: php-general@lists.php.net > Subject: [PHP] Move data from one MySql table to another? > > > Hello, > > Does anybody know where I could find out how to Move data from one Mysql > table to another. > > I have a query showing all the results, and I am trying to put a > link at the > end of each row that says "move" > > Clicking this will move that records information to another table. > IE From table orders to table ordered > > Make sense? > > Please help > > -- > Regards, > > > YoBro > ------------------------------------------------------------- > DO NOT REPLY TO THIS VIA EMAIL > PLEASE USE THE NEWSGROUP > All emails sent to this address are automatically deleted. > This is to avoid SPAM! > ------------------------------------------------------------- > > > > -- > PHP General Mailing List (http://www.php.net/) > To unsubscribe, e-mail: php-general-unsubscribe@lists.php.net > For additional commands, e-mail: php-general-help@lists.php.net > To contact the list administrators, e-mail: php-list-admin@lists.php.net