Jump to content


Photo

a mySQL table


  • Please log in to reply
2 replies to this topic

#1 BurningOD

BurningOD
  • New Members
  • Pip
  • Newbie
  • 2 posts

Posted 14 June 2003 - 01:30 AM

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

#2 effigy

effigy
  • Staff Alumni
  • Advanced Member
  • 3,600 posts
  • LocationIL

Posted 14 June 2003 - 01:52 AM

what is the full sql? it looks like you have a spare paren in there...
Regexp | Unicode Article | Letter Database
/\A(e)?((1)?ff(?:(?:ig)?y)?|f(?:ig)?)\z/

#3 BurningOD

BurningOD
  • New Members
  • Pip
  • Newbie
  • 2 posts

Posted 14 June 2003 - 01:57 AM

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:




0 user(s) are reading this topic

0 members, 0 guests, 0 anonymous users