1. 论坛系统升级为Xenforo，欢迎大家测试！
    Dismiss Notice

问个数据库记录id的问题

Discussion in '后端开发' started by prolover, Nov 16, 2005.

  1. prolover

    prolover New Member

    Joined:
    Oct 10, 2005
    Messages:
    20
    Likes Received:
    0
    我用access或sql server都是这种情况，
    比如，表里存6条记录，删空后，他的自动排号第一条是7，
    如果我想让他重新从一排序，该如何？
     
    #1 prolover, Nov 16, 2005
  2. 小叶

    小叶 New Member

    Joined:
    Sep 4, 2005
    Messages:
    17,941
    Likes Received:
    33
    新建数据库,将原来的字段结构导入,
    记住不要数据.
     
    #2 小叶, Nov 16, 2005
  3. 不学无术

    不学无术 Ulysses 的元神

    Joined:
    Aug 31, 2005
    Messages:
    16,714
    Likes Received:
    39
    Access 可以压缩修复数据库。

    在“工具”菜单中有个“数据库实用工具”-“压缩和修复数据库”。

    MS SQL 因为没有用过所以不是很清楚。
     
    #3 不学无术, Nov 16, 2005
  4. 老林

    老林 New Member

    Joined:
    Sep 6, 2005
    Messages:
    10,580
    Likes Received:
    36
    SQL
    删除那个"ID"的列　重新建一个就OK了
     
    #4 老林, Nov 16, 2005
  5. Tameway

    Tameway New Member

    Joined:
    Sep 6, 2005
    Messages:
    1,286
    Likes Received:
    8
    ID列通常是主键，建议采用新建表，把字段转移过去的办法
     
    #5 Tameway, Nov 16, 2005
  6. prolover

    prolover New Member

    Joined:
    Oct 10, 2005
    Messages:
    20
    Likes Received:
    0
    多谢，我的明白^_^
     
    #6 prolover, Nov 18, 2005
(You must log in or sign up to post here.)
Toggle Width
Language
English (US)