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
不知道是什么错误希望大家指点怎么修改采能正确
