Untitled

create database employee
use employee

create table employee_tbl

(

EmpID Int primary key,

Firstkame varchar(50),

LastName varchar(50),

Salary float,

MobileNo varchar(15)
);



insert into employee_tbl values(9, 'Kaman', 'singh',50009, '986645632');

select * from employee_tbl

delete from employee_tbl where EmpID=0

update employee_tbl set Firstkame= 'rajjat' where EmpID=9