65
65
Variable_name Value
66
66
show table status from test like "this_doesn't_exists%";
67
67
Catalog Database Table Table_alias Column Column_alias Type Length Max length Is_null Flags Decimals Charsetnr
68
def data_dictionary show_table_status SHOW_TABLE_STATUS Session Session 5 20 0 N 32769 0 63
69
def data_dictionary show_table_status SHOW_TABLE_STATUS Schema Schema 8 256 0 N 1 0 45
68
70
def data_dictionary show_table_status SHOW_TABLE_STATUS Name Name 8 256 0 N 1 0 45
71
def data_dictionary show_table_status SHOW_TABLE_STATUS Type Type 8 256 0 N 1 0 45
69
72
def data_dictionary show_table_status SHOW_TABLE_STATUS Engine Engine 8 256 0 N 1 0 45
70
73
def data_dictionary show_table_status SHOW_TABLE_STATUS Version Version 8 256 0 N 1 0 45
71
def data_dictionary show_table_status SHOW_TABLE_STATUS Row_format Row_format 8 256 0 N 1 0 45
72
74
def data_dictionary show_table_status SHOW_TABLE_STATUS Rows Rows 8 256 0 N 1 0 45
73
75
def data_dictionary show_table_status SHOW_TABLE_STATUS Avg_row_length Avg_row_length 8 256 0 N 1 0 45
74
def data_dictionary show_table_status SHOW_TABLE_STATUS Data_length Data_length 8 256 0 N 1 0 45
75
def data_dictionary show_table_status SHOW_TABLE_STATUS Max_data_length Max_data_length 8 256 0 N 1 0 45
76
def data_dictionary show_table_status SHOW_TABLE_STATUS Index_length Index_length 8 256 0 N 1 0 45
77
def data_dictionary show_table_status SHOW_TABLE_STATUS Data_free Data_free 8 256 0 N 1 0 45
76
def data_dictionary show_table_status SHOW_TABLE_STATUS Table_size Table_size 8 256 0 N 1 0 45
78
77
def data_dictionary show_table_status SHOW_TABLE_STATUS Auto_increment Auto_increment 8 256 0 N 1 0 45
79
def data_dictionary show_table_status SHOW_TABLE_STATUS Create_time Create_time 8 256 0 N 1 0 45
80
def data_dictionary show_table_status SHOW_TABLE_STATUS Update_time Update_time 8 256 0 N 1 0 45
81
def data_dictionary show_table_status SHOW_TABLE_STATUS Check_time Check_time 8 256 0 N 1 0 45
82
def data_dictionary show_table_status SHOW_TABLE_STATUS Collation Collation 8 256 0 N 1 0 45
83
def data_dictionary show_table_status SHOW_TABLE_STATUS Checksum Checksum 8 256 0 N 1 0 45
84
def data_dictionary show_table_status SHOW_TABLE_STATUS Create_options Create_options 8 256 0 N 1 0 45
85
def data_dictionary show_table_status SHOW_TABLE_STATUS Comment Comment 8 256 0 N 1 0 45
86
Name Engine Version Row_format Rows Avg_row_length Data_length Max_data_length Index_length Data_free Auto_increment Create_time Update_time Check_time Collation Checksum Create_options Comment
78
Session Schema Name Type Engine Version Rows Avg_row_length Table_size Auto_increment
88
80
Catalog Database Table Table_alias Column Column_alias Type Length Max length Is_null Flags Decimals Charsetnr
89
81
def data_dictionary schema_names SCHEMA_NAMES SCHEMA_NAME Database 8 256 18 N 1 0 45
325
317
insert into t2 values (1),(2);
326
318
insert into t3 values (1,1),(2,2);
327
319
show table status;
328
Name Engine Version Row_format Rows Avg_row_length Data_length Max_data_length Index_length Data_free Auto_increment Create_time Update_time Check_time Collation Checksum Create_options Comment
329
t1 MEMORY 0 DEFAULT 0 # # # # 0 0 0 0 0 utf8_general_ci 0
330
t2 MEMORY 0 DEFAULT 0 # # # # 0 0 0 0 0 utf8_general_ci 0
331
t3 MEMORY 0 DEFAULT 0 # # # # 0 0 0 0 0 utf8_general_ci 0
320
Session Schema Name Type Engine Version Rows Avg_row_length Table_size Auto_increment
321
# test t1 TEMPORARY MEMORY # # # # #
322
# test t2 TEMPORARY MEMORY # # # # #
323
# test t3 TEMPORARY MEMORY # # # # #
332
324
insert into t1 values (3),(4);
333
325
insert into t2 values (3),(4);
334
326
insert into t3 values (3,3),(4,4);
335
327
show table status;
336
Name Engine Version Row_format Rows Avg_row_length Data_length Max_data_length Index_length Data_free Auto_increment Create_time Update_time Check_time Collation Checksum Create_options Comment
337
t1 MEMORY 0 DEFAULT 0 # # # # 0 0 0 0 0 utf8_general_ci 0
338
t2 MEMORY 0 DEFAULT 0 # # # # 0 0 0 0 0 utf8_general_ci 0
339
t3 MEMORY 0 DEFAULT 0 # # # # 0 0 0 0 0 utf8_general_ci 0
328
Session Schema Name Type Engine Version Rows Avg_row_length Table_size Auto_increment
329
# test t1 TEMPORARY MEMORY # # # # #
330
# test t2 TEMPORARY MEMORY # # # # #
331
# test t3 TEMPORARY MEMORY # # # # #
340
332
insert into t1 values (5);
341
333
insert into t2 values (5);
342
334
insert into t3 values (5,5);
343
335
show table status;
344
Name Engine Version Row_format Rows Avg_row_length Data_length Max_data_length Index_length Data_free Auto_increment Create_time Update_time Check_time Collation Checksum Create_options Comment
345
t1 MEMORY 0 DEFAULT 0 # # # # 0 0 0 0 0 utf8_general_ci 0
346
t2 MEMORY 0 DEFAULT 0 # # # # 0 0 0 0 0 utf8_general_ci 0
347
t3 MEMORY 0 DEFAULT 0 # # # # 0 0 0 0 0 utf8_general_ci 0
336
Session Schema Name Type Engine Version Rows Avg_row_length Table_size Auto_increment
337
# test t1 TEMPORARY MEMORY # # # # #
338
# test t2 TEMPORARY MEMORY # # # # #
339
# test t3 TEMPORARY MEMORY # # # # #
348
340
delete from t1 where a=3;
349
341
delete from t2 where b=3;
350
342
delete from t3 where a=3;
351
343
show table status;
352
Name Engine Version Row_format Rows Avg_row_length Data_length Max_data_length Index_length Data_free Auto_increment Create_time Update_time Check_time Collation Checksum Create_options Comment
353
t1 MEMORY 0 DEFAULT 0 # # # # # 0 0 0 0 utf8_general_ci 0
354
t2 MEMORY 0 DEFAULT 0 # # # # # 0 0 0 0 utf8_general_ci 0
355
t3 MEMORY 0 DEFAULT 0 # # # # # 0 0 0 0 utf8_general_ci 0
344
Session Schema Name Type Engine Version Rows Avg_row_length Table_size Auto_increment
345
# test t1 TEMPORARY MEMORY # # # # #
346
# test t2 TEMPORARY MEMORY # # # # #
347
# test t3 TEMPORARY MEMORY # # # # #
356
348
truncate table t1;
357
349
truncate table t2;
358
350
truncate table t3;
359
351
show table status;
360
Name Engine Version Row_format Rows Avg_row_length Data_length Max_data_length Index_length Data_free Auto_increment Create_time Update_time Check_time Collation Checksum Create_options Comment
361
t1 MEMORY 0 DEFAULT 0 # # # # 0 0 0 0 0 utf8_general_ci 0
362
t2 MEMORY 0 DEFAULT 0 # # # # 0 0 0 0 0 utf8_general_ci 0
363
t3 MEMORY 0 DEFAULT 0 # # # # 0 0 0 0 0 utf8_general_ci 0
352
Session Schema Name Type Engine Version Rows Avg_row_length Table_size Auto_increment
353
# test t1 TEMPORARY MEMORY # # # # #
354
# test t2 TEMPORARY MEMORY # # # # #
355
# test t3 TEMPORARY MEMORY # # # # #
364
356
insert into t1 values (5);
365
357
insert into t2 values (5);
366
358
insert into t3 values (5,5);
367
359
show table status;
368
Name Engine Version Row_format Rows Avg_row_length Data_length Max_data_length Index_length Data_free Auto_increment Create_time Update_time Check_time Collation Checksum Create_options Comment
369
t1 MEMORY 0 DEFAULT 0 # # # # 0 0 0 0 0 utf8_general_ci 0
370
t2 MEMORY 0 DEFAULT 0 # # # # 0 0 0 0 0 utf8_general_ci 0
371
t3 MEMORY 0 DEFAULT 0 # # # # 0 0 0 0 0 utf8_general_ci 0
360
Session Schema Name Type Engine Version Rows Avg_row_length Table_size Auto_increment
361
# test t1 TEMPORARY MEMORY # # # # #
362
# test t2 TEMPORARY MEMORY # # # # #
363
# test t3 TEMPORARY MEMORY # # # # #
372
364
delete from t1 where a=5;
373
365
delete from t2 where b=5;
374
366
delete from t3 where a=5;
375
367
show table status;
376
Name Engine Version Row_format Rows Avg_row_length Data_length Max_data_length Index_length Data_free Auto_increment Create_time Update_time Check_time Collation Checksum Create_options Comment
377
t1 MEMORY 0 DEFAULT 0 # # # # # 0 0 0 0 utf8_general_ci 0
378
t2 MEMORY 0 DEFAULT 0 # # # # # 0 0 0 0 utf8_general_ci 0
379
t3 MEMORY 0 DEFAULT 0 # # # # # 0 0 0 0 utf8_general_ci 0
368
Session Schema Name Type Engine Version Rows Avg_row_length Table_size Auto_increment
369
# test t1 TEMPORARY MEMORY # # # # #
370
# test t2 TEMPORARY MEMORY # # # # #
371
# test t3 TEMPORARY MEMORY # # # # #
380
372
drop table t1, t2, t3;
381
373
CREATE TEMPORARY TABLE t1 (i int, KEY (i)) ENGINE=MEMORY;
382
374
SHOW CREATE TABLE t1;