$dcr_pp="CREATE TABLE dcr_pp(id int(10) NOT NULL auto_increment primary key,orderid int(10) NOT NULL default 0,ppname VARCHAR(30) NOT NULL,province VARCHAR(10) NOT NULL default '',city VARCHAR(10) NOT NULL default '',companyname VARCHAR(50) NOT NULL,tel VARCHAR(20) NOT NULL,click int(10) NOT NULL,weburl VARCHAR(50) NOT NULL,spurl VARCHAR(50) NOT NULL,address VARCHAR(100) NOT NULL,qq VARCHAR(12) NOT NULL,logo VARCHAR(50) NOT NULL,tuijian BOOLEAN NOT NULL default false,content TEXT (600) NOT NULL,addtime DATE NOT NULL)"; //新建表语句dcr_pp创建失败:You have an error in your SQL syntax near 'BOOLEAN NOT NULL default false,content TEXT (600) NOT NULL,addtime DATE NOT NULL' at line 1 $dcr_jm="CREATE TABLE dcr_jm(id int(10) NOT NULL auto_increment primary key,targetcompany VARCHAR(50) NOT NULL,targetid int(10) NOT NULL default 0,rellname VARCHAR(10) NOT NULL,tel VARCHAR(30) NOT NULL,email VARCHAR(50) NOT NULL,area VARCHAR(50) NOT NULL,content TEXT (600) NOT NULL,userip VARCHAR(18) NOT NULL default '',addtime DATE NOT NULL)"; //新建表语句dcr_jm创建失败:You have an error in your SQL syntax near '(600) NOT NULL,userip VARCHAR(18) NOT NULL default '',addtime DATE NOT NULL)' at line 1
解决方案 »
免费领取超大流量手机卡,每月29元包185G流量+100分钟通话, 中国电信官方发货