236
Is SQL case sensitive? I've used MySQL and SQLÂ Server which both seem to be case insensitive. Is this always the case? Does the standard define case-sensitivity?
Is SQL case sensitive? I've used MySQL and SQLÂ Server which both seem to be case insensitive. Is this always the case? Does the standard define case-sensitivity?
This isn't strictly SQL language, but in SQL Server if your database collation is case-sensitive, then all table names are case-sensitive.
No. MySQL is not case sensitive, and neither is the SQL standard. It's just common practice to write the commands upper-case.
Now, if you are talking about table/column names, then yes they are, but not the commands themselves.
So
SELECT * FROM foo;
is the same as
select * from foo;
but not the same as
select * from FOO;