如何用空格创建列名? [英] How to create column name with space?

问题描述

有人可以告诉我如何创建带有"FULL NAMES"之类的空格的列吗? 我已经尝试过以下操作，但是不起作用.

Can anybody tell me how to create columns with space like "FULL NAMES"? I've tried like the following but it doesn't work.

CREATE TABLE info
(
Full Names varchar(20),
Physical Address varchar(20),
Moviesrented varchar(100),
Salutation varchar(20),
Category varchar(20),
PRIMARY KEY (address)
)

推荐答案

只需将名称放在反引号中即可:

Just put the name in backticks:

CREATE TABLE info (`Full Names` varchar(20), ...)

但这并不是命名列的好方法.

But that's no good handle for naming your columns.

这篇关于如何用空格创建列名?的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！