📄 insert.out
字号:
2 |2 |2 |2 |2.0 |2.0 |2 NULL |NULL |NULL |NULL |NULL |NULL |NULL 3 |3 |3 |3 |3.0 |3.0 |3 NULL |NULL |NULL |NULL |NULL |NULL |NULL 4 |4 |4 |4 |4.0 |4.0 |4 NULL |NULL |NULL |NULL |NULL |NULL |NULL 5 |5 |5 |5 |5.5 |5.5 |5 NULL |NULL |NULL |NULL |NULL |NULL |NULL 6 |6 |6 |6 |6.6 |6.6 |6 NULL |NULL |NULL |NULL |NULL |NULL |NULL 7 |7 |7 |7 |7.0 |7.0 |7 NULL |NULL |NULL |NULL |NULL |NULL |NULL ij> delete from i2;14 rows inserted/updated/deletedij> insert into i2 select i, t, s, l, r, dp, dc from tab1;2 rows inserted/updated/deletedij> select * from i2;I |T |S |L |R |DP |DC -----------------------------------------------------------------------------------------------1 |2 |3 |4 |5.5 |6.6 |7 NULL |NULL |NULL |NULL |NULL |NULL |NULL ij> -- get the restcreate table i3 (b char(1) for bit data, bv varchar(1) for bit data, lbv long varchar for bit data, c char(10), cv varchar(10), lvc long varchar, dt date, t time, ts timestamp);0 rows inserted/updated/deletedij> create table i4 (b char (1) for bit data, bv varchar(1) for bit data, lbv long varchar for bit data, c char(10), cv varchar(10), lvc long varchar, dt date, t time, ts timestamp);0 rows inserted/updated/deletedij> insert into i3 values (X'11', X'22', X'25', '3', '4', '5', '1990-10-10', '11:11:11', 'xxxxxxFILTERED-TIMESTAMPxxxxx);1 row inserted/updated/deletedij> insert into i3 values (null, null, null, null, null, null, null, null, null);1 row inserted/updated/deletedij> insert into i4 select * from i3;2 rows inserted/updated/deletedij> select * from i4;B |BV |LBV |C |CV |LVC |DT |T |TS ------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------11 |22 |25 |3 |4 |5 |1990-10-10|11:11:11|xxxxxxFILTERED-TIMESTAMPxxxxxNULL|NULL|NULL |NULL |NULL |NULL |NULL |NULL |NULL ij> delete from i4;2 rows inserted/updated/deletedij> create table tab2 ( c char, cv varchar(10), lvc long varchar, dt date, t time, ts timestamp);0 rows inserted/updated/deletedij> insert into tab2 values ('3', '4', '5', '1990-10-10', '11:11:11', 'xxxxxxFILTERED-TIMESTAMPxxxxx);1 row inserted/updated/deletedij> insert into tab2 values (null, null, null, null, null, null);1 row inserted/updated/deletedij> insert into i4 (c, cv, lvc, dt, t, ts) select c, cv, lvc, dt, t, ts from tab2;2 rows inserted/updated/deletedij> select * from i4;B |BV |LBV |C |CV |LVC |DT |T |TS ------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------NULL|NULL|NULL |3 |4 |5 |1990-10-10|11:11:11|xxxxxxFILTERED-TIMESTAMPxxxxxNULL|NULL|NULL |NULL |NULL |NULL |NULL |NULL |NULL ij> -- drop the tablesdrop table t1;0 rows inserted/updated/deletedij> drop table t2;0 rows inserted/updated/deletedij> drop table atom_test_target;0 rows inserted/updated/deletedij> drop table atom_test_source;0 rows inserted/updated/deletedij> drop table i1;0 rows inserted/updated/deletedij> drop table i2;0 rows inserted/updated/deletedij> drop table i3;0 rows inserted/updated/deletedij> drop table i4;0 rows inserted/updated/deletedij> drop table tab1;0 rows inserted/updated/deletedij> drop table tab2;0 rows inserted/updated/deletedij> -- test bug 4293, extremely huge insert statement, not using FileImport.create table POLICY_STATEMENTS (c1 int, c2 int, c3 int, c4 long varchar, c5 long varchar, c6 int, c7 int, c8 int, c9 int, c10 int, c11 int);0 rows inserted/updated/deletedij> INSERT INTO POLICY_STATEMENTS VALUES( 101,1,null,'All information systems within %%short_company_name%% are the property of %%short_company_name%% and will be used in compliance with %%short_company_name%% policy statements.','This is a specific and clear statement about ownership of corporate assets. Failure to include this policy statement may lead to the unauthorized use of company resources and eliminate the company''s ability to take disciplinary actions against users who abuse company assets.',null,1,1,null,null,1),( 101,1,null,'All information systems within %%short_company_name%% are the property of %%short_company_name%% and will be used in compliance with %%short_company_name%% policy statements.','This is a specific and clear statement about ownership of corporate assets. Failure to include this policy statement may lead to the unauthorized use of company resources and eliminate the company''s ability to take disciplinary actions against users who abuse company assets.',null,1,1,null,null,1),⌨️ 快捷键说明
复制代码
Ctrl + C
搜索代码
Ctrl + F
全屏模式
F11
切换主题
Ctrl + Shift + D
显示快捷键
?
增大字号
Ctrl + =
减小字号
Ctrl + -