要了解有关SQL / DDL中的案例的句子-查询 [英] To understand a sentence about the case in SQL/DDL -queries

问题描述

此问题基于此答案。 / p>

以下句子是什么意思？

最后，请勿使用大小写混合的
标识符。用小写
代替，所以您不必引用它们。

这是否意味着我应该将CREATE TABLE，USER_ID和NOT NULL等命令更改为小写吗？-不能这样做，因为这违反了通用的命名约定。

解决方案

否，我认为这位绅士使用所有小写字母标识符来引用，例如表，列等名称。

Marc

应该不会对您使用的命令如CREATE TABLE等产生影响。

This question is based on this answer.

What does the following sentence mean?

Finally, don't use mixed case identifiers. Do everything lowercase, so you don't have to quote them.

Does it mean that I should change the commands such as CREATE TABLE, USER_ID and NOT NULL to lowercase? - It cannot because it would be against common naming conventions.

解决方案

No, I think the gentleman referred to using all lowercase identifiers, e.g. table, column etc. names. This should have no impact on the commands like CREATE TABLE etc. that you use.

Marc

这篇关于要了解有关SQL / DDL中的案例的句子-查询的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！