From the documentation it looks like sep_char is supposed to be 1 symbol, but it's not said so explicitly. Besides, if it's so, it would make more sense to produce an error upon table creation, not upon SELECT.
I got the error from the Select statement
Your file is not a CSV file. CSV files have a one character separator as said in the MariaDB documentation:
Many source data files are formatted with variable length fields and records. The simplest format, known as CSV (Comma Separated Variables), has column fields separated by a separator character. By default, the separator is a comma but can be specified by the SEP_CHAR option as any character, for instance a semi-colon.
I agree that this should be checked when creating the table and will fix it as soon as possible.
Meanwhile you can create and load your table as a FMT table:
create table people (
|
name char(12) not null field_format='"%n%[^"]%n"',
|
birth date not null date_format='DD/MM/YY' field_format='(#]%n%[^(]%n',
|
children smallint(2) not null field_format='(#]%n%d%n')
|
engine=CONNECT table_type=FMT file_name='C:\\MariaDB\\data\\name.csv' header=1;
|
Note that FMT being read only tables, this enables you to load and use the table but not to modify it.
Thanks a lot it works perfectly 
!
I need to index this table (let say on name) to load data fast , how to do it using this command? (I have a file that can reach 1Million records..).
Many Thanks
Like for any table. You can define name as key or simply execute:
create index pn on people(name);
|
Thanks a lot for your feedback!