Pedantic wrote:Well, if they meant structured in that sense, why didn't they use "Standardized"?
I have no idea. Perhaps if you had coined the acronym it would have been Silly Query Language.
Pedantic wrote:Weeell, first of all, you're forgetting FROM.
From is part of a SELECT statement.
Pedantic wrote:And while WHERE may be a clause in a statement, it is certainly not the most crucial part, and certainly cannot form its own statement.
Internally, SELECT and SELECT WHERE are very different types of queries.
Pedantic wrote:UPDATE, DELETE, and INSERT are also not queries. A query returns information from one or more tables.
Incorrect. You're confusing the definition of the word query with the definition of a query in the sense of database operations. Consider UPDATE. To SQL this is what you are asking: Can you UPDATE? If so please go ahead and do it. (Always ask politely, databases can be grumpy creatures).
For it would be most difficult to actually create a database in the first place. It would also be rather difficult to create or alter a table, now wouldn't it? And creating indices and views would most certainly be impossible, would it not?
No. Again I think you have a misconception about what these things are. Creating tables and indices are queries and are just advanced wrappers around the update mechanisms.
Chris Fehily wrote:It's a common misconception that SQL stands for structured query language; it stands for S-Q-L and nothing else. Why? Because ANSI says so. The official name is Database Language SQL...
This is correct. ANSI will not admit that it is an ancronym but everyone in the industry knows that it is just sillines. It has to do with some conflict with IBM which created the precursor to SQL, SEQUEL. The original creators of SQL say it is an acronym. ANSI, who standardized it says it is not. Believe who you want.
Chris Fehily wrote:Furthermore, referring to it as a structured query language is a disservice to new SQL programmers; it amuses database professionals and academics to point out that "structured query language" is the worst possible description, as SQL:
- Isn't structured (because it can't be broken down into blocks or procedures)
- Isn't limited to only queries (that is, there's more than just the SELECT statement)
- Isn't a complete language (according to Turing's Thesis, which you'll study should you take Theory of Computation)
Mr. Fehily's quickstart guide is incorrect.