MySQL

create table problems

Please support our MySQL advertiser: PostgreSQL or MySQL? Compare and contrast the two most popular open source databases

Thread Solved

•

Join Date: Apr 2009

Posts: 56

Reputation: baki100 is an unknown quantity at this point

Solved Threads: 11

baki100

Offline

Junior Poster in Training

create table problems

Oct 3rd, 2009

can someone help me identify the syntax error with this code

 Help with Code Tags 
 MySQL Syntax (Toggle Plain Text) 
CREATE  TABLE IF NOT EXISTS Persons 
(  id_number VARCHAR(13) NOT NULL 
    ,  name VARCHAR(45) NOT NULL 
    ,  name_2 VARCHAR(45) NULL 
    ,  name_3 VARCHAR(45) NULL 
    ,  surname VARCHAR(45) NOT NULL 
    ,  date_created DATE
    ,  date_modified DATE
    ,  PRIMARY KEY (id_number) 
    ,  INDEX per_id_fk (id_number ASC) 
    ,  INDEX per_stat_fk (id_number ASC) 
    ,  CONSTRAINT per_id_fk    FOREIGN KEY (id_number )    REFERENCES Person_Image (id_number )    ON DELETE CASCADE    ON UPDATE CASCADE
    ,  CONSTRAINT per_stat_fk    FOREIGN KEY (id_number )    REFERENCES Current_Status (id_number )    ON DELETE CASCADE    ON UPDATE CASCADE
)
CREATE  TABLE IF NOT EXISTS Persons 
(  id_number VARCHAR(13) NOT NULL 
    ,  name VARCHAR(45) NOT NULL 
    ,  name_2 VARCHAR(45) NULL 
    ,  name_3 VARCHAR(45) NULL 
    ,  surname VARCHAR(45) NOT NULL 
    ,  date_created DATE
    ,  date_modified DATE
    ,  PRIMARY KEY (id_number) 
    ,  INDEX per_id_fk (id_number ASC) 
    ,  INDEX per_stat_fk (id_number ASC) 
    ,  CONSTRAINT per_id_fk    FOREIGN KEY (id_number )    REFERENCES Person_Image (id_number )    ON DELETE CASCADE    ON UPDATE CASCADE
    ,  CONSTRAINT per_stat_fk    FOREIGN KEY (id_number )    REFERENCES Current_Status (id_number )    ON DELETE CASCADE    ON UPDATE CASCADE
)