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

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 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')

Explanation / Answer

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');

Related Questions

Navigate

• Browse (All)
• Browse H
• Subjects

Integrity-first tutoring: explanations and feedback only — we do not complete graded work. Learn more.