deptid int primary key not null auto_increment,
deptname nvarchar(50)
)AUTO_INCREMENT=1;
Create Table Employee(
empid int primary key not null auto_increment,
empname nvarchar(50),
salary int,
gender nvarchar(50),
deptid int not null,
FOREIGN KEY (deptid) REFERENCES Department(deptid)
)AUTO_INCREMENT=1;
沒有留言:
張貼留言