阿里云mysql建表自增主键问题

Question

我要在阿里云上实现这样一个功能，从数据库中抽一部分字段，插入到新建表中，新建表要额外加一个主键id，要自增，一直报错，基本代码如下；

CREATE TABLE table_a (
  `id` int(11) NOT NULL UTO_INCREMENT,,
  `id_card_number` varchar(18) NOT NULL,
  PRIMARY KEY (`id`),
  KEY (`id_card_number`),
) ENGINE=InnoDB AUTO_INCREMENT=1 DEFAULT CHARSET=utf8 AVG_ROW_LENGTH=153
;
INSERT INTO table_a
SELECT a.id_card_number
FROM table_b a
;

求救

Answer 1

CREATE TABLE table_a (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `id_card_number` varchar(18) NOT NULL,
  PRIMARY KEY (`id`),
  KEY (`id_card_number`),
) ENGINE=InnoDB AUTO_INCREMENT=1 DEFAULT CHARSET=utf8 AVG_ROW_LENGTH=153
;
INSERT INTO table_a(id_card_number)
SELECT a.id_card_number
FROM table_b a
;

解决了