github.com/matrixorigin/matrixone@v1.2.0/test/distributed/cases/table/temporary_table/various_test.result (about)

     1  drop database if exists test_temporary;
     2  create database test_temporary;
     3  use test_temporary;
     4  create temporary table t1(
     5  col1 tinyint,
     6  col2 smallint,
     7  col3 int,
     8  col4 bigint,
     9  col5 tinyint unsigned,
    10  col6 smallint unsigned,
    11  col7 int unsigned,
    12  col8 bigint unsigned
    13  );
    14  load data infile '$resources/load_data/integer_numbers_1.csv' into table t1 fields terminated by ',';
    15  
    16  select * from t1;
    17  
    18  select * from t1 into outfile '$resources/into_outfile_2/outfile_integer_numbers_2.csv';
    19  
    20  delete from t1;
    21  
    22  load data infile '$resources/into_outfile_2/outfile_integer_numbers_2.csv' into table t1 fields terminated by ',' ignore 1 lines;
    23  
    24  select * from t1;
    25  
    26  delete from t1;
    27  
    28  load data infile '$resources/load_data/integer_numbers_2.csv' into table t1 fields terminated by'*';
    29  
    30  select * from t1;
    31  
    32  delete from t1;
    33  
    34  drop table t1;
    35