Csv tables - equivalent of external tables in oracle
Are they enabled?
show engines;
Create a CSV table
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
$ cat csv_test.CSV
"1","record 1"
"2","record 2"
"3","record 3"