I have a table(2) with a different structure than the table(1) I'm selecting from. I want to be able to grab some info from table1, put it in table2, along with some variables from my php page. Is it possible to do like:
INSERT INTO table2 VALUES 1,2,3 SELECT 4,5,6 FROM table1 Or do I need to select into a temp table or my php form, get it all in the right order, then insert it back into table2? Thanks!! # Nathan --------------------------------------------------------------------- Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
