This sample illustrates use of UPDATE statement.
This SQL script contains 8 queries.
Table "MyTable" is deleted, then recreated and filled with data.
The seventh query sets field "val2" to string 'Many' where "val1" is more than 2.
At last you can see what data is contained in the table after all queries.
drop table MyTable;
create table MyTable (ID AutoInc, val1 Integer, val2 string(10));
insert into MyTable (val1, val2) values (2,'2');
insert into MyTable (val1, val2) values (4,'3');
insert into MyTable (val1, val2) values (5,'9');
insert into MyTable (val1, val2) values (7,'Hello');
update MyTable set val2='Many' where val1>2;
select * from MyTable;
Download Absolute Database | Learn more |
