(1)create sequence seq_user_id increment 1 start 20000;

(2)alter table userinfos alter column user_id set default nextval('seq_user_id');

(3)create table userinfos
(
?user_id int8? default nextval('seq_user_id') primary key
?user_name varchar(40)
)




|----------------------------------------------------------------------------------------|
                           版權(quán)聲明  版權(quán)所有 @zhyiwww
            引用請(qǐng)注明來源 http://www.aygfsteel.com/zhyiwww   
|----------------------------------------------------------------------------------------|