----- Original Message ----- From: "Jay Blanchard" <[EMAIL PROTECTED]>
To: "Jonathan Mangin" <[EMAIL PROTECTED]>
Cc: <[EMAIL PROTECTED]>
Sent: Thursday, November 18, 2004 9:19 AM
Subject: RE: copy data only from one table to another table
[snip] INSERT INTO `table2` (`columnnames`) SELECT `columnnames` FROM `table1`
If this is valid SQL surely grave accents are not? [/snip]
Actually? MySQL supports the use of grave accents around table and column names. I use them here for emphasis. In certain cases, with older versions of MySQL, I encourage our developers to always use them.
Well, never mind then. I thought only apostrophes were valid. -Jon
-- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]