插入数据
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 下面是各种类型的对应数字
