mysql数据库中查询表出错_MySQL数据库中见表出错

Enterpassword:****WelcometotheMySQLmonitor.Commandsendwith;or\g.YourMySQLconnectionidis6Serverversion:5.1.33-communityMySQLCommunityServer(GPL)Type'help;'or'\h'forhelp.Ty...

Enter password: ****

Welcome to the MySQL monitor. Commands end with ; or \g.

Your MySQL connection id is 6

Server version: 5.1.33-community MySQL Community Server (GPL)

Type 'help;' or '\h' for help. Type '\c' to clear the buffer.

mysql> use bbs;

Database changed

mysql> CREATE TABLE IF NOT EXISTS board(

-> boardid int(11) NOT NULL AUTO_INCREMENT,

-> BoardType varchar(50) NOT NULL DEFAULT'',

-> class int(11) NOT NULL DEFAULT'0',

-> readme varchar(255) NOT NULL DEFAULT'',

-> BoardMaster varchar(50) NOT NULL DEFAULT'',

-> lockboard int(11) NOT NULL DEFAULT'0',

-> boardskin int(11) NOT NULL DEFAULT'0',

-> Tabletitle varchar(50) NOT NULL DEFAULT'',

-> Tablebody varchar(50) NOT NULL DEFAULT'',

-> aTablebody varchar(50) NOT NULL DEFAULT'',

-> TableFont varchar(50) NOT NULL DEFAULT'',

-> TableContent varchar(50) NOT NULL DEFAULT'',

-> AlerFont varchar(50) NOT NULL DEFAULT'',

-> lastpostuser varchar(50) NOT NULL DEFAULT'',

-> lastposttime datetime NOT NULL DEFAULT'0000-00-00 00:00:00',

-> lastbbsnum int(11) NOT NULL DEFAULT'0',

-> lasttopicnum int(11) NOT NULL DEFAULT'0',

-> strAllowForumCode int(11) NOT NULL DEFAULT'0'

-> strMGInPosts int(11) NOT NULL DEFAULT'0',

-> strAllowHTML int(11) NOT NULL DEFAULT'0',

-> strIcons int(11) NOT NULL DEFAULT'0',

-> strflash int(11) NOT NULL DEFAULT'0',

-> Forumlogo varchar(255) NOT NULL DEFAULT'',

-> indexIMG varchar(255) NOT NULL DEFAULT'',

-> lastrootid in(11) NOT NULL DEFAULT'0',

-> lasttopic varchar(255) NOT NULL DEFAULT'',

-> todayNum int(11) NOT NULL DEFAULT'0',

-> boarduser text NOT NULL ,

-> PRIMARY KEY(boardid)

-> );

ERROR 1064 (42000): 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 'strMG

InPosts int(11) NOT NULL DEFAULT'0',

strAllowHTML int(11) NOT NULL DEFAULT'' at line 20

mysql>

db.properties文件中的drivers 的value 是不是必须得填 org.gjt.mm.mysql.Driver。mysql.url的value 填jdbc:mysql://localhost/bbs?user=root&password=&useUnicode=true&characterEncoding=GBK对不对？

程序启动说连接不到数据库 是怎么回事

org.apache.jasper.servlet.JspServletWrapper.handleJspException(JspServletWrapper.java:522)

org.apache.jasper.servlet.JspServletWrapper.service(JspServletWrapper.java:398)

org.apache.jasper.servlet.JspServlet.serviceJspFile(JspServlet.java:342)

org.apache.jasper.servlet.JspServlet.service(JspServlet.java:267)

javax.servlet.http.HttpServlet.service(HttpServlet.java:717)

org.apache.jsp.index_jsp._jspService(index_jsp.java:183)

org.apache.jasper.runtime.HttpJspBase.service(HttpJspBase.java:70)

javax.servlet.http.HttpServlet.service(HttpServlet.java:717)

org.apache.jasper.servlet.JspServletWrapper.service(JspServletWrapper.java:374)

org.apache.jasper.servlet.JspServlet.serviceJspFile(JspServlet.java:342)

展开