数据库 - 随笔分类(第2页) - wanhua.wu

MongoDB操作符

摘要：{"cookie":"39828d2f-bffc-4818-883d-2e627f0b274d","shopId":"306072209435180713","platform":0,"viewDate":{$gte:1529567243000,$lte:1529636122171}} {viewDate:-1} 阅读全文

posted @ 2018-06-22 10:59 wanhua.wu

Mycat修改空指针问题

摘要：Mycat在进行修改操作的时候，偶尔会发生空指针异常！解决：修改条件添加：分表字段阅读全文

posted @ 2018-06-15 09:50 wanhua.wu

MyCat注解-批量插入

摘要：https://blog.csdn.net/win7system/article/details/53333094 批量插入mycat无法确认数据具体插入到那个表，所以得先指定分表字段阅读全文

posted @ 2018-06-05 14:20 wanhua.wu

Mycat水平拆分之十种分片规则

摘要：http://m635674608.iteye.com/blog/2387781 阅读全文

posted @ 2018-06-01 10:17 wanhua.wu

You can't specify target table 't_mail_marketing' for update in FROM clause

摘要：update t_mail_marketing set `STATUS` = 1 where ID in ( select b.PARENT_ID from (SELECT DISTINCT a.PARENT_ID from t_mail_marketing a where a.`STATUS`=1 and a.PARENT_ID IS NOT NULL and a.PARENT_ID>0)b... 阅读全文

posted @ 2018-04-25 17:31 wanhua.wu

数据库设计规范

摘要：参考： http://825635381.iteye.com/blog/2331174 阅读全文

posted @ 2017-08-13 18:13 wanhua.wu

PROCEDURE

摘要：抢劵阅读全文

posted @ 2017-08-09 10:37 wanhua.wu

数据库去重

摘要：UPDATE pd_user set id_card=REPLACE(id_card,' ',''); INSERT INTO pd_temp_idcard SELECT MIN(uid) AS minUid, id_card FROM pd_user WHERE LENGTH(id_card) > 0 GROUP BY id_card HAVING... 阅读全文

posted @ 2017-08-08 10:25 wanhua.wu

FUNCTION

摘要：1，FUNCTION-1 阅读全文

posted @ 2016-12-05 18:49 wanhua.wu

SQL语法

摘要：1，字符串截取 2，字符串拼接 3，日期计算 4，IF函数 5，CASE函数阅读全文

posted @ 2016-12-05 17:02 wanhua.wu

SQL函数

摘要：1，字符串截取拼接 2，Case函数 3，字符串拼接 4，日期加减 5，年龄计算 6，IF函数 7，COUNT函数 8，外联 9, 外联 N，其他 1,将查询结果存入表insert into pd_temp select * from pd_other; 2,将表数据导出xls文件最大1048576 阅读全文

posted @ 2016-12-05 16:58 wanhua.wu

迭代查询

摘要：元数据：迭代查询：阅读全文

posted @ 2016-11-30 20:16 wanhua.wu

wanhua.wu

随笔分类 - 数据库

公告