SQL语法区分大小写吗？ [英] Is SQL syntax case sensitive?
问题描述
SQL区分大小写。我使用的MySQL和SQL Server似乎都不区分大小写。总是这样吗？该标准是否定义区分大小写？
Is SQL case sensitive. I've used MySQL and SQL Server which both seem to be case in-sensitive. Is this always the case? Does the standard define case-sensitivity?
推荐答案
SQL关键字不区分大小写（ SELECT ， FROM ， WHERE 等），但通常写成全大写。但是，在某些设置中，表和列的名称区分大小写。 MySQL具有启用/禁用它的配置选项。通常，区分大小写的表名和列名是Linux MySQL上的默认名称，不区分大小写的名称曾经是Windows上的默认名称，但是现在安装程序在设置过程中询问了此问题。对于MSSQL，它是数据库排序规则设置的函数。
The SQL Keywords are case-insensitive (SELECT, FROM, WHERE, etc), but are often written in all caps. However in some setups table and column names are case-sensitive. MySQL has a configuration option to enable/disable it. Usually case-sensitive table and column names are the default on Linux MySQL and case-insensitive used to be the default on Windows, but now the installer asked about this during setup. For MSSQL it is a function of the database's collation setting.
这是文章
这篇关于SQL语法区分大小写吗？的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！
