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
Get step-by-step solutions from verified subject matter experts
