That's because MySQL does not support SELECT INTO for tables, only external files and variables, so MySQL thinks your destination is a variable and is complaining that it does not exist. You may want to use INSERT SELECT instead.
http://dev.mysql.com/doc/refman/5.0/en/ansi-diff-select-into-table.html --- Ben -----Original Message----- From: Pete [mailto:[EMAIL PROTECTED] Sent: Tuesday, March 06, 2007 1:23 PM To: CF-Talk Subject: SQL for Access vs MySQL Hi Hoping someone might be able to assist - its 4am and I have just been called by a client coz their system crashed. They have just moved from using an Access DB to MySQL. They have a piece of code: select * into visaudactvols from visualauditrecs The error says Undeclared variable: visaudactvols Any quick reply would be greatfully appreciated. ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| ColdFusion MX7 and Flex 2 Build sales & marketing dashboard RIAâs for your business. Upgrade now http://www.adobe.com/products/coldfusion/flex2 Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:271754 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
