| 1 |
create table t1 (a int not null) engine=csv; |
| 2 |
insert t1 values (1),(2); |
| 3 |
flush tables; |
| 4 |
select * from information_schema.tables where table_schema='test'; |
| 5 |
TABLE_CATALOG def |
| 6 |
TABLE_SCHEMA test |
| 7 |
TABLE_NAME t1 |
| 8 |
TABLE_TYPE BASE TABLE |
| 9 |
ENGINE NULL |
| 10 |
VERSION NULL |
| 11 |
ROW_FORMAT NULL |
| 12 |
TABLE_ROWS NULL |
| 13 |
AVG_ROW_LENGTH NULL |
| 14 |
DATA_LENGTH NULL |
| 15 |
MAX_DATA_LENGTH NULL |
| 16 |
INDEX_LENGTH NULL |
| 17 |
DATA_FREE NULL |
| 18 |
AUTO_INCREMENT NULL |
| 19 |
CREATE_TIME NULL |
| 20 |
UPDATE_TIME NULL |
| 21 |
CHECK_TIME NULL |
| 22 |
TABLE_COLLATION NULL |
| 23 |
CHECKSUM NULL |
| 24 |
CREATE_OPTIONS NULL |
| 25 |
TABLE_COMMENT File './test/t1.CSM' not found (Errcode: 13 "Permission denied") |
| 26 |
MAX_INDEX_LENGTH NULL |
| 27 |
TEMPORARY NULL |
| 28 |
Warnings: |
| 29 |
Level Warning |
| 30 |
Code 29 |
| 31 |
Message File './test/t1.CSM' not found (Errcode: 13 "Permission denied") |
| 32 |
drop table t1; |