Witam,
Chciałem stworzyć tabelę:
CREATE TABLE countries (
id SMALLINT(6) UNSIGNED NOT NULL AUTO_INCREMENT,
code CHAR(4) NOT NULL,
united_europe TINYINT(1) UNSIGNED NOT NULL,
name VARCHAR(100) CHARACTER SET utf8 COLLATE utf8_polish_ci NOT NULL
PRIMARY KEY (id),
UNIQUE INDEX name (name)
)
ENGINE = INNODB
CHARACTER SET utf8
COLLATE utf8_general_ci
MySQL zwrócił komunikat: Dokumentacja
#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 '(id),
UNIQUE INDEX name (name)
)