Jim Wright wrote: > Pete wrote: >> >> They have a piece of code: >> >> select * >> into visaudactvols >> from visualauditrecs > > I don't believe MySQL supports this use of INTO. You can use: > INSERT INTO visaudactvols(somecolumn) > SELECT somecolumn FROM visualauditrecs > > but the table will have to exist first, unlike Access, MS-SQL and > PostgreSQL, which will create the table with the SELECT ... INTO statement.
CREATE TABLE visaudactvols AS SELECT * FROM visualauditrecs Jochem ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| ColdFusion MX7 by Adobe® Dyncamically transform webcontent into Adobe PDF with new ColdFusion MX7. Free Trial. http://www.adobe.com/products/coldfusion Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:271761 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
