MySQL 在列上设置类型

Question

我试图让我的列在 MySQL 上为集合类型，但出现错误:

Syntax error near 'COLLATE 'latin1_swedish_ci' NOT NULL FIRST, COMMENT='' REMOVE PARTITIONING' at line 2

ALTER TABLE `Recipe`
CHANGE `Ingredients` `Ingredients` set COLLATE 'latin1_swedish_ci' NOT NULL FIRST,
COMMENT=''
REMOVE PARTITIONING;

请帮助和赞赏。

Answer 1

COLLATE 应该在 CHARACTER SET 之后，这是表级的，而不是列级的。

ALTER TABLE `Recipe`
CHANGE `Ingredients` `Ingredients` INT NOT NULL FIRST,
COMMENT=''
CHARACTER SET 'latin1' COLLATE 'latin1_swedish_ci'
REMOVE PARTITIONING;

SQLFidele 演示: http://sqlfiddle.com/#!9/d2f62a