1 2 3 4 5 6 7 8 9 |
DROP TABLE IF EXISTS t1; CREATE TABLE t1 (c1 INT, c2 DECIMAL(3, 2), c3 VARCHAR(20)) ENGINE=FILESYSTEM,FILE="../../filesystem_ln/select_chop_line.data",SEPARATOR_MODE=WEAK; SELECT * FROM t1; c1 c2 c3 618 9.60 LSkNQAZjODwYvOYUeAVb 847 2.60 yphkuCaGsgbReRQTcUob 814 3.25 rJDEnFNRTVftDpWPLeRa 571 4.84 bjQkbVIPlNmlHpKvDBVv DROP TABLE t1; |