mysql 建表出错问题

[钛元素]

我在mysql里面建表：

CREATE TABLE auto_dir (
dirid int(8) NOT NULL auto_increment,
userid int(8),
parentid int(8),
ifson char(2),
dirname char(100),
xuhao int(10),
mod char(3),
PRIMARY KEY (dirid),
KEY xuhao (xuhao)
);

报错：#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 'mod char(3),
PRIMARY KEY (dirid),
KEY xuhao (xuhao)
)'

请问如何解决？

[mathematician]

mod char(3),
------------
mod是关键字

[mathematician]

要么换字段名，要么用下面的写法：

CREATE TABLE auto_dir (
dirid int(8) NOT NULL auto_increment,
userid int(8),
parentid int(8),
ifson char(2),
dirname char(100),
xuhao int(10),
`mod` char(3),
PRIMARY KEY (dirid),
KEY xuhao (xuhao)
);

[钛元素]

了解，接分！