如何用空格创建列名?
问题描述：
有人可以告诉我如何创建带有"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.