I need to insert rows for the following SQL Query. I`d appreciate any examples s
ID: 3926039 • Letter: I
Question
I need to insert rows for the following SQL Query. I`d appreciate any examples so I can put it in my SQL table
CREATE TABLE department
(
dep_ID int NOT NULL,
depart_Name varchar(255)
NOT NULL, manager varchar(255),
PRIMARY KEY (dep_id));
CREATE TABLE employee
(
emp_Id int NOT NULL,
dept_code int NOT NULL,
fname varchar (255) NOT NULL,
lname varchar (255) NOT NULL,
DOB varchar (255) NOT NULL,
manager_id int NOT NULL,
hiredate varchar (255) NOT NULL,
Classification varchar (255),
Primary Key (emp_id));
Explanation / Answer
Department Example -
insert into Department values(1,'HR','john');
Example employee -
insert into Employee values(12,1,'san','san','25-10-1991',2,'10-10-2010','abc');