BASICS OF MYSQL

 #create database temple

use temple;

#create table details(id integer(3), name varchar(10), email varchar(100), contact varchar(10));

#insert into details values(5, "vishal", "vishal@gmail.com", "978954389");

update details set name="gobi", contact="586868686" where id=5;

delete from details where id=2;

select * from details;


Comments