-- Query logging
--
--  Driver name: MySQL ODBC 3.51 Driver  Version: 03.51.27
-- Timestamp: 090903  8:40:59

drop table if exists my_rdo;
create table my_rdo(id int, name varchar(20));
insert into my_rdo values (100,'venu');
insert into my_rdo values (200,'MySQL');
select * from my_rdo;
insert into my_rdo (id, name) values (300, 'Insert1');
select * from my_rdo;
insert into my_rdo (id, name) values (400, 'Insert 2');
select * from my_rdo;
update my_rdo SET id=999 , name='updated'  WHERE `name` = 'venu' AND `id` = 100;
select * from my_rdo;