區(qū)別:表要加[],自動(dòng)增長(zhǎng)不同
mysql下的:
drop table admin;

create table admin(
????
????id int not null auto_increment primary key,
????adminid varchar(50),
????adminpwd varchar(50)
);
ms下的:
drop table [admin];

create table [admin](
????
????id int not null identity(1,1) primary key,
????adminid varchar(50),
????adminpwd varchar(50)
);

mysql與ms在建表的語(yǔ)句的區(qū)別