You forgot the comma before PRIMARY. Patrick -----Message d'origine----- De : Toth Dalibor [mailto:[EMAIL PROTECTED]] Envoyé : mardi 27 février 2001 09:51 A : '[EMAIL PROTECTED]' Objet : ? 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??!! Please, answer! Bye. --------------------------------------------------------------------- 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
