MYSQL in PHPMYADMIN - create table relationship from one table

Posted by Stanley DecoWood on Stack Overflow See other posts from Stack Overflow or by Stanley DecoWood
Published on 2012-11-23T10:56:45Z Indexed on 2012/11/23 10:59 UTC
Read the original article Hit count: 312

I want to create a table relationship with MYSQL PHPMYADMIN.

I have this Create table:

CREATE TABLE students(code_students int(8)not null AUTO_INCREMENT,
name_students varchar(25),
age_students int(3),
degree_program varchar(25),
code_advisor int(8)not null,
primary key(code_students, code_advisor)
);

and i want to make a create table named advise relationship between code_students, code_advisor.

© Stack Overflow or respective owner

Related posts about mysql

Related posts about phpmyadmin