----- Original Message ----- From: "Jay Blanchard" <[EMAIL PROTECTED]>
To: "Chip Wiegand" <[EMAIL PROTECTED]>; "MySQL List" <[EMAIL PROTECTED]>
Sent: Thursday, November 18, 2004 8:10 AM
Subject: RE: copy data only from one table to another table
[snip] How do I copy all data only from one table into another table? Both tables are in the same database. I have phpMyAdmin and it suppossedly does this, but it is not working, and there are no error messages. [/snip]
INSERT INTO `table2` (`columnnames`) SELECT `columnnames` FROM `table1`
If this is valid SQL surely grave accents are not? -Jon
-- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]