abelyao
V2EX  ›  问与答

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

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

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