列名或者别名不能设置为中文

Discuss / SQL / 列名或者别名不能设置为中文

Back

Topic source

#1 Created at ... [Delete] [Delete and Lock User]

在廖先生博客上的AlaSQL实验，列名或者别名不能设置为中文

#2 Created at ... [Delete] [Delete and Lock User]

试了一下加引号是可以的

SELECT id, score '哈哈哈', name FROM students WHERE gender = 'M';

#3 Created at ... [Delete] [Delete and Lock User]

经过尝试，引号不行，加引号之后名字中含有引号。

试了下通用的方法是采用中括号[***]

#4 Created at ... [Delete] [Delete and Lock User]

可以的，语句如下：

select id `编号`, name `姓名`, gender `性别` from students

用tab建上的那个键的`不要用单引号，用单引号的话别名也会带上单引号

#5 Created at ... [Delete] [Delete and Lock User]

我用的是sql bench 列明可以直接写中文 SELECT id, score 分数, name FROM students WHERE gender = 'M'; 也可以把中文用单引号括起来，必须是英文模式下哦，你用中文引号肯定带进去了。不可以用[]