一、备份数据库语句
select * into tmp_cs_userwallet_effective from cs_userwallet_effective
这样就可以将整张表的数据和结构都备份过来到tmp_cs_userwallet_effective表
二、批量更新不同字段不同值的语句
语句举例:
update test as p
set age= a.age,class=a.class
from (
select x.age,x.user,x.class from test2 x
) as a where p.user = a.user;
例子示例:
先创两张表做示范
--test表
CREATE TABLE "public"."test" (
"user" varchar(255) COLLATE "pg_catalog"."default",
"age" int4,
"class" varchar(255) COLLATE "pg_catalog"."default"
)
;
ALTER TABLE "public"."test"
OWNER TO "postgres";
--test2表
CREATE TABLE "public"."test2" (
"age" int4,
"user" varchar(255) COLLATE "pg_catalog"."default",
"class" varchar(255) COLLATE "pg_catalog"."default"
)
;
ALTER TABLE "public"."test2"
OWNER TO "postgres";
test表数据
test2表数据
执行语句后,test表数据如下