Просмотр поста

Ошибка

SQL-запрос: 

DROP TABLE `news` --
-- Структура таблицы `news`
--
CREATE TABLE IF NOT EXISTS `news` (
`id` int( 11 ) NOT NULL AUTO_INCREMENT ,
`title` varchar( 500 ) NOT NULL ,
`text` text NOT NULL ,
`time` int( 11 ) NOT NULL ,
`name` varchar( 50 ) NOT NULL ,
`rating` varchar( 50 ) NOT NULL DEFAULT '0|0',
`type` int( 1 ) NOT NULL ,
`name_id` int( 11 ) NOT NULL ,
`prosm` int( 11 ) NOT NULL ,
`name_dir` text NOT NULL ,
`scrin` varchar( 50 ) NOT NULL ,
`metk1` varchar( 50 ) NOT NULL ,
`metk2` varchar( 50 ) NOT NULL ,
`metk3` varchar( 50 ) NOT NULL ,
PRIMARY KEY ( `id` ) 
) ENGINE = MYISAM DEFAULT CHARSET = utf8 AUTO_INCREMENT =49;



Ответ MySQL:  
#1064 - 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 'CREATE TABLE IF NOT EXISTS `news` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  ' at line 7