SELECT with numbers
Moderators: egami, macek, gesf
-
- New php-forum User
- Posts: 29
- Joined: Fri Jun 27, 2003 10:05 pm
why don't you do like this:
INSERT INTO table1 (field1, field2) SELECT field4, field3 FROM table2 WHERE field4 = 1;
INSERT INTO table1 (field1, field2) SELECT field4, field3 FROM table2 WHERE field4 = 1;