Search code examples
mysqlsqlforeign-keyscreate-table

Foreign Key Unexpected

I'm using MySQL workbench and I am trying to create a table consist of foreign key using SQL Query. I am having problem with the Foreign part.

create table employee_position
(
ePID int primary key,
ePName varchar(45) not null,
eID int foreign key references employee_profile(eID)
)
Solution

  • Your syntax is wrong. Try:

    create table employee_position
(
ePID int primary key,
ePName varchar(45) not null,
eID int,
foreign key (keyname) references employee_profile(eID)
)

    For more information see the mysql documentation