qq_42093887的博客

update。

delete from tableName where condition;delect from(select * from tableName where condition);alter table tableName activate not logged initially with empty table;

create table newTableName as ( select * from oldTableName ) definition only in 表空间；create table newTableName like oldTableName in 表空间；

(update schema.tableName set age = 'xxx' where condition); ---更新后的数据select * from oldtable(update schema.tableName set age = 'xxx' where condition); --更新前的数据

关键字后面都可以接 all 如果不接all 操作集合将会去除重复值。用来求在第一个集合中存在，而在第二个集合中不存在的记录。用来求两个集合的并集；用来求两个集合的交集；

select * from(select b.*,rownumber() over() as rn from( select * from <tableName> ) as b) as a where a.rn between <start_number> and <end_number>;

modified by codepage = 1208db2 "export to tableName.ixf of ixf modified by codepage = 1208 select * from schema.tableName" ;

drop schema "schemaName" restrictdb2 "drop schema |"schemaName"| restrict"

普通索引create indes "schema"."indexName" on "schema"."tableName"("字段1" asc, "字段2" asc)compress no allow reverse scans;唯一索引create unique index "schema"."indexName" on "schema"."tableName"("字段" asc)xompress no allow reverse scans;主键约束索引alte...

select * from sysibmadm.locks_held; ---查看锁表情况db2 "force applications(56001)" --解锁

select * from tableName fetch first 1 rows only;select * from tableName order by rand() fetch first 1 rows only;-------------------------------select * from staff tablesample bernoulli(8) repeatable(586) order by id;--说明：从staff 表中，采用bernoulli 抽样...

db2 connect to cbrcdbdb2look -d cbrcdb -z schema -e -o schema.sql --不带dropdb2look -d cbrcdb -z schema -e -dp -o schema.sql --带dropdb2 -tvf schema.sql | tee schema.logdb2 disconnect all

db2 connect to schemadb2 "export to tableName.ixf of ixf select * from schema.tableName"db2 "export to tableName.del of del select * from schema.tableName"db2 "load from tableName.ixf of ixf replace into schema.tableName"db2 "load from tableName...

alter table tableName add column columns varchar(100);comment on column tableName.columns is "xxxcolumns"

alter table tableName alter column columns set data type varchar(50);

db2 connect to cbrcdb //连接数据库db2 reorg table table_name //重组对应的数据表