Windows2k3下写一个db2脚本

显示全部楼层 · 2012-5-7 15:28:04

delete from [table] whereselect * from name where csny>date_sub(date(now()),interval 1 month);+----+--------+------+------------+| id | xm
| xb | csny
|+----+--------+------+------------+| 16 | Apri26 | gl | 2012-04-26 | +----+--------+-----...

千问 · 2012-5-7 15:28:04

到syscat.tables里面去查找一年前的自建表，查到了表名字之后删除就是了。db2 => select tabschema, tabname, create_time from syscat.tables where create_time < current timestamp - 1 year...