59
59
CHARACTER_SET_NAME DEFAULT_COLLATE_NAME DESCRIPTION MAXLEN
60
60
select * from information_schema.COLLATIONS
61
61
where COLLATION_NAME like 'latin1%';
62
COLLATION_NAME CHARACTER_SET_NAME ID IS_DEFAULT IS_COMPILED SORTLEN
62
COLLATION_NAME CHARACTER_SET_NAME DESCRIPTION ID IS_DEFAULT IS_COMPILED SORTLEN
63
63
select * from information_schema.COLLATION_CHARACTER_SET_APPLICABILITY
64
64
where COLLATION_NAME like 'latin1%';
65
65
COLLATION_NAME CHARACTER_SET_NAME
245
245
AND t.table_name NOT LIKE 'falcon%';
246
246
table_name column_name
247
CHARACTER_SETS CHARACTER_SET_NAME
248
COLLATIONS COLLATION_NAME
249
COLLATION_CHARACTER_SET_APPLICABILITY COLLATION_NAME
250
247
COLUMNS TABLE_SCHEMA
251
248
GLOBAL_STATUS VARIABLE_NAME
252
249
GLOBAL_VARIABLES VARIABLE_NAME
253
KEY_COLUMN_USAGE CONSTRAINT_SCHEMA
256
REFERENTIAL_CONSTRAINTS CONSTRAINT_SCHEMA
257
250
SCHEMATA SCHEMA_NAME
258
251
SESSION_STATUS VARIABLE_NAME
259
252
SESSION_VARIABLES VARIABLE_NAME
260
253
STATISTICS TABLE_SCHEMA
261
254
TABLES TABLE_SCHEMA
262
TABLE_CONSTRAINTS CONSTRAINT_SCHEMA
263
255
INNODB_TRX trx_id
264
256
INNODB_LOCKS lock_id
265
257
INNODB_LOCK_WAITS requesting_trx_id
267
259
INNODB_CMP_RESET page_size
268
260
INNODB_CMPMEM page_size
269
261
INNODB_CMPMEM_RESET page_size
262
CHARACTER_SETS CHARACTER_SET_NAME
263
COLLATIONS COLLATION_NAME
264
COLLATION_CHARACTER_SET_APPLICABILITY COLLATION_NAME
265
KEY_COLUMN_USAGE CONSTRAINT_SCHEMA
268
REFERENTIAL_CONSTRAINTS CONSTRAINT_SCHEMA
269
TABLE_CONSTRAINTS CONSTRAINT_SCHEMA
270
270
SELECT t.table_name, c1.column_name
271
271
FROM information_schema.tables t
284
284
AND t.table_name NOT LIKE 'falcon%';
285
285
table_name column_name
286
CHARACTER_SETS CHARACTER_SET_NAME
287
COLLATIONS COLLATION_NAME
288
COLLATION_CHARACTER_SET_APPLICABILITY COLLATION_NAME
289
286
COLUMNS TABLE_SCHEMA
290
287
GLOBAL_STATUS VARIABLE_NAME
291
288
GLOBAL_VARIABLES VARIABLE_NAME
292
KEY_COLUMN_USAGE CONSTRAINT_SCHEMA
295
REFERENTIAL_CONSTRAINTS CONSTRAINT_SCHEMA
296
289
SCHEMATA SCHEMA_NAME
297
290
SESSION_STATUS VARIABLE_NAME
298
291
SESSION_VARIABLES VARIABLE_NAME
299
292
STATISTICS TABLE_SCHEMA
300
293
TABLES TABLE_SCHEMA
301
TABLE_CONSTRAINTS CONSTRAINT_SCHEMA
302
294
INNODB_TRX trx_id
303
295
INNODB_LOCKS lock_id
304
296
INNODB_LOCK_WAITS requesting_trx_id
306
298
INNODB_CMP_RESET page_size
307
299
INNODB_CMPMEM page_size
308
300
INNODB_CMPMEM_RESET page_size
301
CHARACTER_SETS CHARACTER_SET_NAME
302
COLLATIONS COLLATION_NAME
303
COLLATION_CHARACTER_SET_APPLICABILITY COLLATION_NAME
304
KEY_COLUMN_USAGE CONSTRAINT_SCHEMA
307
REFERENTIAL_CONSTRAINTS CONSTRAINT_SCHEMA
308
TABLE_CONSTRAINTS CONSTRAINT_SCHEMA
309
309
SELECT MAX(table_name) FROM information_schema.tables;
311
311
TABLE_CONSTRAINTS
452
452
SELECT info FROM information_schema.processlist WHERE id = CONNECTION_ID();
454
454
SELECT info FROM information_schema.processlist WHERE id = CONNECTION_ID()
456
Id User Host db Command Time State Info
457
# # # mysqltest Sleep # # NULL
458
# # # test Sleep # # NULL
459
# # # test Query # # show processlist
460
SELECT info, command, db
461
FROM information_schema.processlist
462
WHERE id = CONNECTION_ID();
464
SELECT info, command, db
465
FROM information_schema.processlist
466
WHERE id = CONNECTION_ID() Query test
468
FROM information_schema.character_sets;
469
CHARACTER_SET_NAME DEFAULT_COLLATE_NAME DESCRIPTION MAXLEN
470
utf8 utf8_general_ci UTF-8 Unicode 4
473
FROM information_schema.collations;
474
COLLATION_NAME CHARACTER_SET_NAME DESCRIPTION ID IS_DEFAULT IS_COMPILED SORTLEN
475
utf8_general_ci utf8 45 0 Yes 1 0
476
utf8_bin utf8 46 0 Yes 1 0
477
utf8_unicode_ci utf8 224 0 Yes 8 0
478
utf8_icelandic_ci utf8 225 0 Yes 8 0
479
utf8_latvian_ci utf8 226 0 Yes 8 0
480
utf8_romanian_ci utf8 227 0 Yes 8 0
481
utf8_slovenian_ci utf8 228 0 Yes 8 0
482
utf8_polish_ci utf8 229 0 Yes 8 0
483
utf8_estonian_ci utf8 230 0 Yes 8 0
484
utf8_spanish_ci utf8 231 0 Yes 8 0
485
utf8_swedish_ci utf8 232 0 Yes 8 0
486
utf8_turkish_ci utf8 233 0 Yes 8 0
487
utf8_czech_ci utf8 234 0 Yes 8 0
488
utf8_danish_ci utf8 235 0 Yes 8 0
489
utf8_lithuanian_ci utf8 236 0 Yes 8 0
490
utf8_slovak_ci utf8 237 0 Yes 8 0
491
utf8_spanish2_ci utf8 238 0 Yes 8 0
492
utf8_roman_ci utf8 239 0 Yes 8 0
493
utf8_persian_ci utf8 240 0 Yes 8 0
494
utf8_esperanto_ci utf8 241 0 Yes 8 0
495
utf8_hungarian_ci utf8 242 0 Yes 8 0
496
utf8_sinhala_ci utf8 243 0 Yes 8 0
497
binary binary 63 0 Yes 1 0
499
FROM information_schema.collation_character_set_applicability;
500
COLLATION_NAME CHARACTER_SET_NAME
504
utf8_icelandic_ci utf8
506
utf8_romanian_ci utf8
507
utf8_slovenian_ci utf8
509
utf8_estonian_ci utf8
515
utf8_lithuanian_ci utf8
517
utf8_spanish2_ci utf8
520
utf8_esperanto_ci utf8
521
utf8_hungarian_ci utf8
525
FROM information_schema.key_column_usage;
526
CONSTRAINT_CATALOG CONSTRAINT_SCHEMA CONSTRAINT_NAME TABLE_CATALOG TABLE_SCHEMA TABLE_NAME COLUMN_NAME ORDINAL_POSITION POSITION_IN_UNIQUE_CONSTRAINT REFERENCED_TABLE_SCHEMA REFERENCED_TABLE_NAME REFERENCED_COLUMN_NAME
528
FROM information_schema.referential_constraints;
529
CONSTRAINT_CATALOG CONSTRAINT_SCHEMA CONSTRAINT_NAME UNIQUE_CONSTRAINT_CATALOG UNIQUE_CONSTRAINT_SCHEMA UNIQUE_CONSTRAINT_NAME MATCH_OPTION UPDATE_RULE DELETE_RULE TABLE_NAME REFERENCED_TABLE_NAME
531
FROM information_schema.table_constraints;
532
CONSTRAINT_CATALOG CONSTRAINT_SCHEMA CONSTRAINT_NAME TABLE_SCHEMA TABLE_NAME CONSTRAINT_TYPE
added
removed
tests/r/information_schema.result
