W_ASN的博客

翻译 Linux 挂载未使用的磁盘空间

Linux 挂载未分配空间

转载 DM删除一个表中重复的数据

delete from "JXTZC"."ZG_GZJL" where work_ID in (select work_ID from "JXTZC"."ZG_GZJL" group by work_ID having count(work_ID) > 1)and rowid not in (select min(rowid) from "JXTZC"."ZG_GZJL" group by work_ID having count(work_ID )>1)

原创 达梦地区查询本级及本级之下

原创 达梦数据库创建视图

create view "jxtxm"."v_all_user" as((SELECT user_name AS username, user_pass AS userpwd, 'QY' AS usertype, qymc AS cn_name, id AS userid, qydm, (CASE WHEN jzdl = 0 THEN 1 ELSE 0 END) AS enabled, areacode, '10' AS levelcodeFROM "jxtxm"."QY...

原创 达梦数据库包含查询

select * from "jxtxm"."NEWS" WHERE instr("NEWSTYPE",',2,3') >0