update.sql

来自「AbsDataBase5.16 最新版」· SQL 代码 · 共 29 行

/*This SQL script uses Demos.abs database. 
  Please open ...\AbsoluteDatabase\Demos\Data\Demos.abs database file.
  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;