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

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, de

Get Help Now

Submit a Take Down Notice

Tutor
Tutor: Dr Jack
Most rated tutor on our site