Basic SQL :
create table hyd.info
(
id varchar(255),
name varchar(255),
city varchar(255)
);
insert into hyd.info
(id,name,city)
values('1','hameed','hyd');
update hyd.info
set id='123',name='abdulhameed'
where name=hameed;
delete from hyd.info
where id='123' and name='abdulhameed';
create table hyd.info
(
id varchar(255),
name varchar(255),
city varchar(255)
);
insert into hyd.info
(id,name,city)
values('1','hameed','hyd');
update hyd.info
set id='123',name='abdulhameed'
where name=hameed;
delete from hyd.info
where id='123' and name='abdulhameed';
0 comments:
Post a Comment