On Tue, Feb 27, 2001 at 09:51:02AM +0100, Toth Dalibor wrote: > DROP TABLE IF EXISTS recepti; > CREATE TABLE recepti ( > rid smallint(6) NOT NULL auto_increment, > put varchar(20), > nazivStranice varchar(15), > nazivRecepta varchar(60), > brojOsoba varchar(15), > uvod text, > slika varchar(40), > nacinPripreme text, > savjet text NOT NULL, > vrijemePripreme_min tinyint(3) unsigned, > energVrijedJednogObroka_kJ smallint(6), > datumEmitiranja_maleTajne date DEFAULT '0000-00-00' NOT NULL, > izvorRecepta varchar(50) NOT NULL, > FULLTEXT (uvod,nacinPripreme) > PRIMARY KEY (rid) > ); > > MySQL said: You have an error in your SQL syntax near 'PRIMARY KEY (rid) )' > at line 16 > > What is wrong here??!! It seems you forgot a comma after the FULLTEXT line. Fred. -- Fred van Engen XO Communications B.V. email: [EMAIL PROTECTED] Televisieweg 2 tel: +31 36 5462400 1322 AC Almere fax: +31 36 5462424 The Netherlands --------------------------------------------------------------------- Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php