mysql客户端执行“create database BBS;”命令,数据库创建成功后,再执行“use BBS;”命令,
然后执行“F:/phpdocs/BBS.sql;”命令,导入数据库表。
为什么出错???
sql语句:
CREATE TABLE `userinfo` (
`userID` varchar(20) NOT NULL,
`password` varchar(20) NOT NULL,
`username` varchar(20) default NULL,
`addr` varchar(50) default NULL,
`postcode` varchar(20) default NULL,
`phone` varchar(20) default NULL,
`fax` varchar(20) default NULL,
`mobile` varchar(20) default NULL,
`E_mail` varchar(50) default NULL,
`credentials` tinyint(4) NOT NULL,
`crednumber` int(60) NOT NULL,
`host` int(11) default NULL,
`regtime` datetime default NULL,
`pubNum` int(11) default NULL,
PRIMARY KEY (`userID`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;CREATE TABLE `bbs` (
`cardID` smallint(5) NOT NULL auto_increment,
`poster` varchar(50) NOT NULL,
`posttime` datetime NOT NULL,
`title` varchar(100) NOT NULL,
`content` text NOT NULL,
`repID` smallint(5) default NULL,
`lastReptime` datetime default NULL,
`repNum` int(11) default '0',
`conNum` int(11) default '0',
`subjectID` smallint(5) NOT NULL default '1',
`IP` varchar(50) default NULL,
PRIMARY KEY (`cardID`)
) ENGINE=MyISAM AUTO_INCREMENT=61 DEFAULT CHARSET=latin1;CREATE TABLE `subject` (
`subjectID` SMALLINT(5) NOT NULL AUTO_INCREMENT,
`subjectName` VARCHAR(20) NOT NULL,
PRIMARY KEY (`subjectID`))ENGINE=MyISAM;CREATE TABLE `cred` (
`credentials` tinyint(4) NOT NULL auto_increment,
`credname` varchar(20) NOT NULL,
PRIMARY KEY (`credentials`)
) ENGINE=MyISAM AUTO_INCREMENT=2 DEFAULT CHARSET=latin1;
mysql->source F:/phpdocs/BBS.sql;