按 email 去重插入
INSERT INTO users (id, name, email) VALUES (1, '张三', 'test@qq.com') ON CONFLICT (email) DO NOTHING;
不存在插入，存在就更新
INSERT INTO users (id, name, age) VALUES (1, '张三', 20) ON CONFLICT (id) DO UPDATE SET name = EXCLUDED.name, age = EXCLUDED.age;
记录：cd C:\Program Files (x86)\Microsoft SQL Server\110\Tools\Binn打开cmdsqlcmd -S "localhost"...
SELECT A.attnum AS "序号",C.relname AS "表名",CAST (ob...
CREATE SEQUENCE stu_id_seq SELECT setval( 'stu_id_seq', &nbs...
EXEC sys.sp_addextendedproperty @name=N'MS_Description',@level1type=N'TABLE...
select zph_chrq.qyid,zph_chrq.lxdh as phone,qy.qymc from zph_chrq INNER join qy on zph_chrq.qy...
1、用 超级用户（postgres）执行：SELECT datname, has_database_pr...
