sql语句这个错误怎么改

已执行的 SQL 语句：Create table lixijisuan.Interest(

clientname varchar(20) NOT NULL,
productname varchar(40) NOT NULL,
guaranteemethod char(8) NOT NULL,
loanpayment double(13) NOT NULL,
loanperiodmonths double(8) NOT NULL,
accountopeningdate date NOT NULL,
dateofexpiry date NOT NULL,
lendingrate double(17) NOT NULL,
lendingrate(month) double(17) NOT NULL,
loanbalance double(13) NOT NULL,
writeofftheprincipal double(13) NOT NULL,
arrears double(13) NOT NULL,
irrevocableinterest double(17) NOT NULL,
accountstatus varchar(8) NOT NULL,
dateofclassification date NOT NULL,
classification varchar(8) NOT NULL,
handlingbank int(11) NOT NULL,
attn int(11) NOT NULL,
primary key (clientname)
) charset=utf8 collate=utf8_bin错误号：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 ') NOT NULL,
loanperiodmonths double(8) NOT NULL,
accountopeningdate da' at line 5

double(a,b) ，其中的a 表示字符总位数，b 表示小数点后的位数

double(16,2)应该是这样写的

字段用发斜引号`***`试一试...

CREATE TABLE lixijisuan.Interest(

clientname VARCHAR(20) NOT NULL,
productname VARCHAR(40) NOT NULL,
guaranteemethod CHAR(8) NOT NULL,
loanpayment DOUBLE(13,2) NOT NULL,
loanperiodmonths DOUBLE(8,2) NOT NULL,
accountopeningdate DATE NOT NULL,
dateofexpiry DATE NOT NULL,
lendingrate DOUBLE(17,2) NOT NULL,
lendingrate(month) DOUBLE(17,2) NOT NULL,
loanbalance DOUBLE(13,2) NOT NULL,
writeofftheprincipal DOUBLE(13,2) NOT NULL,
arrears DOUBLE(13,2) NOT NULL,
irrevocableinterest DOUBLE(17,2) NOT NULL,
accountstatus VARCHAR(8) NOT NULL,
dateofclassification DATE NOT NULL,
classification VARCHAR(8) NOT NULL,
handlingbank INT(11) NOT NULL,
attn INT(11) NOT NULL,
PRIMARY KEY (clientname)
)