在知识库中专注阅读，并随时返回相关工具与课程
openGauss 每日一练第 13 天打卡，我来了！又可以学习，真开心~ 今天第 13 课，学习openGauss导入数据。 sql create table luciferid int,name char20,ldesc char200; \d+ lucifer insert into lucifer values1,'lucifer','hhhhhhhh'; insert into luci
openGauss 每日一练第 13 天打卡，我来了！又可以学习，真开心~
本章目标：掌握本章核心知识点 前置要求：完成前序章节学习 预计时长：60 分钟
今天第 13 课，学习openGauss导入数据。
1create table lucifer(id int,name char(20),ldesc char(200));2\d+ lucifer3insert into lucifer values(1,'lucifer','hhhhhhhh');4insert into lucifer values(2,'opengauss',default);5insert into lucifer default values;6select * from lucifer;
1create table lucifer2 as select * from lucifer;
1create table lucifer3(id int,name char(20),ldesc char(200));2insert into lucifer3 values (1,'lucifer','123456789'),(2,'lucifer1','23456789'),(3,'lucifer2','3456789');34create table lucifer4(id int,name char(20),ldesc char(200));5insert into lucifer4 values (1,'lucifer','123456789'),(3,'lucifer3','456789'),(4,'lucifer4','6789');67merge into lucifer3 l3 8using lucifer4 l4 9on (l4.id = l3.id) 10when matched then 11update set l3.name = l4.name,l3.ldesc = l4.ldesc 12when not matched then13insert values(l4.id,l4.name,l4.ldesc);
1copy lucifer3 to '/home/omm/lucifer3.dat';2create table lucifer5(id int,name char(20),ldesc char(200));3copy lucifer5 from '/home/omm/lucifer3.dat';4select * from lucifer5;
今天的作业打卡结束！🎉