github.com/matrixorigin/matrixone@v0.7.0/test/distributed/cases/table/temporary_table/various_test.sql (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  
    15  -- import data
    16  import data infile '$resources/load_data/integer_numbers_1.csv' into table t1;
    17  select * from t1;
    18  
    19  -- into outfile
    20  select * from t1 into outfile '$resources/into_outfile_2/outfile_integer_numbers_2.csv';
    21  delete from t1;
    22  
    23  -- import data
    24  import data infile '$resources/into_outfile_2/outfile_integer_numbers_2.csv' into table t1 ignore 1 lines;
    25  select * from t1;
    26  delete from t1;
    27  
    28  import data infile '$resources/load_data/integer_numbers_2.csv' into table t1 fields terminated by'*';
    29  select * from t1;
    30  delete from t1;
    31  drop table t1;