SitePoint Sponsor

User Tag List

Results 1 to 3 of 3

Hybrid View

  1. #1
    SitePoint Wizard jonese's Avatar
    Join Date
    Jul 1999
    Location
    Powder Springs GA (Atlanta)
    Posts
    1,238
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)
    Anyone see anything wrong with this code?

    CREATE TABLE 3psub (ID INT not null AUTO_INCREMENT, 3PID INT not null , sub VARCHAR (220) not null , descrip LONGBLOB not null , price VARCHAR (220) not null , contract ENUM (y,n) DEFAULT 'y' not null , PRIMARY KEY (ID))
    MySQL


    i'm getting:

    MySQL said: You have an error in your SQL syntax near 'y,n) DEFAULT 'y' not null , PRIMARY KEY (ID))' at line 1

    please respond to jonese@atlantech.net

  2. #2
    Your Lord and Master, Foamy gold trophy Hierophant's Avatar
    Join Date
    Aug 1999
    Location
    Lancaster, Ca. USA
    Posts
    12,305
    Mentioned
    1 Post(s)
    Tagged
    0 Thread(s)
    Originally posted by jonese
    Anyone see anything wrong with this code?

    CREATE TABLE 3psub (ID INT not null AUTO_INCREMENT, 3PID INT not null , sub VARCHAR (220) not null , descrip LONGBLOB not null , price VARCHAR (220) not null , contract ENUM (y,n) DEFAULT 'y' not null , PRIMARY KEY (ID))
    MySQL


    i'm getting:

    MySQL said: You have an error in your SQL syntax near 'y,n) DEFAULT 'y' not null , PRIMARY KEY (ID))' at line 1

    please respond to jonese@atlantech.net
    change it to:
    CREATE TABLE 3psub (ID INT not null AUTO_INCREMENT, 3PID INT not null , sub VARCHAR (220) not null , descrip LONGBLOB not null , price VARCHAR (220) not null , contract ENUM ('y','n') DEFAULT 'y' not null , PRIMARY KEY (ID))
    Wayne Luke
    ------------


  3. #3
    SitePoint Wizard jonese's Avatar
    Join Date
    Jul 1999
    Location
    Powder Springs GA (Atlanta)
    Posts
    1,238
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)
    thanks wayne i changed it to 'Yes','No' and that worked. phpMYadmin must be funky.


Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •