SitePoint Sponsor

User Tag List

Results 1 to 2 of 2
  1. #1
    SitePoint Enthusiast
    Join Date
    Dec 2006
    Posts
    88
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    MySQL 5.5.21 error

    Everything was fine until the hosting company upgraded MySQL to 5.5.21 version.

    I don't wat's wrong with this query in 5.5.21 version?
    Code MySQL:
    CREATE TABLE #__hp_temp (
     id INT(11) NOT NULL, 
    type MEDIUMTEXT NOT NULL, 
    suburb MEDIUMTEXT NOT NULL, 
    price MEDIUMTEXT NOT NULL, 
    pov MEDIUMTEXT NOT NULL, 
    sead MEDIUMTEXT NOT NULL, 
    more SET('more') NOT NULL, 
    PRIMARY KEY  (id)
    ) TYPE=MyISAM ;

    I'm getting error
    Code MySQL:
    You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near \'TYPE=MyISAM\' at line 10 SQL=CREATE TABLE jos_hp_temp (\n id INT(11) NOT NULL, \ntype MEDIUMTEXT NOT NULL, \nsuburb MEDIUMTEXT NOT NULL, \nprice MEDIUMTEXT NOT NULL, \npov MEDIUMTEXT NOT NULL, \nsead MEDIUMTEXT NOT NULL, \nmore SET(\'more\') NOT NULL, \nPRIMARY KEY (id)\n) TYPE=MyISAM ;

    Any idea?

    Thanks.

  2. #2
    SQL Consultant gold trophysilver trophybronze trophy
    r937's Avatar
    Join Date
    Jul 2002
    Location
    Toronto, Canada
    Posts
    39,021
    Mentioned
    53 Post(s)
    Tagged
    2 Thread(s)
    r937.com | rudy.ca | Buy my SitePoint book: Simply SQL
    "giving out my real stuffs"


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
  •