摘要:
DROP TABLE IF EXISTS temp_data; CREATE TEMPORARY TABLE temp_data( d VARCHAR(20) NOT NULL, c INT NOT NULL ) ; INSERT temp_data VALUES('aa',1); SELECT * FROM temp_data; 阅读全文
摘要:
两处修改: 1.postgresql.conf listen_addresses项值设定为“*”,在9.0 Windows版中,该项配置已经是“*”无需修改。 2.pg_hba.conf host all all 127.0.0.1/32 md5行下添加以下配置 host all all 0.0.0 阅读全文
摘要:
Merge into [tableName] as t Using(select [@id] as tid) as t1 on t1.tid=t.id when matched then update set name='name1' when not matched then insert(name) values('name'); 阅读全文