1DROP DATABASE IF EXISTS test1; 2CREATE DATABASE test1; 3SELECT *, 4LEFT( table_comment, 5IF(INSTR(table_comment,'InnoDB free') = 0, 6LENGTH(table_comment), 7INSTR(table_comment,'InnoDB free') - 1)) 8AS "user_comment", 9'-----------------------------------------------------' AS "Separator" 10FROM information_schema.tables 11WHERE table_schema = 'mysql' 12ORDER BY table_schema,table_name; 13TABLE_CATALOG def 14TABLE_SCHEMA mysql 15TABLE_NAME columns_priv 16TABLE_TYPE BASE TABLE 17ENGINE MYISAM_OR_MARIA 18VERSION 10 19ROW_FORMAT Fixed 20TABLE_ROWS #TBLR# 21AVG_ROW_LENGTH #ARL# 22DATA_LENGTH #DL# 23MAX_DATA_LENGTH #MDL# 24INDEX_LENGTH #IL# 25DATA_FREE #DF# 26AUTO_INCREMENT NULL 27CREATE_TIME #CRT# 28UPDATE_TIME #UT# 29CHECK_TIME #CT# 30TABLE_COLLATION utf8_bin 31CHECKSUM NULL 32CREATE_OPTIONS #CO# 33TABLE_COMMENT #TC# 34MAX_INDEX_LENGTH #MIL# 35TEMPORARY N 36user_comment Column privileges 37Separator ----------------------------------------------------- 38TABLE_CATALOG def 39TABLE_SCHEMA mysql 40TABLE_NAME column_stats 41TABLE_TYPE BASE TABLE 42ENGINE MYISAM_OR_MARIA 43VERSION 10 44ROW_FORMAT DYNAMIC_OR_PAGE 45TABLE_ROWS #TBLR# 46AVG_ROW_LENGTH #ARL# 47DATA_LENGTH #DL# 48MAX_DATA_LENGTH #MDL# 49INDEX_LENGTH #IL# 50DATA_FREE #DF# 51AUTO_INCREMENT NULL 52CREATE_TIME #CRT# 53UPDATE_TIME #UT# 54CHECK_TIME #CT# 55TABLE_COLLATION utf8_bin 56CHECKSUM NULL 57CREATE_OPTIONS #CO# 58TABLE_COMMENT #TC# 59MAX_INDEX_LENGTH #MIL# 60TEMPORARY N 61user_comment Statistics on Columns 62Separator ----------------------------------------------------- 63TABLE_CATALOG def 64TABLE_SCHEMA mysql 65TABLE_NAME db 66TABLE_TYPE BASE TABLE 67ENGINE MYISAM_OR_MARIA 68VERSION 10 69ROW_FORMAT Fixed 70TABLE_ROWS #TBLR# 71AVG_ROW_LENGTH #ARL# 72DATA_LENGTH #DL# 73MAX_DATA_LENGTH #MDL# 74INDEX_LENGTH #IL# 75DATA_FREE #DF# 76AUTO_INCREMENT NULL 77CREATE_TIME #CRT# 78UPDATE_TIME #UT# 79CHECK_TIME #CT# 80TABLE_COLLATION utf8_bin 81CHECKSUM NULL 82CREATE_OPTIONS #CO# 83TABLE_COMMENT #TC# 84MAX_INDEX_LENGTH #MIL# 85TEMPORARY N 86user_comment Database privileges 87Separator ----------------------------------------------------- 88TABLE_CATALOG def 89TABLE_SCHEMA mysql 90TABLE_NAME event 91TABLE_TYPE BASE TABLE 92ENGINE MYISAM_OR_MARIA 93VERSION 10 94ROW_FORMAT DYNAMIC_OR_PAGE 95TABLE_ROWS #TBLR# 96AVG_ROW_LENGTH #ARL# 97DATA_LENGTH #DL# 98MAX_DATA_LENGTH #MDL# 99INDEX_LENGTH #IL# 100DATA_FREE #DF# 101AUTO_INCREMENT NULL 102CREATE_TIME #CRT# 103UPDATE_TIME #UT# 104CHECK_TIME #CT# 105TABLE_COLLATION utf8_general_ci 106CHECKSUM NULL 107CREATE_OPTIONS #CO# 108TABLE_COMMENT #TC# 109MAX_INDEX_LENGTH #MIL# 110TEMPORARY N 111user_comment Events 112Separator ----------------------------------------------------- 113TABLE_CATALOG def 114TABLE_SCHEMA mysql 115TABLE_NAME func 116TABLE_TYPE BASE TABLE 117ENGINE MYISAM_OR_MARIA 118VERSION 10 119ROW_FORMAT Fixed 120TABLE_ROWS #TBLR# 121AVG_ROW_LENGTH #ARL# 122DATA_LENGTH #DL# 123MAX_DATA_LENGTH #MDL# 124INDEX_LENGTH #IL# 125DATA_FREE #DF# 126AUTO_INCREMENT NULL 127CREATE_TIME #CRT# 128UPDATE_TIME #UT# 129CHECK_TIME #CT# 130TABLE_COLLATION utf8_bin 131CHECKSUM NULL 132CREATE_OPTIONS #CO# 133TABLE_COMMENT #TC# 134MAX_INDEX_LENGTH #MIL# 135TEMPORARY N 136user_comment User defined functions 137Separator ----------------------------------------------------- 138TABLE_CATALOG def 139TABLE_SCHEMA mysql 140TABLE_NAME general_log 141TABLE_TYPE BASE TABLE 142ENGINE CSV 143VERSION 10 144ROW_FORMAT DYNAMIC_OR_PAGE 145TABLE_ROWS #TBLR# 146AVG_ROW_LENGTH #ARL# 147DATA_LENGTH #DL# 148MAX_DATA_LENGTH #MDL# 149INDEX_LENGTH #IL# 150DATA_FREE #DF# 151AUTO_INCREMENT NULL 152CREATE_TIME #CRT# 153UPDATE_TIME #UT# 154CHECK_TIME #CT# 155TABLE_COLLATION utf8_general_ci 156CHECKSUM NULL 157CREATE_OPTIONS #CO# 158TABLE_COMMENT #TC# 159MAX_INDEX_LENGTH #MIL# 160TEMPORARY N 161user_comment General log 162Separator ----------------------------------------------------- 163TABLE_CATALOG def 164TABLE_SCHEMA mysql 165TABLE_NAME gtid_slave_pos 166TABLE_TYPE BASE TABLE 167ENGINE MYISAM_OR_MARIA 168VERSION 10 169ROW_FORMAT Fixed 170TABLE_ROWS #TBLR# 171AVG_ROW_LENGTH #ARL# 172DATA_LENGTH #DL# 173MAX_DATA_LENGTH #MDL# 174INDEX_LENGTH #IL# 175DATA_FREE #DF# 176AUTO_INCREMENT NULL 177CREATE_TIME #CRT# 178UPDATE_TIME #UT# 179CHECK_TIME #CT# 180TABLE_COLLATION latin1_swedish_ci 181CHECKSUM NULL 182CREATE_OPTIONS #CO# 183TABLE_COMMENT #TC# 184MAX_INDEX_LENGTH #MIL# 185TEMPORARY N 186user_comment Replication slave GTID position 187Separator ----------------------------------------------------- 188TABLE_CATALOG def 189TABLE_SCHEMA mysql 190TABLE_NAME help_category 191TABLE_TYPE BASE TABLE 192ENGINE MYISAM_OR_MARIA 193VERSION 10 194ROW_FORMAT DYNAMIC_OR_PAGE 195TABLE_ROWS #TBLR# 196AVG_ROW_LENGTH #ARL# 197DATA_LENGTH #DL# 198MAX_DATA_LENGTH #MDL# 199INDEX_LENGTH #IL# 200DATA_FREE #DF# 201AUTO_INCREMENT NULL 202CREATE_TIME #CRT# 203UPDATE_TIME #UT# 204CHECK_TIME #CT# 205TABLE_COLLATION utf8_general_ci 206CHECKSUM NULL 207CREATE_OPTIONS #CO# 208TABLE_COMMENT #TC# 209MAX_INDEX_LENGTH #MIL# 210TEMPORARY N 211user_comment help categories 212Separator ----------------------------------------------------- 213TABLE_CATALOG def 214TABLE_SCHEMA mysql 215TABLE_NAME help_keyword 216TABLE_TYPE BASE TABLE 217ENGINE MYISAM_OR_MARIA 218VERSION 10 219ROW_FORMAT Fixed 220TABLE_ROWS #TBLR# 221AVG_ROW_LENGTH #ARL# 222DATA_LENGTH #DL# 223MAX_DATA_LENGTH #MDL# 224INDEX_LENGTH #IL# 225DATA_FREE #DF# 226AUTO_INCREMENT NULL 227CREATE_TIME #CRT# 228UPDATE_TIME #UT# 229CHECK_TIME #CT# 230TABLE_COLLATION utf8_general_ci 231CHECKSUM NULL 232CREATE_OPTIONS #CO# 233TABLE_COMMENT #TC# 234MAX_INDEX_LENGTH #MIL# 235TEMPORARY N 236user_comment help keywords 237Separator ----------------------------------------------------- 238TABLE_CATALOG def 239TABLE_SCHEMA mysql 240TABLE_NAME help_relation 241TABLE_TYPE BASE TABLE 242ENGINE MYISAM_OR_MARIA 243VERSION 10 244ROW_FORMAT Fixed 245TABLE_ROWS #TBLR# 246AVG_ROW_LENGTH #ARL# 247DATA_LENGTH #DL# 248MAX_DATA_LENGTH #MDL# 249INDEX_LENGTH #IL# 250DATA_FREE #DF# 251AUTO_INCREMENT NULL 252CREATE_TIME #CRT# 253UPDATE_TIME #UT# 254CHECK_TIME #CT# 255TABLE_COLLATION utf8_general_ci 256CHECKSUM NULL 257CREATE_OPTIONS #CO# 258TABLE_COMMENT #TC# 259MAX_INDEX_LENGTH #MIL# 260TEMPORARY N 261user_comment keyword-topic relation 262Separator ----------------------------------------------------- 263TABLE_CATALOG def 264TABLE_SCHEMA mysql 265TABLE_NAME help_topic 266TABLE_TYPE BASE TABLE 267ENGINE MYISAM_OR_MARIA 268VERSION 10 269ROW_FORMAT DYNAMIC_OR_PAGE 270TABLE_ROWS #TBLR# 271AVG_ROW_LENGTH #ARL# 272DATA_LENGTH #DL# 273MAX_DATA_LENGTH #MDL# 274INDEX_LENGTH #IL# 275DATA_FREE #DF# 276AUTO_INCREMENT NULL 277CREATE_TIME #CRT# 278UPDATE_TIME #UT# 279CHECK_TIME #CT# 280TABLE_COLLATION utf8_general_ci 281CHECKSUM NULL 282CREATE_OPTIONS #CO# 283TABLE_COMMENT #TC# 284MAX_INDEX_LENGTH #MIL# 285TEMPORARY N 286user_comment help topics 287Separator ----------------------------------------------------- 288TABLE_CATALOG def 289TABLE_SCHEMA mysql 290TABLE_NAME host 291TABLE_TYPE BASE TABLE 292ENGINE MYISAM_OR_MARIA 293VERSION 10 294ROW_FORMAT Fixed 295TABLE_ROWS #TBLR# 296AVG_ROW_LENGTH #ARL# 297DATA_LENGTH #DL# 298MAX_DATA_LENGTH #MDL# 299INDEX_LENGTH #IL# 300DATA_FREE #DF# 301AUTO_INCREMENT NULL 302CREATE_TIME #CRT# 303UPDATE_TIME #UT# 304CHECK_TIME #CT# 305TABLE_COLLATION utf8_bin 306CHECKSUM NULL 307CREATE_OPTIONS #CO# 308TABLE_COMMENT #TC# 309MAX_INDEX_LENGTH #MIL# 310TEMPORARY N 311user_comment Host privileges; Merged with database privileges 312Separator ----------------------------------------------------- 313TABLE_CATALOG def 314TABLE_SCHEMA mysql 315TABLE_NAME index_stats 316TABLE_TYPE BASE TABLE 317ENGINE MYISAM_OR_MARIA 318VERSION 10 319ROW_FORMAT DYNAMIC_OR_PAGE 320TABLE_ROWS #TBLR# 321AVG_ROW_LENGTH #ARL# 322DATA_LENGTH #DL# 323MAX_DATA_LENGTH #MDL# 324INDEX_LENGTH #IL# 325DATA_FREE #DF# 326AUTO_INCREMENT NULL 327CREATE_TIME #CRT# 328UPDATE_TIME #UT# 329CHECK_TIME #CT# 330TABLE_COLLATION utf8_bin 331CHECKSUM NULL 332CREATE_OPTIONS #CO# 333TABLE_COMMENT #TC# 334MAX_INDEX_LENGTH #MIL# 335TEMPORARY N 336user_comment Statistics on Indexes 337Separator ----------------------------------------------------- 338TABLE_CATALOG def 339TABLE_SCHEMA mysql 340TABLE_NAME innodb_index_stats 341TABLE_TYPE BASE TABLE 342ENGINE InnoDB 343VERSION 10 344ROW_FORMAT DYNAMIC_OR_PAGE 345TABLE_ROWS #TBLR# 346AVG_ROW_LENGTH #ARL# 347DATA_LENGTH #DL# 348MAX_DATA_LENGTH #MDL# 349INDEX_LENGTH #IL# 350DATA_FREE #DF# 351AUTO_INCREMENT NULL 352CREATE_TIME #CRT# 353UPDATE_TIME #UT# 354CHECK_TIME #CT# 355TABLE_COLLATION utf8_bin 356CHECKSUM NULL 357CREATE_OPTIONS #CO# 358TABLE_COMMENT #TC# 359MAX_INDEX_LENGTH #MIL# 360TEMPORARY N 361user_comment 362Separator ----------------------------------------------------- 363TABLE_CATALOG def 364TABLE_SCHEMA mysql 365TABLE_NAME innodb_table_stats 366TABLE_TYPE BASE TABLE 367ENGINE InnoDB 368VERSION 10 369ROW_FORMAT DYNAMIC_OR_PAGE 370TABLE_ROWS #TBLR# 371AVG_ROW_LENGTH #ARL# 372DATA_LENGTH #DL# 373MAX_DATA_LENGTH #MDL# 374INDEX_LENGTH #IL# 375DATA_FREE #DF# 376AUTO_INCREMENT NULL 377CREATE_TIME #CRT# 378UPDATE_TIME #UT# 379CHECK_TIME #CT# 380TABLE_COLLATION utf8_bin 381CHECKSUM NULL 382CREATE_OPTIONS #CO# 383TABLE_COMMENT #TC# 384MAX_INDEX_LENGTH #MIL# 385TEMPORARY N 386user_comment 387Separator ----------------------------------------------------- 388TABLE_CATALOG def 389TABLE_SCHEMA mysql 390TABLE_NAME plugin 391TABLE_TYPE BASE TABLE 392ENGINE MYISAM_OR_MARIA 393VERSION 10 394ROW_FORMAT DYNAMIC_OR_PAGE 395TABLE_ROWS #TBLR# 396AVG_ROW_LENGTH #ARL# 397DATA_LENGTH #DL# 398MAX_DATA_LENGTH #MDL# 399INDEX_LENGTH #IL# 400DATA_FREE #DF# 401AUTO_INCREMENT NULL 402CREATE_TIME #CRT# 403UPDATE_TIME #UT# 404CHECK_TIME #CT# 405TABLE_COLLATION utf8_general_ci 406CHECKSUM NULL 407CREATE_OPTIONS #CO# 408TABLE_COMMENT #TC# 409MAX_INDEX_LENGTH #MIL# 410TEMPORARY N 411user_comment MySQL plugins 412Separator ----------------------------------------------------- 413TABLE_CATALOG def 414TABLE_SCHEMA mysql 415TABLE_NAME proc 416TABLE_TYPE BASE TABLE 417ENGINE MYISAM_OR_MARIA 418VERSION 10 419ROW_FORMAT DYNAMIC_OR_PAGE 420TABLE_ROWS #TBLR# 421AVG_ROW_LENGTH #ARL# 422DATA_LENGTH #DL# 423MAX_DATA_LENGTH #MDL# 424INDEX_LENGTH #IL# 425DATA_FREE #DF# 426AUTO_INCREMENT NULL 427CREATE_TIME #CRT# 428UPDATE_TIME #UT# 429CHECK_TIME #CT# 430TABLE_COLLATION utf8_general_ci 431CHECKSUM NULL 432CREATE_OPTIONS #CO# 433TABLE_COMMENT #TC# 434MAX_INDEX_LENGTH #MIL# 435TEMPORARY N 436user_comment Stored Procedures 437Separator ----------------------------------------------------- 438TABLE_CATALOG def 439TABLE_SCHEMA mysql 440TABLE_NAME procs_priv 441TABLE_TYPE BASE TABLE 442ENGINE MYISAM_OR_MARIA 443VERSION 10 444ROW_FORMAT Fixed 445TABLE_ROWS #TBLR# 446AVG_ROW_LENGTH #ARL# 447DATA_LENGTH #DL# 448MAX_DATA_LENGTH #MDL# 449INDEX_LENGTH #IL# 450DATA_FREE #DF# 451AUTO_INCREMENT NULL 452CREATE_TIME #CRT# 453UPDATE_TIME #UT# 454CHECK_TIME #CT# 455TABLE_COLLATION utf8_bin 456CHECKSUM NULL 457CREATE_OPTIONS #CO# 458TABLE_COMMENT #TC# 459MAX_INDEX_LENGTH #MIL# 460TEMPORARY N 461user_comment Procedure privileges 462Separator ----------------------------------------------------- 463TABLE_CATALOG def 464TABLE_SCHEMA mysql 465TABLE_NAME proxies_priv 466TABLE_TYPE BASE TABLE 467ENGINE MYISAM_OR_MARIA 468VERSION 10 469ROW_FORMAT Fixed 470TABLE_ROWS #TBLR# 471AVG_ROW_LENGTH #ARL# 472DATA_LENGTH #DL# 473MAX_DATA_LENGTH #MDL# 474INDEX_LENGTH #IL# 475DATA_FREE #DF# 476AUTO_INCREMENT NULL 477CREATE_TIME #CRT# 478UPDATE_TIME #UT# 479CHECK_TIME #CT# 480TABLE_COLLATION utf8_bin 481CHECKSUM NULL 482CREATE_OPTIONS #CO# 483TABLE_COMMENT #TC# 484MAX_INDEX_LENGTH #MIL# 485TEMPORARY N 486user_comment User proxy privileges 487Separator ----------------------------------------------------- 488TABLE_CATALOG def 489TABLE_SCHEMA mysql 490TABLE_NAME roles_mapping 491TABLE_TYPE BASE TABLE 492ENGINE MYISAM_OR_MARIA 493VERSION 10 494ROW_FORMAT Fixed 495TABLE_ROWS #TBLR# 496AVG_ROW_LENGTH #ARL# 497DATA_LENGTH #DL# 498MAX_DATA_LENGTH #MDL# 499INDEX_LENGTH #IL# 500DATA_FREE #DF# 501AUTO_INCREMENT NULL 502CREATE_TIME #CRT# 503UPDATE_TIME #UT# 504CHECK_TIME #CT# 505TABLE_COLLATION utf8_bin 506CHECKSUM NULL 507CREATE_OPTIONS #CO# 508TABLE_COMMENT #TC# 509MAX_INDEX_LENGTH #MIL# 510TEMPORARY N 511user_comment Granted roles 512Separator ----------------------------------------------------- 513TABLE_CATALOG def 514TABLE_SCHEMA mysql 515TABLE_NAME servers 516TABLE_TYPE BASE TABLE 517ENGINE MYISAM_OR_MARIA 518VERSION 10 519ROW_FORMAT DYNAMIC_OR_PAGE 520TABLE_ROWS #TBLR# 521AVG_ROW_LENGTH #ARL# 522DATA_LENGTH #DL# 523MAX_DATA_LENGTH #MDL# 524INDEX_LENGTH #IL# 525DATA_FREE #DF# 526AUTO_INCREMENT NULL 527CREATE_TIME #CRT# 528UPDATE_TIME #UT# 529CHECK_TIME #CT# 530TABLE_COLLATION utf8_general_ci 531CHECKSUM NULL 532CREATE_OPTIONS #CO# 533TABLE_COMMENT #TC# 534MAX_INDEX_LENGTH #MIL# 535TEMPORARY N 536user_comment MySQL Foreign Servers table 537Separator ----------------------------------------------------- 538TABLE_CATALOG def 539TABLE_SCHEMA mysql 540TABLE_NAME slow_log 541TABLE_TYPE BASE TABLE 542ENGINE CSV 543VERSION 10 544ROW_FORMAT DYNAMIC_OR_PAGE 545TABLE_ROWS #TBLR# 546AVG_ROW_LENGTH #ARL# 547DATA_LENGTH #DL# 548MAX_DATA_LENGTH #MDL# 549INDEX_LENGTH #IL# 550DATA_FREE #DF# 551AUTO_INCREMENT NULL 552CREATE_TIME #CRT# 553UPDATE_TIME #UT# 554CHECK_TIME #CT# 555TABLE_COLLATION utf8_general_ci 556CHECKSUM NULL 557CREATE_OPTIONS #CO# 558TABLE_COMMENT #TC# 559MAX_INDEX_LENGTH #MIL# 560TEMPORARY N 561user_comment Slow log 562Separator ----------------------------------------------------- 563TABLE_CATALOG def 564TABLE_SCHEMA mysql 565TABLE_NAME tables_priv 566TABLE_TYPE BASE TABLE 567ENGINE MYISAM_OR_MARIA 568VERSION 10 569ROW_FORMAT Fixed 570TABLE_ROWS #TBLR# 571AVG_ROW_LENGTH #ARL# 572DATA_LENGTH #DL# 573MAX_DATA_LENGTH #MDL# 574INDEX_LENGTH #IL# 575DATA_FREE #DF# 576AUTO_INCREMENT NULL 577CREATE_TIME #CRT# 578UPDATE_TIME #UT# 579CHECK_TIME #CT# 580TABLE_COLLATION utf8_bin 581CHECKSUM NULL 582CREATE_OPTIONS #CO# 583TABLE_COMMENT #TC# 584MAX_INDEX_LENGTH #MIL# 585TEMPORARY N 586user_comment Table privileges 587Separator ----------------------------------------------------- 588TABLE_CATALOG def 589TABLE_SCHEMA mysql 590TABLE_NAME table_stats 591TABLE_TYPE BASE TABLE 592ENGINE MYISAM_OR_MARIA 593VERSION 10 594ROW_FORMAT DYNAMIC_OR_PAGE 595TABLE_ROWS #TBLR# 596AVG_ROW_LENGTH #ARL# 597DATA_LENGTH #DL# 598MAX_DATA_LENGTH #MDL# 599INDEX_LENGTH #IL# 600DATA_FREE #DF# 601AUTO_INCREMENT NULL 602CREATE_TIME #CRT# 603UPDATE_TIME #UT# 604CHECK_TIME #CT# 605TABLE_COLLATION utf8_bin 606CHECKSUM NULL 607CREATE_OPTIONS #CO# 608TABLE_COMMENT #TC# 609MAX_INDEX_LENGTH #MIL# 610TEMPORARY N 611user_comment Statistics on Tables 612Separator ----------------------------------------------------- 613TABLE_CATALOG def 614TABLE_SCHEMA mysql 615TABLE_NAME time_zone 616TABLE_TYPE BASE TABLE 617ENGINE MYISAM_OR_MARIA 618VERSION 10 619ROW_FORMAT Fixed 620TABLE_ROWS #TBLR# 621AVG_ROW_LENGTH #ARL# 622DATA_LENGTH #DL# 623MAX_DATA_LENGTH #MDL# 624INDEX_LENGTH #IL# 625DATA_FREE #DF# 626AUTO_INCREMENT 6 627CREATE_TIME #CRT# 628UPDATE_TIME #UT# 629CHECK_TIME #CT# 630TABLE_COLLATION utf8_general_ci 631CHECKSUM NULL 632CREATE_OPTIONS #CO# 633TABLE_COMMENT #TC# 634MAX_INDEX_LENGTH #MIL# 635TEMPORARY N 636user_comment Time zones 637Separator ----------------------------------------------------- 638TABLE_CATALOG def 639TABLE_SCHEMA mysql 640TABLE_NAME time_zone_leap_second 641TABLE_TYPE BASE TABLE 642ENGINE MYISAM_OR_MARIA 643VERSION 10 644ROW_FORMAT Fixed 645TABLE_ROWS #TBLR# 646AVG_ROW_LENGTH #ARL# 647DATA_LENGTH #DL# 648MAX_DATA_LENGTH #MDL# 649INDEX_LENGTH #IL# 650DATA_FREE #DF# 651AUTO_INCREMENT NULL 652CREATE_TIME #CRT# 653UPDATE_TIME #UT# 654CHECK_TIME #CT# 655TABLE_COLLATION utf8_general_ci 656CHECKSUM NULL 657CREATE_OPTIONS #CO# 658TABLE_COMMENT #TC# 659MAX_INDEX_LENGTH #MIL# 660TEMPORARY N 661user_comment Leap seconds information for time zones 662Separator ----------------------------------------------------- 663TABLE_CATALOG def 664TABLE_SCHEMA mysql 665TABLE_NAME time_zone_name 666TABLE_TYPE BASE TABLE 667ENGINE MYISAM_OR_MARIA 668VERSION 10 669ROW_FORMAT Fixed 670TABLE_ROWS #TBLR# 671AVG_ROW_LENGTH #ARL# 672DATA_LENGTH #DL# 673MAX_DATA_LENGTH #MDL# 674INDEX_LENGTH #IL# 675DATA_FREE #DF# 676AUTO_INCREMENT NULL 677CREATE_TIME #CRT# 678UPDATE_TIME #UT# 679CHECK_TIME #CT# 680TABLE_COLLATION utf8_general_ci 681CHECKSUM NULL 682CREATE_OPTIONS #CO# 683TABLE_COMMENT #TC# 684MAX_INDEX_LENGTH #MIL# 685TEMPORARY N 686user_comment Time zone names 687Separator ----------------------------------------------------- 688TABLE_CATALOG def 689TABLE_SCHEMA mysql 690TABLE_NAME time_zone_transition 691TABLE_TYPE BASE TABLE 692ENGINE MYISAM_OR_MARIA 693VERSION 10 694ROW_FORMAT Fixed 695TABLE_ROWS #TBLR# 696AVG_ROW_LENGTH #ARL# 697DATA_LENGTH #DL# 698MAX_DATA_LENGTH #MDL# 699INDEX_LENGTH #IL# 700DATA_FREE #DF# 701AUTO_INCREMENT NULL 702CREATE_TIME #CRT# 703UPDATE_TIME #UT# 704CHECK_TIME #CT# 705TABLE_COLLATION utf8_general_ci 706CHECKSUM NULL 707CREATE_OPTIONS #CO# 708TABLE_COMMENT #TC# 709MAX_INDEX_LENGTH #MIL# 710TEMPORARY N 711user_comment Time zone transitions 712Separator ----------------------------------------------------- 713TABLE_CATALOG def 714TABLE_SCHEMA mysql 715TABLE_NAME time_zone_transition_type 716TABLE_TYPE BASE TABLE 717ENGINE MYISAM_OR_MARIA 718VERSION 10 719ROW_FORMAT Fixed 720TABLE_ROWS #TBLR# 721AVG_ROW_LENGTH #ARL# 722DATA_LENGTH #DL# 723MAX_DATA_LENGTH #MDL# 724INDEX_LENGTH #IL# 725DATA_FREE #DF# 726AUTO_INCREMENT NULL 727CREATE_TIME #CRT# 728UPDATE_TIME #UT# 729CHECK_TIME #CT# 730TABLE_COLLATION utf8_general_ci 731CHECKSUM NULL 732CREATE_OPTIONS #CO# 733TABLE_COMMENT #TC# 734MAX_INDEX_LENGTH #MIL# 735TEMPORARY N 736user_comment Time zone transition types 737Separator ----------------------------------------------------- 738TABLE_CATALOG def 739TABLE_SCHEMA mysql 740TABLE_NAME transaction_registry 741TABLE_TYPE BASE TABLE 742ENGINE InnoDB 743VERSION 10 744ROW_FORMAT DYNAMIC_OR_PAGE 745TABLE_ROWS #TBLR# 746AVG_ROW_LENGTH #ARL# 747DATA_LENGTH #DL# 748MAX_DATA_LENGTH #MDL# 749INDEX_LENGTH #IL# 750DATA_FREE #DF# 751AUTO_INCREMENT NULL 752CREATE_TIME #CRT# 753UPDATE_TIME #UT# 754CHECK_TIME #CT# 755TABLE_COLLATION utf8_bin 756CHECKSUM NULL 757CREATE_OPTIONS #CO# 758TABLE_COMMENT #TC# 759MAX_INDEX_LENGTH #MIL# 760TEMPORARY N 761user_comment 762Separator ----------------------------------------------------- 763TABLE_CATALOG def 764TABLE_SCHEMA mysql 765TABLE_NAME user 766TABLE_TYPE BASE TABLE 767ENGINE MYISAM_OR_MARIA 768VERSION 10 769ROW_FORMAT DYNAMIC_OR_PAGE 770TABLE_ROWS #TBLR# 771AVG_ROW_LENGTH #ARL# 772DATA_LENGTH #DL# 773MAX_DATA_LENGTH #MDL# 774INDEX_LENGTH #IL# 775DATA_FREE #DF# 776AUTO_INCREMENT NULL 777CREATE_TIME #CRT# 778UPDATE_TIME #UT# 779CHECK_TIME #CT# 780TABLE_COLLATION utf8_bin 781CHECKSUM NULL 782CREATE_OPTIONS #CO# 783TABLE_COMMENT #TC# 784MAX_INDEX_LENGTH #MIL# 785TEMPORARY N 786user_comment Users and global privileges 787Separator ----------------------------------------------------- 788DROP USER testuser1@localhost; 789CREATE USER testuser1@localhost; 790GRANT SELECT ON test1.* TO testuser1@localhost; 791connect testuser1,localhost,testuser1,,test1; 792SELECT *, 793LEFT( table_comment, 794IF(INSTR(table_comment,'InnoDB free') = 0, 795LENGTH(table_comment), 796INSTR(table_comment,'InnoDB free') - 1)) 797AS "user_comment", 798'-----------------------------------------------------' AS "Separator" 799FROM information_schema.tables 800WHERE table_schema = 'mysql' 801ORDER BY table_schema,table_name; 802TABLE_CATALOG def 803TABLE_SCHEMA mysql 804TABLE_NAME columns_priv 805TABLE_TYPE BASE TABLE 806ENGINE MYISAM_OR_MARIA 807VERSION 10 808ROW_FORMAT Fixed 809TABLE_ROWS #TBLR# 810AVG_ROW_LENGTH #ARL# 811DATA_LENGTH #DL# 812MAX_DATA_LENGTH #MDL# 813INDEX_LENGTH #IL# 814DATA_FREE #DF# 815AUTO_INCREMENT NULL 816CREATE_TIME #CRT# 817UPDATE_TIME #UT# 818CHECK_TIME #CT# 819TABLE_COLLATION utf8_bin 820CHECKSUM NULL 821CREATE_OPTIONS #CO# 822TABLE_COMMENT #TC# 823MAX_INDEX_LENGTH #MIL# 824TEMPORARY N 825user_comment Column privileges 826Separator ----------------------------------------------------- 827TABLE_CATALOG def 828TABLE_SCHEMA mysql 829TABLE_NAME column_stats 830TABLE_TYPE BASE TABLE 831ENGINE MYISAM_OR_MARIA 832VERSION 10 833ROW_FORMAT DYNAMIC_OR_PAGE 834TABLE_ROWS #TBLR# 835AVG_ROW_LENGTH #ARL# 836DATA_LENGTH #DL# 837MAX_DATA_LENGTH #MDL# 838INDEX_LENGTH #IL# 839DATA_FREE #DF# 840AUTO_INCREMENT NULL 841CREATE_TIME #CRT# 842UPDATE_TIME #UT# 843CHECK_TIME #CT# 844TABLE_COLLATION utf8_bin 845CHECKSUM NULL 846CREATE_OPTIONS #CO# 847TABLE_COMMENT #TC# 848MAX_INDEX_LENGTH #MIL# 849TEMPORARY N 850user_comment Statistics on Columns 851Separator ----------------------------------------------------- 852TABLE_CATALOG def 853TABLE_SCHEMA mysql 854TABLE_NAME db 855TABLE_TYPE BASE TABLE 856ENGINE MYISAM_OR_MARIA 857VERSION 10 858ROW_FORMAT Fixed 859TABLE_ROWS #TBLR# 860AVG_ROW_LENGTH #ARL# 861DATA_LENGTH #DL# 862MAX_DATA_LENGTH #MDL# 863INDEX_LENGTH #IL# 864DATA_FREE #DF# 865AUTO_INCREMENT NULL 866CREATE_TIME #CRT# 867UPDATE_TIME #UT# 868CHECK_TIME #CT# 869TABLE_COLLATION utf8_bin 870CHECKSUM NULL 871CREATE_OPTIONS #CO# 872TABLE_COMMENT #TC# 873MAX_INDEX_LENGTH #MIL# 874TEMPORARY N 875user_comment Database privileges 876Separator ----------------------------------------------------- 877TABLE_CATALOG def 878TABLE_SCHEMA mysql 879TABLE_NAME event 880TABLE_TYPE BASE TABLE 881ENGINE MYISAM_OR_MARIA 882VERSION 10 883ROW_FORMAT DYNAMIC_OR_PAGE 884TABLE_ROWS #TBLR# 885AVG_ROW_LENGTH #ARL# 886DATA_LENGTH #DL# 887MAX_DATA_LENGTH #MDL# 888INDEX_LENGTH #IL# 889DATA_FREE #DF# 890AUTO_INCREMENT NULL 891CREATE_TIME #CRT# 892UPDATE_TIME #UT# 893CHECK_TIME #CT# 894TABLE_COLLATION utf8_general_ci 895CHECKSUM NULL 896CREATE_OPTIONS #CO# 897TABLE_COMMENT #TC# 898MAX_INDEX_LENGTH #MIL# 899TEMPORARY N 900user_comment Events 901Separator ----------------------------------------------------- 902TABLE_CATALOG def 903TABLE_SCHEMA mysql 904TABLE_NAME func 905TABLE_TYPE BASE TABLE 906ENGINE MYISAM_OR_MARIA 907VERSION 10 908ROW_FORMAT Fixed 909TABLE_ROWS #TBLR# 910AVG_ROW_LENGTH #ARL# 911DATA_LENGTH #DL# 912MAX_DATA_LENGTH #MDL# 913INDEX_LENGTH #IL# 914DATA_FREE #DF# 915AUTO_INCREMENT NULL 916CREATE_TIME #CRT# 917UPDATE_TIME #UT# 918CHECK_TIME #CT# 919TABLE_COLLATION utf8_bin 920CHECKSUM NULL 921CREATE_OPTIONS #CO# 922TABLE_COMMENT #TC# 923MAX_INDEX_LENGTH #MIL# 924TEMPORARY N 925user_comment User defined functions 926Separator ----------------------------------------------------- 927TABLE_CATALOG def 928TABLE_SCHEMA mysql 929TABLE_NAME general_log 930TABLE_TYPE BASE TABLE 931ENGINE CSV 932VERSION 10 933ROW_FORMAT DYNAMIC_OR_PAGE 934TABLE_ROWS #TBLR# 935AVG_ROW_LENGTH #ARL# 936DATA_LENGTH #DL# 937MAX_DATA_LENGTH #MDL# 938INDEX_LENGTH #IL# 939DATA_FREE #DF# 940AUTO_INCREMENT NULL 941CREATE_TIME #CRT# 942UPDATE_TIME #UT# 943CHECK_TIME #CT# 944TABLE_COLLATION utf8_general_ci 945CHECKSUM NULL 946CREATE_OPTIONS #CO# 947TABLE_COMMENT #TC# 948MAX_INDEX_LENGTH #MIL# 949TEMPORARY N 950user_comment General log 951Separator ----------------------------------------------------- 952TABLE_CATALOG def 953TABLE_SCHEMA mysql 954TABLE_NAME gtid_slave_pos 955TABLE_TYPE BASE TABLE 956ENGINE MYISAM_OR_MARIA 957VERSION 10 958ROW_FORMAT Fixed 959TABLE_ROWS #TBLR# 960AVG_ROW_LENGTH #ARL# 961DATA_LENGTH #DL# 962MAX_DATA_LENGTH #MDL# 963INDEX_LENGTH #IL# 964DATA_FREE #DF# 965AUTO_INCREMENT NULL 966CREATE_TIME #CRT# 967UPDATE_TIME #UT# 968CHECK_TIME #CT# 969TABLE_COLLATION latin1_swedish_ci 970CHECKSUM NULL 971CREATE_OPTIONS #CO# 972TABLE_COMMENT #TC# 973MAX_INDEX_LENGTH #MIL# 974TEMPORARY N 975user_comment Replication slave GTID position 976Separator ----------------------------------------------------- 977TABLE_CATALOG def 978TABLE_SCHEMA mysql 979TABLE_NAME help_category 980TABLE_TYPE BASE TABLE 981ENGINE MYISAM_OR_MARIA 982VERSION 10 983ROW_FORMAT DYNAMIC_OR_PAGE 984TABLE_ROWS #TBLR# 985AVG_ROW_LENGTH #ARL# 986DATA_LENGTH #DL# 987MAX_DATA_LENGTH #MDL# 988INDEX_LENGTH #IL# 989DATA_FREE #DF# 990AUTO_INCREMENT NULL 991CREATE_TIME #CRT# 992UPDATE_TIME #UT# 993CHECK_TIME #CT# 994TABLE_COLLATION utf8_general_ci 995CHECKSUM NULL 996CREATE_OPTIONS #CO# 997TABLE_COMMENT #TC# 998MAX_INDEX_LENGTH #MIL# 999TEMPORARY N 1000user_comment help categories 1001Separator ----------------------------------------------------- 1002TABLE_CATALOG def 1003TABLE_SCHEMA mysql 1004TABLE_NAME help_keyword 1005TABLE_TYPE BASE TABLE 1006ENGINE MYISAM_OR_MARIA 1007VERSION 10 1008ROW_FORMAT Fixed 1009TABLE_ROWS #TBLR# 1010AVG_ROW_LENGTH #ARL# 1011DATA_LENGTH #DL# 1012MAX_DATA_LENGTH #MDL# 1013INDEX_LENGTH #IL# 1014DATA_FREE #DF# 1015AUTO_INCREMENT NULL 1016CREATE_TIME #CRT# 1017UPDATE_TIME #UT# 1018CHECK_TIME #CT# 1019TABLE_COLLATION utf8_general_ci 1020CHECKSUM NULL 1021CREATE_OPTIONS #CO# 1022TABLE_COMMENT #TC# 1023MAX_INDEX_LENGTH #MIL# 1024TEMPORARY N 1025user_comment help keywords 1026Separator ----------------------------------------------------- 1027TABLE_CATALOG def 1028TABLE_SCHEMA mysql 1029TABLE_NAME help_relation 1030TABLE_TYPE BASE TABLE 1031ENGINE MYISAM_OR_MARIA 1032VERSION 10 1033ROW_FORMAT Fixed 1034TABLE_ROWS #TBLR# 1035AVG_ROW_LENGTH #ARL# 1036DATA_LENGTH #DL# 1037MAX_DATA_LENGTH #MDL# 1038INDEX_LENGTH #IL# 1039DATA_FREE #DF# 1040AUTO_INCREMENT NULL 1041CREATE_TIME #CRT# 1042UPDATE_TIME #UT# 1043CHECK_TIME #CT# 1044TABLE_COLLATION utf8_general_ci 1045CHECKSUM NULL 1046CREATE_OPTIONS #CO# 1047TABLE_COMMENT #TC# 1048MAX_INDEX_LENGTH #MIL# 1049TEMPORARY N 1050user_comment keyword-topic relation 1051Separator ----------------------------------------------------- 1052TABLE_CATALOG def 1053TABLE_SCHEMA mysql 1054TABLE_NAME help_topic 1055TABLE_TYPE BASE TABLE 1056ENGINE MYISAM_OR_MARIA 1057VERSION 10 1058ROW_FORMAT DYNAMIC_OR_PAGE 1059TABLE_ROWS #TBLR# 1060AVG_ROW_LENGTH #ARL# 1061DATA_LENGTH #DL# 1062MAX_DATA_LENGTH #MDL# 1063INDEX_LENGTH #IL# 1064DATA_FREE #DF# 1065AUTO_INCREMENT NULL 1066CREATE_TIME #CRT# 1067UPDATE_TIME #UT# 1068CHECK_TIME #CT# 1069TABLE_COLLATION utf8_general_ci 1070CHECKSUM NULL 1071CREATE_OPTIONS #CO# 1072TABLE_COMMENT #TC# 1073MAX_INDEX_LENGTH #MIL# 1074TEMPORARY N 1075user_comment help topics 1076Separator ----------------------------------------------------- 1077TABLE_CATALOG def 1078TABLE_SCHEMA mysql 1079TABLE_NAME host 1080TABLE_TYPE BASE TABLE 1081ENGINE MYISAM_OR_MARIA 1082VERSION 10 1083ROW_FORMAT Fixed 1084TABLE_ROWS #TBLR# 1085AVG_ROW_LENGTH #ARL# 1086DATA_LENGTH #DL# 1087MAX_DATA_LENGTH #MDL# 1088INDEX_LENGTH #IL# 1089DATA_FREE #DF# 1090AUTO_INCREMENT NULL 1091CREATE_TIME #CRT# 1092UPDATE_TIME #UT# 1093CHECK_TIME #CT# 1094TABLE_COLLATION utf8_bin 1095CHECKSUM NULL 1096CREATE_OPTIONS #CO# 1097TABLE_COMMENT #TC# 1098MAX_INDEX_LENGTH #MIL# 1099TEMPORARY N 1100user_comment Host privileges; Merged with database privileges 1101Separator ----------------------------------------------------- 1102TABLE_CATALOG def 1103TABLE_SCHEMA mysql 1104TABLE_NAME index_stats 1105TABLE_TYPE BASE TABLE 1106ENGINE MYISAM_OR_MARIA 1107VERSION 10 1108ROW_FORMAT DYNAMIC_OR_PAGE 1109TABLE_ROWS #TBLR# 1110AVG_ROW_LENGTH #ARL# 1111DATA_LENGTH #DL# 1112MAX_DATA_LENGTH #MDL# 1113INDEX_LENGTH #IL# 1114DATA_FREE #DF# 1115AUTO_INCREMENT NULL 1116CREATE_TIME #CRT# 1117UPDATE_TIME #UT# 1118CHECK_TIME #CT# 1119TABLE_COLLATION utf8_bin 1120CHECKSUM NULL 1121CREATE_OPTIONS #CO# 1122TABLE_COMMENT #TC# 1123MAX_INDEX_LENGTH #MIL# 1124TEMPORARY N 1125user_comment Statistics on Indexes 1126Separator ----------------------------------------------------- 1127TABLE_CATALOG def 1128TABLE_SCHEMA mysql 1129TABLE_NAME innodb_index_stats 1130TABLE_TYPE BASE TABLE 1131ENGINE InnoDB 1132VERSION 10 1133ROW_FORMAT DYNAMIC_OR_PAGE 1134TABLE_ROWS #TBLR# 1135AVG_ROW_LENGTH #ARL# 1136DATA_LENGTH #DL# 1137MAX_DATA_LENGTH #MDL# 1138INDEX_LENGTH #IL# 1139DATA_FREE #DF# 1140AUTO_INCREMENT NULL 1141CREATE_TIME #CRT# 1142UPDATE_TIME #UT# 1143CHECK_TIME #CT# 1144TABLE_COLLATION utf8_bin 1145CHECKSUM NULL 1146CREATE_OPTIONS #CO# 1147TABLE_COMMENT #TC# 1148MAX_INDEX_LENGTH #MIL# 1149TEMPORARY N 1150user_comment 1151Separator ----------------------------------------------------- 1152TABLE_CATALOG def 1153TABLE_SCHEMA mysql 1154TABLE_NAME innodb_table_stats 1155TABLE_TYPE BASE TABLE 1156ENGINE InnoDB 1157VERSION 10 1158ROW_FORMAT DYNAMIC_OR_PAGE 1159TABLE_ROWS #TBLR# 1160AVG_ROW_LENGTH #ARL# 1161DATA_LENGTH #DL# 1162MAX_DATA_LENGTH #MDL# 1163INDEX_LENGTH #IL# 1164DATA_FREE #DF# 1165AUTO_INCREMENT NULL 1166CREATE_TIME #CRT# 1167UPDATE_TIME #UT# 1168CHECK_TIME #CT# 1169TABLE_COLLATION utf8_bin 1170CHECKSUM NULL 1171CREATE_OPTIONS #CO# 1172TABLE_COMMENT #TC# 1173MAX_INDEX_LENGTH #MIL# 1174TEMPORARY N 1175user_comment 1176Separator ----------------------------------------------------- 1177TABLE_CATALOG def 1178TABLE_SCHEMA mysql 1179TABLE_NAME plugin 1180TABLE_TYPE BASE TABLE 1181ENGINE MYISAM_OR_MARIA 1182VERSION 10 1183ROW_FORMAT DYNAMIC_OR_PAGE 1184TABLE_ROWS #TBLR# 1185AVG_ROW_LENGTH #ARL# 1186DATA_LENGTH #DL# 1187MAX_DATA_LENGTH #MDL# 1188INDEX_LENGTH #IL# 1189DATA_FREE #DF# 1190AUTO_INCREMENT NULL 1191CREATE_TIME #CRT# 1192UPDATE_TIME #UT# 1193CHECK_TIME #CT# 1194TABLE_COLLATION utf8_general_ci 1195CHECKSUM NULL 1196CREATE_OPTIONS #CO# 1197TABLE_COMMENT #TC# 1198MAX_INDEX_LENGTH #MIL# 1199TEMPORARY N 1200user_comment MySQL plugins 1201Separator ----------------------------------------------------- 1202TABLE_CATALOG def 1203TABLE_SCHEMA mysql 1204TABLE_NAME proc 1205TABLE_TYPE BASE TABLE 1206ENGINE MYISAM_OR_MARIA 1207VERSION 10 1208ROW_FORMAT DYNAMIC_OR_PAGE 1209TABLE_ROWS #TBLR# 1210AVG_ROW_LENGTH #ARL# 1211DATA_LENGTH #DL# 1212MAX_DATA_LENGTH #MDL# 1213INDEX_LENGTH #IL# 1214DATA_FREE #DF# 1215AUTO_INCREMENT NULL 1216CREATE_TIME #CRT# 1217UPDATE_TIME #UT# 1218CHECK_TIME #CT# 1219TABLE_COLLATION utf8_general_ci 1220CHECKSUM NULL 1221CREATE_OPTIONS #CO# 1222TABLE_COMMENT #TC# 1223MAX_INDEX_LENGTH #MIL# 1224TEMPORARY N 1225user_comment Stored Procedures 1226Separator ----------------------------------------------------- 1227TABLE_CATALOG def 1228TABLE_SCHEMA mysql 1229TABLE_NAME procs_priv 1230TABLE_TYPE BASE TABLE 1231ENGINE MYISAM_OR_MARIA 1232VERSION 10 1233ROW_FORMAT Fixed 1234TABLE_ROWS #TBLR# 1235AVG_ROW_LENGTH #ARL# 1236DATA_LENGTH #DL# 1237MAX_DATA_LENGTH #MDL# 1238INDEX_LENGTH #IL# 1239DATA_FREE #DF# 1240AUTO_INCREMENT NULL 1241CREATE_TIME #CRT# 1242UPDATE_TIME #UT# 1243CHECK_TIME #CT# 1244TABLE_COLLATION utf8_bin 1245CHECKSUM NULL 1246CREATE_OPTIONS #CO# 1247TABLE_COMMENT #TC# 1248MAX_INDEX_LENGTH #MIL# 1249TEMPORARY N 1250user_comment Procedure privileges 1251Separator ----------------------------------------------------- 1252TABLE_CATALOG def 1253TABLE_SCHEMA mysql 1254TABLE_NAME proxies_priv 1255TABLE_TYPE BASE TABLE 1256ENGINE MYISAM_OR_MARIA 1257VERSION 10 1258ROW_FORMAT Fixed 1259TABLE_ROWS #TBLR# 1260AVG_ROW_LENGTH #ARL# 1261DATA_LENGTH #DL# 1262MAX_DATA_LENGTH #MDL# 1263INDEX_LENGTH #IL# 1264DATA_FREE #DF# 1265AUTO_INCREMENT NULL 1266CREATE_TIME #CRT# 1267UPDATE_TIME #UT# 1268CHECK_TIME #CT# 1269TABLE_COLLATION utf8_bin 1270CHECKSUM NULL 1271CREATE_OPTIONS #CO# 1272TABLE_COMMENT #TC# 1273MAX_INDEX_LENGTH #MIL# 1274TEMPORARY N 1275user_comment User proxy privileges 1276Separator ----------------------------------------------------- 1277TABLE_CATALOG def 1278TABLE_SCHEMA mysql 1279TABLE_NAME roles_mapping 1280TABLE_TYPE BASE TABLE 1281ENGINE MYISAM_OR_MARIA 1282VERSION 10 1283ROW_FORMAT Fixed 1284TABLE_ROWS #TBLR# 1285AVG_ROW_LENGTH #ARL# 1286DATA_LENGTH #DL# 1287MAX_DATA_LENGTH #MDL# 1288INDEX_LENGTH #IL# 1289DATA_FREE #DF# 1290AUTO_INCREMENT NULL 1291CREATE_TIME #CRT# 1292UPDATE_TIME #UT# 1293CHECK_TIME #CT# 1294TABLE_COLLATION utf8_bin 1295CHECKSUM NULL 1296CREATE_OPTIONS #CO# 1297TABLE_COMMENT #TC# 1298MAX_INDEX_LENGTH #MIL# 1299TEMPORARY N 1300user_comment Granted roles 1301Separator ----------------------------------------------------- 1302TABLE_CATALOG def 1303TABLE_SCHEMA mysql 1304TABLE_NAME servers 1305TABLE_TYPE BASE TABLE 1306ENGINE MYISAM_OR_MARIA 1307VERSION 10 1308ROW_FORMAT DYNAMIC_OR_PAGE 1309TABLE_ROWS #TBLR# 1310AVG_ROW_LENGTH #ARL# 1311DATA_LENGTH #DL# 1312MAX_DATA_LENGTH #MDL# 1313INDEX_LENGTH #IL# 1314DATA_FREE #DF# 1315AUTO_INCREMENT NULL 1316CREATE_TIME #CRT# 1317UPDATE_TIME #UT# 1318CHECK_TIME #CT# 1319TABLE_COLLATION utf8_general_ci 1320CHECKSUM NULL 1321CREATE_OPTIONS #CO# 1322TABLE_COMMENT #TC# 1323MAX_INDEX_LENGTH #MIL# 1324TEMPORARY N 1325user_comment MySQL Foreign Servers table 1326Separator ----------------------------------------------------- 1327TABLE_CATALOG def 1328TABLE_SCHEMA mysql 1329TABLE_NAME slow_log 1330TABLE_TYPE BASE TABLE 1331ENGINE CSV 1332VERSION 10 1333ROW_FORMAT DYNAMIC_OR_PAGE 1334TABLE_ROWS #TBLR# 1335AVG_ROW_LENGTH #ARL# 1336DATA_LENGTH #DL# 1337MAX_DATA_LENGTH #MDL# 1338INDEX_LENGTH #IL# 1339DATA_FREE #DF# 1340AUTO_INCREMENT NULL 1341CREATE_TIME #CRT# 1342UPDATE_TIME #UT# 1343CHECK_TIME #CT# 1344TABLE_COLLATION utf8_general_ci 1345CHECKSUM NULL 1346CREATE_OPTIONS #CO# 1347TABLE_COMMENT #TC# 1348MAX_INDEX_LENGTH #MIL# 1349TEMPORARY N 1350user_comment Slow log 1351Separator ----------------------------------------------------- 1352TABLE_CATALOG def 1353TABLE_SCHEMA mysql 1354TABLE_NAME tables_priv 1355TABLE_TYPE BASE TABLE 1356ENGINE MYISAM_OR_MARIA 1357VERSION 10 1358ROW_FORMAT Fixed 1359TABLE_ROWS #TBLR# 1360AVG_ROW_LENGTH #ARL# 1361DATA_LENGTH #DL# 1362MAX_DATA_LENGTH #MDL# 1363INDEX_LENGTH #IL# 1364DATA_FREE #DF# 1365AUTO_INCREMENT NULL 1366CREATE_TIME #CRT# 1367UPDATE_TIME #UT# 1368CHECK_TIME #CT# 1369TABLE_COLLATION utf8_bin 1370CHECKSUM NULL 1371CREATE_OPTIONS #CO# 1372TABLE_COMMENT #TC# 1373MAX_INDEX_LENGTH #MIL# 1374TEMPORARY N 1375user_comment Table privileges 1376Separator ----------------------------------------------------- 1377TABLE_CATALOG def 1378TABLE_SCHEMA mysql 1379TABLE_NAME table_stats 1380TABLE_TYPE BASE TABLE 1381ENGINE MYISAM_OR_MARIA 1382VERSION 10 1383ROW_FORMAT DYNAMIC_OR_PAGE 1384TABLE_ROWS #TBLR# 1385AVG_ROW_LENGTH #ARL# 1386DATA_LENGTH #DL# 1387MAX_DATA_LENGTH #MDL# 1388INDEX_LENGTH #IL# 1389DATA_FREE #DF# 1390AUTO_INCREMENT NULL 1391CREATE_TIME #CRT# 1392UPDATE_TIME #UT# 1393CHECK_TIME #CT# 1394TABLE_COLLATION utf8_bin 1395CHECKSUM NULL 1396CREATE_OPTIONS #CO# 1397TABLE_COMMENT #TC# 1398MAX_INDEX_LENGTH #MIL# 1399TEMPORARY N 1400user_comment Statistics on Tables 1401Separator ----------------------------------------------------- 1402TABLE_CATALOG def 1403TABLE_SCHEMA mysql 1404TABLE_NAME time_zone 1405TABLE_TYPE BASE TABLE 1406ENGINE MYISAM_OR_MARIA 1407VERSION 10 1408ROW_FORMAT Fixed 1409TABLE_ROWS #TBLR# 1410AVG_ROW_LENGTH #ARL# 1411DATA_LENGTH #DL# 1412MAX_DATA_LENGTH #MDL# 1413INDEX_LENGTH #IL# 1414DATA_FREE #DF# 1415AUTO_INCREMENT 6 1416CREATE_TIME #CRT# 1417UPDATE_TIME #UT# 1418CHECK_TIME #CT# 1419TABLE_COLLATION utf8_general_ci 1420CHECKSUM NULL 1421CREATE_OPTIONS #CO# 1422TABLE_COMMENT #TC# 1423MAX_INDEX_LENGTH #MIL# 1424TEMPORARY N 1425user_comment Time zones 1426Separator ----------------------------------------------------- 1427TABLE_CATALOG def 1428TABLE_SCHEMA mysql 1429TABLE_NAME time_zone_leap_second 1430TABLE_TYPE BASE TABLE 1431ENGINE MYISAM_OR_MARIA 1432VERSION 10 1433ROW_FORMAT Fixed 1434TABLE_ROWS #TBLR# 1435AVG_ROW_LENGTH #ARL# 1436DATA_LENGTH #DL# 1437MAX_DATA_LENGTH #MDL# 1438INDEX_LENGTH #IL# 1439DATA_FREE #DF# 1440AUTO_INCREMENT NULL 1441CREATE_TIME #CRT# 1442UPDATE_TIME #UT# 1443CHECK_TIME #CT# 1444TABLE_COLLATION utf8_general_ci 1445CHECKSUM NULL 1446CREATE_OPTIONS #CO# 1447TABLE_COMMENT #TC# 1448MAX_INDEX_LENGTH #MIL# 1449TEMPORARY N 1450user_comment Leap seconds information for time zones 1451Separator ----------------------------------------------------- 1452TABLE_CATALOG def 1453TABLE_SCHEMA mysql 1454TABLE_NAME time_zone_name 1455TABLE_TYPE BASE TABLE 1456ENGINE MYISAM_OR_MARIA 1457VERSION 10 1458ROW_FORMAT Fixed 1459TABLE_ROWS #TBLR# 1460AVG_ROW_LENGTH #ARL# 1461DATA_LENGTH #DL# 1462MAX_DATA_LENGTH #MDL# 1463INDEX_LENGTH #IL# 1464DATA_FREE #DF# 1465AUTO_INCREMENT NULL 1466CREATE_TIME #CRT# 1467UPDATE_TIME #UT# 1468CHECK_TIME #CT# 1469TABLE_COLLATION utf8_general_ci 1470CHECKSUM NULL 1471CREATE_OPTIONS #CO# 1472TABLE_COMMENT #TC# 1473MAX_INDEX_LENGTH #MIL# 1474TEMPORARY N 1475user_comment Time zone names 1476Separator ----------------------------------------------------- 1477TABLE_CATALOG def 1478TABLE_SCHEMA mysql 1479TABLE_NAME time_zone_transition 1480TABLE_TYPE BASE TABLE 1481ENGINE MYISAM_OR_MARIA 1482VERSION 10 1483ROW_FORMAT Fixed 1484TABLE_ROWS #TBLR# 1485AVG_ROW_LENGTH #ARL# 1486DATA_LENGTH #DL# 1487MAX_DATA_LENGTH #MDL# 1488INDEX_LENGTH #IL# 1489DATA_FREE #DF# 1490AUTO_INCREMENT NULL 1491CREATE_TIME #CRT# 1492UPDATE_TIME #UT# 1493CHECK_TIME #CT# 1494TABLE_COLLATION utf8_general_ci 1495CHECKSUM NULL 1496CREATE_OPTIONS #CO# 1497TABLE_COMMENT #TC# 1498MAX_INDEX_LENGTH #MIL# 1499TEMPORARY N 1500user_comment Time zone transitions 1501Separator ----------------------------------------------------- 1502TABLE_CATALOG def 1503TABLE_SCHEMA mysql 1504TABLE_NAME time_zone_transition_type 1505TABLE_TYPE BASE TABLE 1506ENGINE MYISAM_OR_MARIA 1507VERSION 10 1508ROW_FORMAT Fixed 1509TABLE_ROWS #TBLR# 1510AVG_ROW_LENGTH #ARL# 1511DATA_LENGTH #DL# 1512MAX_DATA_LENGTH #MDL# 1513INDEX_LENGTH #IL# 1514DATA_FREE #DF# 1515AUTO_INCREMENT NULL 1516CREATE_TIME #CRT# 1517UPDATE_TIME #UT# 1518CHECK_TIME #CT# 1519TABLE_COLLATION utf8_general_ci 1520CHECKSUM NULL 1521CREATE_OPTIONS #CO# 1522TABLE_COMMENT #TC# 1523MAX_INDEX_LENGTH #MIL# 1524TEMPORARY N 1525user_comment Time zone transition types 1526Separator ----------------------------------------------------- 1527TABLE_CATALOG def 1528TABLE_SCHEMA mysql 1529TABLE_NAME transaction_registry 1530TABLE_TYPE BASE TABLE 1531ENGINE InnoDB 1532VERSION 10 1533ROW_FORMAT DYNAMIC_OR_PAGE 1534TABLE_ROWS #TBLR# 1535AVG_ROW_LENGTH #ARL# 1536DATA_LENGTH #DL# 1537MAX_DATA_LENGTH #MDL# 1538INDEX_LENGTH #IL# 1539DATA_FREE #DF# 1540AUTO_INCREMENT NULL 1541CREATE_TIME #CRT# 1542UPDATE_TIME #UT# 1543CHECK_TIME #CT# 1544TABLE_COLLATION utf8_bin 1545CHECKSUM NULL 1546CREATE_OPTIONS #CO# 1547TABLE_COMMENT #TC# 1548MAX_INDEX_LENGTH #MIL# 1549TEMPORARY N 1550user_comment 1551Separator ----------------------------------------------------- 1552TABLE_CATALOG def 1553TABLE_SCHEMA mysql 1554TABLE_NAME user 1555TABLE_TYPE BASE TABLE 1556ENGINE MYISAM_OR_MARIA 1557VERSION 10 1558ROW_FORMAT DYNAMIC_OR_PAGE 1559TABLE_ROWS #TBLR# 1560AVG_ROW_LENGTH #ARL# 1561DATA_LENGTH #DL# 1562MAX_DATA_LENGTH #MDL# 1563INDEX_LENGTH #IL# 1564DATA_FREE #DF# 1565AUTO_INCREMENT NULL 1566CREATE_TIME #CRT# 1567UPDATE_TIME #UT# 1568CHECK_TIME #CT# 1569TABLE_COLLATION utf8_bin 1570CHECKSUM NULL 1571CREATE_OPTIONS #CO# 1572TABLE_COMMENT #TC# 1573MAX_INDEX_LENGTH #MIL# 1574TEMPORARY N 1575user_comment Users and global privileges 1576Separator ----------------------------------------------------- 1577connection default; 1578disconnect testuser1; 1579DROP USER testuser1@localhost; 1580DROP DATABASE test1; 1581