Results 1 to 2 of 2
Thread: MySQL new version error
Apr 28, 2012, 01:30 #1
- Join Date
- Dec 2006
- 0 Post(s)
- 0 Thread(s)
MySQL new version 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?
I'm getting error
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 ;