Yeah, that's essentially the same thing as the other bulk insert syntax: INSERT INTO Table (X) SELECT (Y) FROM OtherTable
Handy stuff on occasion. Judah On Wed, Dec 1, 2010 at 9:22 AM, G Money <gm0n3...@gmail.com> wrote: > > When inserting multiple rows of literal data, instead of: > > INSERT INTO Table (X) VALUES (1); > INSERT INTO Table (X) VALUES (2); > Etc, Etc.... > > You can just do: > > INSERT INTO Table (X) VALUES (1), (2), Etc, Etc..... > > I learn new things every day, but rarely shortcuts that are this basic! > > Anyway, you all probably already knew about this, but I thought it was cool, > and it instantly makes my life easier! > > > ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion Archive: http://www.houseoffusion.com/groups/cf-community/message.cfm/messageid:332284 Subscription: http://www.houseoffusion.com/groups/cf-community/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-community/unsubscribe.cfm
