一、SQL中:
sql="CREATE TABLE phone ("&_
"ID [int] IDENTITY (1, 1),"&_
"username char(20) NOT NULL,"&_
"pass char(20) NOT NULL,"&_
"shi char(20) NULL)"
二、Access中:
create table mytable( id counter CONSTRAINT id PRIMARY KEY,f1 varchar(20), f2 int)
三、Oracle中:
1、先创建 sequence: create sequence seqmax increment by 1
2、得到一个ID的语句:select seqmax.nextval ID from dual
3、把这个语句放到触发器中,就可以实现和SQL中自动增加ID的功能。