liuwei423210896的专栏

1. 订单表和商品类，一般都要设计订单主表，和订单关联的商品详细-表，用户详细表 对于gmi小程序中设计到【用户发送短信的记录】 与 【记录详情表】: 结构如下： --------------------------------------------------------------------------------------- 表A:（短信记录表） 用户id...

1. create table A as select * from B 2. create table A like B 4. rename table A to B (这种方式在线上系统小时级别更新替换数据时，将影响降低，而不是先删除存在的表再sqoop拉取数 据，而是拉取数据到临时...

1.考察主要是根据一张表的字段更新另一张的字段 UPDATE gmi_message_user_his_new t1 LEFT JOIN (SELECT userId,CODE,createTime FROM gmi_consumer_info WHERE userId = '1356823') t2 ON t1.userId = t2.userid AND t1.code = t2.co...

考察left join和where ... and ... # 查看数据是否补全，主要查看userid = 1356823用户 select tt1.userid,ifnull(tt3.totalSend,0) as totalSend,ifnull(tt1.tot,0) as total,ifnull(tt2.succ,0) as success,tt3.time as datetime...

# 查询总数(表合并前) select * from gmi_message_user_his where userid = '1187887' 190 # 查询发送信息详细表(code + user_detail) select * from gmi_message_code_his where userid = '1187887' select distinct code,sub_...