数据库
city6789
这个作者很懒,什么都没留下…
展开
-
mongodb 批量更新|按条件更新 SQL
---------------------------实际执行的单条语句--db.project.update( { _id: "60fa1590ad07cc1deaf86bfb"}, { $setOnInsert: { checkDate: new Date() } }, { upsert: true })---------------------------实际执行的---批量#checkDate 更新字段名#相当于where条件ana...原创 2021-07-25 16:38:14 · 910 阅读 · 0 评论 -
关于oracle with as用法
关于oracle with as用法–针对一个别名with tmp as (select * from tb_name)–针对多个别名with tmp as (select * from tb_name), tmp2 as (select * from tb_name2), tmp3 as (select * from tb_name3),原创 2018-01-15 15:58:17 · 367 阅读 · 0 评论