Oh yeah. The Insert Into, Select blah is the bees knees! One of my faves. :)
On Wed, Dec 1, 2010 at 1:20 PM, Judah McAuley <ju...@wiredotter.com> wrote: > > 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:332285 Subscription: http://www.houseoffusion.com/groups/cf-community/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-community/unsubscribe.cfm
