MySQL 1064 Error Creating a Linking Table (Many-to-Many)

Question

I'm trying to understand why a parsing error occurred (1064) with the following code.

<#1064 - You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '' at line 3>

CREATE TABLE Party_Library
(
    Party INT(11)
    Library varchar(40)
    PRIMARY KEY (Library,Party)
    FOREIGN KEY (Party) REFERENCES Party(PartyKey) ON DELETE CASCADE
    FOREIGN KEY (Library) REFERENCES MusicLibraries(MusicSource) ON DELETE CASCADE
)

Yep, that solved it. John Conde gave a specific answer. – XYZ Rose Feb 07 '15 at 05:31 — XYZ Rose, Feb 07 '15 at 05:31

score 0 · Accepted Answer · answered Feb 07 '15 at 01:28

You are missing commas after each declaration:

CREATE TABLE Party_Library
(
    Party INT(11),
    Library varchar(40),
    PRIMARY KEY (Library,Party),
    FOREIGN KEY (Party) REFERENCES Party(PartyKey) ON DELETE CASCADE,
    FOREIGN KEY (Library) REFERENCES MusicLibraries(MusicSource) ON DELETE CASCADE
);

MySQL 1064 Error Creating a Linking Table (Many-to-Many)

1 Answers1