On Thursday 04 November 2004 02:28 pm, Scott Hamm wrote: > create table account ( > ID int auto_increment, > Date date, > Check_Number int(5), > Bank_Match int enum(0,1), > Category varchar(20) no null, > Credit decimal(7,2), > Debit decimal(7,2), > Balance decimal(7,2), > primary key (ID) > );
Its pretty clear, there is no int there.. Take it out and it should work.
Example:
CREATE TABLE `syslog` (
`id` int(11) NOT NULL auto_increment,
`machine` varchar(50) NOT NULL default '',
`facility`
enum('auth','authpriv','cron','daemon','kern','lpr','mail','mark','news','security','syslog','user','uucp','local0','local1','local2','local3','local4','local5','local6','local7')
NOT NULL default 'syslog',
`priority`
enum('debug','info','notice','warning','warn','err','error','crit','alert','emerg','panic')
NOT NULL default 'notice',
`date1` timestamp(14) NOT NULL,
`message` text NOT NULL,
`trnsfr` char(1) default 'n',
PRIMARY KEY (`id`)
) TYPE=MyISAM
Jeff
pgp8Z1dDKHSNN.pgp
Description: PGP signature
