*primary key: create table table_name(field_name1 datatype(field_size)primary key,
field_name2 datatype(field_size))engine=innodb;
*foreign key: create table table_name(field_name1 datatype(field_size)primary key,
field_name2 datatype(field_size),
foreign key(foreing_key_in_table) references table_name_to_be_refer(primary_key_to_be_references))engine=innodb;
No comments:
Post a Comment