mysql见表异常

create table houseproject.house(
hid int NOT NULL AUTO_INCREMENT , title varchar(30) NOT NULL , hireprice double(30) NOT NULL , booktimes date , linkman varchar(30) NOT NULL , linktel varchar(30) NOT NULL , housething varchar(100) NOT NULL , room int NOT NULL , ting int NOT NULL , sid int NOT NULL , uid int NOT NULL , PRIMARY KEY (hid))

下面是错误信息：
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 ') NOT NULL , booktimes date , linkman varchar(30) NOT NULL , linktel varch' at line 2
不知道是什么错误希望大家指点怎么修改采能正确

double(30) 改为double

检查一下你的''这个是中文还是英文。

1#说的对！！！