|
Posted by Miguel Cruz on 07/26/06 18:29
himilecyclist@yahoo.com wrote:
> What is the correct syntax for "SELECT * INTO" for MySQL?
INSERT INTO edenbackup SELECT * FROM edenmaster;
The two tables would of course have to have the same field types in the
same order for this to work. Otherwise you would have to specify the
field names.
miguel
--
Photos from 40 countries on 5 continents: http://travel.u.nu
Latest photos: Malaysia; Thailand; Singapore; Spain; Morocco
Airports of the world: http://airport.u.nu
Navigation:
[Reply to this message]
|