CSV tables - equivalent of External tables in Oracle
From dbawiki
Are they enabled?[edit]
show engines;
Create a CSV table[edit]
create table csv_test (id int, value varchar(20)) engine = csv; insert into csv_test VALUES (1, 'Record 1'), (2, 'Record 2'), (3, 'Record 3'); select * from csv_test;
What it looks like in unix[edit]
$ cat csv_test.CSV "1","record 1" "2","record 2" "3","record 3"