phoenix语句

• 插入数据

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