You can also use a combination of SELECT... UNION instead of VALUES: INSERT INTO Products (ProductCode, ArtistName, AlbumTitle, Category, Description, ProductPrice) SELECT '8601', '86 (the band)', 'True Life', 'Rock', 'The debut album rocks', '14.95') UNION SELECT 'pf01', 'The first CD', 'Paddlefoot', 'Rock', 'This 68-minute.', '12.55') UNION SELECT 'pf02', 'The second CD', 'Paddlefoot', 'Rock', 'The second.', '12.85') UNION SELECT 'jr01', 'Genuine Wood Grained Finish', 'Joe Rut', 'Folk', 'This well-crafted.', '14.95')
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Find out how CFTicket can increase your company's customer support efficiency by 100% http://www.houseoffusion.com/banners/view.cfm?bannerid=49 Message: http://www.houseoffusion.com/lists.cfm/link=i:6:2266 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/6 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:6 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.6 Donations & Support: http://www.houseoffusion.com/tiny.cfm/54
