已执行的 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
已采纳
sql语句这个错误怎么改
- 写回答
- 好问题 提建议
- 追加酬金
- 关注问题
- 分享
- 邀请回答