- 博客(2)
- 收藏
- 关注
原创 KUDU表的增删改查
一、创建kudu表 CREATE TABLE IOV_DAILY ( `DID` string, `START_GEAR` INT, `DATA_TIME` BIGINT, `DATA_DAY` string, `POINTS` INT, PRIMARY KEY ( DID, START_GEAR, DATA_TIME ) ) PARTITION BY HASH ( DID ) PARTITIONS 15, RANGE ( DATA_TIME ) ( PARTITION VALUES &l
2021-09-22 16:12:41 1638 2
原创 Mysql与Oracle的删除修改语法差异示例
一、修改 Mysql: 两个表关联 示例1: UPDATE IOV_CAR_INFO TT JOIN IOV_CAR_PARTS C ON TT.VIN = C.FRAMENUM SET TT.EXTRACT = 0 WHERE TT.EXTRACT = 2 示例2: UPDATE `test_user` u INNER JOIN (SELECT u.id,d.city_id FROM test_department d INNER JOIN `test_u...
2021-09-22 15:58:12 105
空空如也
空空如也
TA创建的收藏夹 TA关注的收藏夹
TA关注的人