i had no idea... nice! On Wed, Dec 1, 2010 at 12:22 PM, 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:332283 Subscription: http://www.houseoffusion.com/groups/cf-community/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-community/unsubscribe.cfm
