Wednesday, July 30, 2014

ERROR 1064 (42000) at line 19: mailwatch


'-------------Old---------------------'
CREATE TABLE audit_log (
  timestamp timestamp(14) NOT NULL,
  user varchar(20) NOT NULL default '',
  ip_address varchar(15) NOT NULL default '',
  action text NOT NULL
) TYPE=MyISAM;


'---------------Edit----------------------'

CREATE TABLE audit_log (
  timestamp timestamp NOT NULL,
  user varchar(20) NOT NULL default '',
  ip_address varchar(15) NOT NULL default '',
  action text NOT NULL
) ;

Delete (14) and TYPE=MyISAM;

ทุกฟิวด์ในดาต้าเบส