Доброго времени суток!

Создал БД, выбрал её и попытался создать в ней таблицу. Скрипт прописываю как в учебники написано, но Workbench выдаёт ошибку (синтаксическую) и не компилирует. Не пойму в чём ошибка, так как указывает он на то, что не должно быть ошибкой.

Подскажите пожалуйста в чём причина и как исправить.




Ответы Workbench:
01:58:21 show databases 7 row(s) returned 0.000 sec / 0.000 sec
01:59:23 use climate 0 row(s) affected 0.000 sec

02:00:50 databases changed CREATE TABLE Climate(indexses tinyint, Region_of_the_World enum, Country enum, Locality varchar(30), Years timestamp, Months enum, Days enum, Temperature tinyint, Vlagnoste tinyint, Direction_of_the_wind varchar(5), Speed_of_wind tinyint) Error Code: 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 'databases changed CREATE TABLE Climate(indexses tinyint, Region_of_the_World enu' at line 1 0.000 sec

02:11:24 databases changed CREATE TABLE Climate(indexses INT NOT NULL PRIMARY KEY AUTO_INCREMENT, Region_of_the_World ENUM, Country ENUM, Locality VARCHAR(30), Years TIMESTAMP, Months ENUM, Days ENUM, Temperature INT, Vlagnoste INT, Direction_of_the_wind VARCHAR(5), Speed_of_wind INT) Error Code: 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 'databases changed CREATE TABLE Climate(indexses INT NOT NULL PRIMARY KEY AUTO_IN' at line 1 0.000 sec

02:11:53 CREATE TABLE Climate(indexses INT NOT NULL PRIMARY KEY AUTO_INCREMENT, Region_of_the_World ENUM, Country ENUM, Locality VARCHAR(30), Years TIMESTAMP, Months ENUM, Days ENUM, Temperature INT, Vlagnoste INT, Direction_of_the_wind VARCHAR(5), Speed_of_wind INT) Error Code: 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 ' Country ENUM, Locality VARCHAR(30), Years TIMESTAMP, Months ENUM, Days ENUM, T' at line 1 0.000 sec

02:20:35 CREATE TABLE Climate(indexses INT NOT NULL PRIMARY KEY AUTO_INCREMENT, Region_of_the_World ENUM, Country ENUM, Locality VARCHAR(30), Years TIMESTAMP, Months ENUM, Days ENUM, Temperature INT, Vlagnoste INT, Direction_of_the_wind VARCHAR(5), Speed_of_wind INT) ENGINE=InnoDB DEFAULT CHARSET=UTF8 Error Code: 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 ' Country ENUM, Locality VARCHAR(30), Years TIMESTAMP, Months ENUM, Days ENUM, T' at line 1 0.000 sec
[img=]

miksoft, попробовал - ошибка.





19:05:19 show databases 7 row(s) returned 0.000 sec / 0.000 sec

19:05:40 use climate 0 row(s) affected 0.000 sec

19:07:04 CREATE TABLE Climate(indexses INT NOT NULL PRIMARY KEY AUTO_INCREMENT, Region_of_the_World ENUM, Country ENUM, Locality VARCHAR(30), Years TIMESTAMP, Months ENUM, Days ENUM, Temperature INT, Vlagnoste INT, Direction_of_the_wind VARCHAR(5), Speed_of_wind INT) Error Code: 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 ' Country ENUM, Locality VARCHAR(30), Years TIMESTAMP, Months ENUM, Days ENUM, T' at line 1 0.000 sec

miksoft, спасибо! Ошибка устранена.