MYSQL错误，我似乎无法弄清楚

Question

CREATE TABLE words (
word_id TINYINT UNSIGNED NOT NULL
 AUTO_INCREMENT,
lang_id TINYINT UNSIGNED NOT NULL,
title VARCHAR(80) NOT NULL,
intro TINYTEXT NOT NULL,
home VARCHAR(30) NOT NULL,
forum_home VARCHAR(40) NOT NULL,
'language' VARCHAR(40) NOT NULL,
register VARCHAR(30) NOT NULL,
login VARCHAR(30) NOT NULL,
logout VARCHAR(30) NOT NULL,
new_thread VARCHAR(40) NOT NULL,
subject VARCHAR(30) NOT NULL,
body VARCHAR(30) NOT NULL,
submit VARCHAR(30) NOT NULL,
posted_on VARCHAR(30) NOT NULL,
posted_by VARCHAR(30) NOT NULL,
replies VARCHAR(30) NOT NULL,
latest_reply VARCHAR(40) NOT NULL,
post_a_reply VARCHAR(40) NOT NULL,
PRIMARY KEY (word_id),
UNIQUE (lang_id)
);

运行时出现错误

(#1064 - You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near ''language' VARCHAR(40) NOT NULL, register VARCHAR(30) NOT NULL, login VARCHAR(' at line 9 )

我是 MySql 的初学者，提前谢谢您!

Answer 1

' 应该是<strong>`</strong>一个backtick

   'language' VARCHAR(40) NOT NULL 
-- ^        ^  or just language  

旁注，始终使用反引号 (`) 括起列/表名称是一种通用的良好做法。