mysql - 创建表 MYSQL 时出错 : SYNTAX

Question

  CREATE TABLE IF NOT EXISTS `pforum` 

( 
    pf_id int(10) NOT NULL auto_increment, 
    pf_name varchar(50) NOT NULL, 
    pf_title varchar(255) NOT NULL, 
    pf_ppost varchar(1000) NOT NULL, 
    pf_aud varchar(20) NOT NULL, 
    pf_username varchar(20) NOT NULL, 
    pf_date timestamp(14) NOT NULL, 
    pf_status  int(1) DEFAULT 0 NOT NULL, 
    PRIMARY KEY (pr_id) 

    )  ENGINE=MyISAM  DEFAULT CHARSET=latin1 ;

    CREATE TABLE IF NOT EXISTS `p_reset`
( 
     pr_id int(10) NOT NULL auto_increment, 
     pr_name varchar(50) NOT NULL, 
     pr_email varchar(255) NOT NULL, 
     pr_dob varchar(20) NOT NULL, 
     pr_roll varchar(20) NOT NULL, 
     pr_date timestamp(14) NOT NULL, 
     pr_status int(1) DEFAULT 0 NOT NULL, 
     PRIMARY KEY (pr_id) ) ;

我已经检查了可能的原因，但仍然收到错误 1064 。

Answer 1

pf_date timestamp(14) NOT NULL, 

到

pf_date timestamp  NOT NULL, 

并且

pr_date timestamp(14) NOT NULL, 

至

pr_date timestamp  NOT NULL, 

这是正确的

CREATE TABLE IF NOT EXISTS `pforum` 

( 
    pf_id int(10) NOT NULL auto_increment, 
    pf_name varchar(50) NOT NULL, 
    pf_title varchar(255) NOT NULL, 
    pf_ppost varchar(1000) NOT NULL, 
    pf_aud varchar(20) NOT NULL, 
    pf_username varchar(20) NOT NULL, 
    pf_date timestamp  NOT NULL, 
    pf_status  int(1) DEFAULT 0 NOT NULL, 
    PRIMARY KEY (pf_id) 

    )  ENGINE=MyISAM  DEFAULT CHARSET=latin1 ;

    CREATE TABLE IF NOT EXISTS `p_reset`
( 
     pr_id int(10) NOT NULL auto_increment, 
     pr_name varchar(50) NOT NULL, 
     pr_email varchar(255) NOT NULL, 
     pr_dob varchar(20) NOT NULL, 
     pr_roll varchar(20) NOT NULL, 
     pr_date timestamp NOT NULL, 
     pr_status int(1) DEFAULT 0 NOT NULL, 
     PRIMARY KEY (pr_id) ) ;

第一个创建语句中的键名称也错误。

http://sqlfiddle.com/#!2/dd3e4f/1