BurningOD Posted June 14, 2003 Share Posted June 14, 2003 ok..i got to make a mySQL table in my database at www.coolfreepage.com..is the host..and i get this stupid error MySQL said: You have an error in your SQL syntax near \'log( id int( 3 ) unsigned NOT NULL AUTO_INCREMENT , info blob, ip text, PRIM\' at line 1 Im useing phpmyadmin to edit my database...any help on correction this would be nice thx Quote Link to comment https://forums.phpfreaks.com/topic/588-a-mysql-table/ Share on other sites More sharing options...
effigy Posted June 14, 2003 Share Posted June 14, 2003 what is the full sql? it looks like you have a spare paren in there... Quote Link to comment https://forums.phpfreaks.com/topic/588-a-mysql-table/#findComment-1969 Share on other sites More sharing options...
BurningOD Posted June 14, 2003 Author Share Posted June 14, 2003 CREATE TABLE log ( id int(3) unsigned NOT NULL auto_increment, info blob, ip text, PRIMARY KEY (id), UNIQUE KEY id (id), KEY id_2 (id) ) TYPE=MyISAM; is the full code..since im a newbie at php i can somewhat make the scripts and such..but finding errors is just not a thing for me :-/ :oops: Quote Link to comment https://forums.phpfreaks.com/topic/588-a-mysql-table/#findComment-1970 Share on other sites More sharing options...
Recommended Posts
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.