Welcome to the MariaDB monitor.  Commands end with ; or \g.

Your MariaDB connection id is 5

Server version: 10.0.21-MariaDB mariadb.org binary distribution

Copyright (c) 2000, 2015, Oracle, MariaDB Corporation Ab and others.

Type 'help;' or '\h' for help. Type '\c' to clear the current input statement.

MariaDB [(none)]> use test

Database changed

MariaDB [test]> create table foo_csv(col1 date) engine=CONNECT table_type=CSV fi

le_name='C:/temp/foo.csv';

Query OK, 0 rows affected (0.00 sec)

MariaDB [test]>

MariaDB [test]> insert into foo_csv(col1)

    -> values   ('2015-01-01'),

    ->                  ('2015-02-01'),

    ->                  ('2015-03-01'),

    ->                  ('2015-04-01');

Query OK, 4 rows affected (0.00 sec)

Records: 4  Duplicates: 0  Warnings: 0

MariaDB [test]> select * from foo_csv\G

*************************** 1. row ***************************

col1: 2015-01-01

*************************** 2. row ***************************

col1: 2015-02-01

*************************** 3. row ***************************

col1: 2015-03-01

*************************** 4. row ***************************

col1: 2015-04-01

4 rows in set (0.00 sec)

MariaDB [test]> select * from foo_csv where col1 = '2015-02-01'\G

Empty set (0.00 sec)

MariaDB [test]> select * from foo_csv where col1 > '2015-02-01'\G

*************************** 1. row ***************************

col1: 2015-03-01

*************************** 2. row ***************************

col1: 2015-04-01

2 rows in set (0.00 sec)

MariaDB [test]>