| |||||||||||||
Malcolm: SQL for the command line: "show"Malcolm: SQL for the command line: "show"Posted Mar 26, 2009 23:56 UTC (Thu) by zlynx (subscriber, #2285)In reply to: Malcolm: SQL for the command line: "show" by jordanb Parent article: Malcolm: SQL for the command line: "show"
Insert's syntax may seem redundant for *simple* use. But if you do complicated things, it isn't.
For example, the list of values isn't limited to one thing. Values can just go on and on, inserting as many records as you like.
Or, you can put a SELECT statement there instead of VALUES.
Now what seemed redundant is necessary.
I won't argue about DELETE and UPDATE assuming all records without a WHERE being dangerous and stupid though. :-)
(Log in to post comments)
|
|||||||||||||