mysql外键约束和oracle的外键约束有点不一样,
mysql的外键约束示例代码如下:
oracle的示例代码如下:
mysql的外键约束示例代码如下:
create table student(
id int primary key ,
name varchar(20),
class_id int ,
foreign key(class_id) references class(id));
create table class (id int primary key,
name varchar(20));
oracle的示例代码如下:
create table student(
id number primary key ,
name varchar2(20),
class_id number references class(id));
create table class (id number primary key,
name varchar2(20));