abelyao
V2EX  ›  问与答

请问 mysql 如何在一个已有几百行数据的表中,添加一个 AI 字段?

  •  
  •   abelyao · Sep 29, 2014 · 3028 views
    This topic created in 4426 days ago, the information mentioned may be changed or developed.
    5 replies  •  2014-09-29 09:54:09 +08:00
    fdsfsdfsdf3334
    fdsfsdfsdf3334
    Sep 29, 2014
    1
    字段属性 要 可空
    roadli
    roadli
    Sep 29, 2014
    2
    alter table,字段要么可为空,要么设个缺省值
    qiayue
    qiayue
    Sep 29, 2014
    3
    几百行不多,用程序拿出来再插入一遍
    abelyao
    abelyao
    OP
    Sep 29, 2014
    4
    @fdsfsdfsdf3334 @roadli
    搞定了,要先把原有的主键去掉,然后直接加入一个 AI 字段作为主键就好了
    fising
    fising
    Sep 29, 2014
    5
    ALTER TABLE `tbTest` ADD `index` INT NOT NULL AUTO_INCREMENT FIRST ,
    ADD PRIMARY KEY ( `index` )

    执行前要删除Primary key
    About   ·   Help   ·   Advertise   ·   Blog   ·   API   ·   FAQ   ·   Privacy   ·   Solana   ·   2242 Online   Highest 6679   ·     Select Language
    创意工作者们的社区
    World is powered by solitude
    VERSION: 3.9.8.5 · 27ms · UTC 13:39 · PVG 21:39 · LAX 05:39 · JFK 08:39
    ♥ Do have faith in what you're doing.