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: 412
        
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