While it may be nice syntactic sugar, it isn't portable SQL. And, I don't see how the following is difficult to work with ...
INSERT INTO foo_table
( foo, bar, baz, foo1, bar1, baz1 )
VALUES ( ?, ?, ?, ?, ?, ? )
It's all about how you format your SQL. Personally, I format my SELECT statements as such:
SELECT xx.foo
,xx.bar
,yy.baz
,COUNT(*) AS count
FROM foo_table xx
,bar_table yy
WHERE xx.abcd = yy.abcd
AND xx.asdfghjkl = yy.asdfghjkl
GROUP BY xx.foo
,yy.bar
,yy.baz
Notice where the commas and where the equals signs are. Also, note how I line up the whitespace after the upper-cased keyword. The more you can say in your formatting, the better.
------
We are the carpenters and bricklayers of the Information Age.
Please remember that I'm crufty and crochety. All opinions are purely mine and all code is untested, unless otherwise specified.
|