Jump to content

Dale_H

New Members
  • Posts

    3
  • Joined

  • Last visited

    Never

Profile Information

  • Gender
    Not Telling

Dale_H's Achievements

Newbie

Newbie (1/5)

0

Reputation

  1. I am using PHP My Admin, how do you add the number to the key if posable?
  2. I am teaching my self database and I ran into a snage, my table will not build right. here is my bad code CREATE TABLE `Monitors` ( `Type` TEXT( 25 ) NOT NULL , `Size` INT( 10 ) NOT NULL , `Price` FLOAT( 10 ) NOT NULL , `Descripton` LONGTEXT( 60 ) NOT NULL , PRIMARY KEY ( `Type` ) ) COMMENT = \'The type, size, price, and description of the moniters in stock.\' and here is the error MySQL said: You have an error in your SQL syntax near \'(25) NOT NULL, `Size` INT(10) NOT NULL, `Price` FLOAT(10) NOT NULL, `Descripton`\' at line 1 P.S. This is not a home work or anything, this is just a exsample database Any help would be cool
×
×
  • Create New...

Important Information

We have placed cookies on your device to help make this website better. You can adjust your cookie settings, otherwise we'll assume you're okay to continue.