mysql 更改表的主键为auto_increment

Posted by bower on August 06, 2009
mysql

their explanation 分享给你的朋友->bookmark bookmark bookmark bookmark bookmark bookmark bookmark bookmark bookmark

change the primary key for a table in mysql

Discover More 创建:
mysql> create table ref (ref_id int unsigned not null, something varchar(30), primary key(ref_id));
更改:
mysql>alter table ref drop primary key , add column newcol int auto_increment PRIMARY KEY ;

http://onsc4x4.com/?mariypol=rencontre-handicap-leger&8a9=f7 Get the facts 分享到:人人网开心网腾讯微博新浪微博豆瓣分享腾讯空间百度搜藏腾讯书签

rencontre avec des hommes remarquables dvd 分享给你的朋友->bookmark bookmark bookmark bookmark bookmark bookmark bookmark bookmark bookmark

Leave a Reply

http://devrimcicephe.org/vistawkoe/1970 Your email address will not be published. Required fields are marked *

http://www.capacuras.com/?rtyt=rencontre-serieuse-region-centre&b10=29

http://aquanetta.pl/?kostromesp=opcje-binarne-podatek&51c=7c

Read More Here

http://ramblingroseboutique.com/?prertwe=hookup-site-ranking&a91=d6

*
To prove you're a person (not a spam script), type the security word shown in the picture. Click on the picture to hear an audio file of the word.
Click to hear an audio file of the anti-spam word