Question: how do i change this from sql server to mysql to refrence the foreign key -- FOREIGN KEY reference to [TypeId] in [EmployeeType] table ALTER

how do i change this from sql server to mysql to refrence the foreign key

-- FOREIGN KEY reference to [TypeId] in [EmployeeType] table

ALTER TABLE [ECH].[Employees] WITH CHECK ADD CONSTRAINT [FK_Employees_EmployeeType] FOREIGN KEY([EmpType])

REFERENCES [ECH].[EmployeeType] ([TypeId])

ALTER TABLE [ECH].[Employees] CHECK CONSTRAINT [FK_Employees_EmployeeType]

Insert Into [ECH].[Employees] (EmpType, Name) Values (1,'Emp 11')

Insert Into [ECH].[Employees] (EmpType, Name) Values (2,'Emp 21')

Insert Into [ECH].[Employees] (EmpType, Name) Values (3,'Emp 31')

Insert Into [ECH].[Employees] (EmpType, Name) Values (4,'Emp 41')

Insert Into [ECH].[Employees] (EmpType, Name) Values (5,'Emp 51')

Insert Into [ECH].[Employees] (EmpType, Name) Values (6,'Emp 61')

Insert Into [ECH].[Employees] (EmpType, Name) Values (7,'Emp 71')

Insert Into [ECH].[Employees] (EmpType, Name) Values (8,'Emp 81')

Insert Into [ECH].[Employees] (EmpType, Name) Values (9,'Emp 91')

Insert Into [ECH].[Employees] (EmpType, Name) Values (1,'Emp 12')

Insert Into [ECH].[Employees] (EmpType, Name) Values (2,'Emp 22')

Insert Into [ECH].[Employees] (EmpType, Name) Values (3,'Emp 32')

Insert Into [ECH].[Employees] (EmpType, Name) Values (4,'Emp 42')

Insert Into [ECH].[Employees] (EmpType, Name) Values (5,'Emp 52')

Insert Into [ECH].[Employees] (EmpType, Name) Values (6,'Emp 62')

Insert Into [ECH].[Employees] (EmpType, Name) Values (7,'Emp 72')

Insert Into [ECH].[Employees] (EmpType, Name) Values (8,'Emp 82')

Insert Into [ECH].[Employees] (EmpType, Name) Values (9,'Emp 92')

Insert Into [ECH].[Employees] (EmpType, Name) Values (1,'Emp 13')

Insert Into [ECH].[Employees] (EmpType, Name) Values (2,'Emp 23')

Insert Into [ECH].[Employees] (EmpType, Name) Values (3,'Emp 33')

Insert Into [ECH].[Employees] (EmpType, Name) Values (4,'Emp 43')

Insert Into [ECH].[Employees] (EmpType, Name) Values (5,'Emp 53')

Insert Into [ECH].[Employees] (EmpType, Name) Values (6,'Emp 63')

Insert Into [ECH].[Employees] (EmpType, Name) Values (7,'Emp 73')

Insert Into [ECH].[Employees] (EmpType, Name) Values (8,'Emp 83')

Insert Into [ECH].[Employees] (EmpType, Name) Values (9,'Emp 93')

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related Databases Questions!