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 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... 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: Link to comment https://forums.phpfreaks.com/topic/588-a-mysql-table/#findComment-1970 Share on other sites More sharing options...
Recommended Posts
Archived
This topic is now archived and is closed to further replies.