Found this for anyone interested. http://www.mysql.com/doc/en/INSERT_SELECT.html
John Taylor-Johnston wrote: > I was wondering about this, but decided to ask first first: > > INSERT INTO ccl.ccl_main VALUES (select * from greid.ccl where id=28); > delete * from greid.ccl where id=28; > > Both tables would have to have the same structure ? -- John Taylor-Johnston ----------------------------------------------------------------------------- "If it's not open-source, it's Murphy's Law." ' ' ' Collège de Sherbrooke: ô¿ô http://www.collegesherbrooke.qc.ca/languesmodernes/ - Université de Sherbrooke: http://compcanlit.ca/ 819-569-2064 -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
