I need to insert rows for the following SQL Query Id appreci
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));
Solution
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\');
