1 2 3 4 5 6 7 8 9 10 11 12 13 |
DROP TABLE IF EXISTS t1; CREATE TABLE t1 (c1 INT, c2 VARCHAR(20), c3 INT, c4 VARCHAR(20), c5 DECIMAL(3, 2)) ENGINE=FILESYSTEM,FILE="../../filesystem_ln/select_with_omit_field.data",COL_SEPARATOR="|/",ROW_SEPARATOR=";\n"; SELECT * FROM t1; c1 c2 c3 c4 c5 111 aaa 222 bbb 4.32 333 NULL 888 1.89 NULL 555 xxx 999 ppp 5.67 NULL ddd 100 qqq 7.15 999 eee 231 ooo 9.11 DROP TABLE t1; |