SQL Create Table and Insert Data

CREATE Table:

create table employeeinfo(name varchar(20), age varchar(10), address varchar(40), salary varchar(50));

SHOW Tables:

show tables;

Tables_in_studentinfo
employeeinfo

INSERT Data:

insert into employeeinfo values(‘Komal’,’25’,’Mumbai’,’5000′);

SHOW Table:

select * from employeeinfo;

name age address salary
Komal 25 Mumbai 5000
Ramesh 35 Delhi 4500
Kaushik 31 Indore 10000
Hardik 22 Hyderabad 8500
Aishwarya 28 Bangalore 6500
Akshaya 29 Delhi 5000

 

Leave a Reply

Your email address will not be published. Required fields are marked *