phoenix语句
2022-01-12 本文已影响0人
如雨随行2020
- 插入数据
UPSERT INTO syslogs(id, uid, action)
VALUES( NEXT VALUE FOR syslogs_sequence,9,'action');
- 删除数据
delete from syslogs where id = 1;
- 更新一条数据
UPSERT INTO syslogs(id, uid, action, content,ip, result, addtime)
VALUES( 2,9,'action', 'content','ip', 'result',1557158400000);
- 添加列
alter table stations add power Decimal;
- 删除列
ALTER TABLE stations DROP COLUMN power;
- 更新一列
把安全运行天数加一
upsert into stations(id, safe_day) select id, safe_day + 1 from stations;
- null值查找
select * from users where org_id is null;
- 获取系统sequence信息
SELECT sequence_schema, sequence_name, start_with, increment_by, cache_size
FROM SYSTEM."SEQUENCE";
获取表信息
select * from system.catalog where table_name = 'TEST';
- 注意
phoenix语句中字符串都使用单引号'dasg'
慎用
谨慎使用以下语句,可能会破坏表结构,不正确的操作可能导致删库跑路
修改字段类型
upsert into SYSTEM.CATALOG (TENANT_ID,TABLE_SCHEM,TABLE_NAME,COLUMN_NAME,COLUMN_FAMILY,DATA_TYPE)
values ('', '', 'USERS', 'ADDTIME', '0', 93);
语句中USERS是表名,ADDTIME是列名,93代表TIMESTAMP
下面是各种类型的对应数字