Mysql table prblem

frieza · 01-28-2008, 06:17 PM

this table script has a syntax error

Code:

CREATE TABLE info {
   fullname varchar(50) NOT NULL default '',
   inout varchar(20) NOT NULL default '',
   timestamp bigint(14) default NULL,
   notes varchar(250) default NULL,
   KEY fullname (fullname);
) TYPE=MyISAM;

perhaps someone could kindly point out what is?
thanks in advance

sydney-troz · 01-28-2008, 09:36 PM

Your closing bracket is round ) not a curly brace }. You must be tired

frieza · 01-29-2008, 05:43 PM

oops.. hehe, thx (i was reading the problem table off an xterm session connected via ssh), the problem was solved, the actual table had the ( not the {.. it was the inout and the timestamp labels that were the problem