--------------
|
create table t2 (
|
fdr varchar(255) NOT NULL flag=0,
|
fpath varchar(255) NOT NULL flag=1,
|
fname varchar(255) NOT NULL flag=2
|
)engine=CONNECT table_type=DIR file_name='/home/alice/Downloads/*' option_list='subdir=1'
|
--------------
|
Query OK, 0 rows affected (0.03 sec)
|
|
--------------
|
select * from t2
|
--------------
|
Empty set (0.00 sec)
|
|
\! ls -la /home/alice/Downloads/
|
|
drwxr-xr-x 3 alice alice 4096 May 1 11:34 .
|
drwxr-xr-x 25 alice alice 4096 May 1 09:55 ..
|
-rw-rw-r-- 1 alice alice 0 May 1 10:34 1
|
drwxrwxr-x 2 alice alice 4096 May 1 11:35 11
|
-rw-rw-r-- 1 alice alice 0 May 1 10:34 2
|
-rw-rw-r-- 1 alice alice 0 May 1 10:34 3
|