CSV tables - equivalent of External tables in Oracle

From dbawiki
Jump to: navigation, search

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"


References[edit]

fromdual.ch