UPDATE 表名 SET 列名 = 新值 WHERE 条件; 11.删除表中的数据: DELETE FROM 表名 WHERE 条件; 12.删除表: DROP TABLE 表名; 13.退出psql: \q 14.查看帮助: \? 15.查看表空间信息: \db 16.查看索引信息: \d 索引 17.列出所有角色和用户: \dg 18.查看表的权限分配情况 \dp 表名 19.COPY导入导...
在表中插入数据: insert into 表名 ([字段名m],[字段名n],...) values ([列m的值],[列n的值],...); 修改表中的某行某列的数据: update [表名] set [目标字段名]=[目标值] where [该行特征]; 删除表中某行数据: delete from [表名] where [该行特征]; delete from [表名];--删空整...
select * from test where age in (5, 12); 4、带有between and 关健字查询 查询某个在给定范围内的记录select 查询内容 from 表名 where 条件 between 值1 and 值2; 5、查询某些为空NULL 或 非空的记录select 查询内容 from 表名 where 条件 is(not) NULL; 6、在查询时过滤掉重复的值:select distin...
行构造函数(ROW) ❌ ✔️ 行构造表达式(WHERE) ✔️ ✔️ SQL 语句中的变量 ✔️ ❌ 基于正则表达式的比较条件 ✔️ ✔️ 基于正则表达式的子串查找 ✔️ ✔️ 基于正则表达式的子串替换 ✔️ ✔️ 内连接(INNER JOIN) ✔️ ✔️ 左外连接(LEFT OUTER JOIN) ...
(1 row) postgres=# insert into t_ken_yon values(1),(2); INSERT 0 2 postgres=# delete from t_ken_yon where id =1; DELETE 1 [postgres@localhost pg_log]$ tail -f postgresql-2013-03-29_000000.csv 2013-03-29 11:04:08.148 PDT,,,5554,,514933a6.15b2,42,,2013-03-19 20:57:26...
where abbreviated_grant_or_revoke is one of: GRANT { { SELECT | INSERT | UPDATE | DELETE | TRUNCATE | REFERENCES | TRIGGER } [, ...] | ALL [ PRIVILEGES ] } ON TABLES TO { [ GROUP ] role_name | PUBLIC } [, ...] [ WITH GRANT OPTION ] ...
1 testdb=# DELETE FROM t1 WHERE id = 1;2 DELETE 13 testdb=# DELETE FROM t1 WHERE id = 2;4 DELETE 156 testdb=# SELECT lp as tuple, t_xmin, t_xmax, t_field3 as t_cid, t_ctid,t_data FROM heap_page_items(get_raw_...
3.3 UPDATE/DELETE WHERE CURRENT OF 使用游标更新或删除当前指向的行 语法:UPDATE table SET ... WHERE CURRENT OF cursor;语法:DELETE FROM table WHERE CURRENT OF cursor; 实例: 代码语言:javascript 代码运行次数:0 复制 Cloud Studio代码运行 select*from tf1;c1|c2|c3|c4|c5---+---+---+---+---...
(1row) postgres=# update tdsql_pg_main set mc='tdsql_pg' where mc!='tdsql_pg'; UPDATE0 postgres=# select xmin,* from tdsql_pg_main; xmin|id|mc ---+---+--- 2564|1|tdsql_pg (1row) 上面的效果是一样的,但带条件的更新不会产生一个新的版本记录,不需要系统执行 vacuum 回收垃...