TABLE_CATALOG
varchar(512)
utf8_general_ci
LIKE LIKE %...% NOT LIKE NOT LIKE %...% = != REGEXP REGEXP ^...$ NOT REGEXP = '' != '' IN (...) NOT IN (...) BETWEEN NOT BETWEEN IS NULL IS NOT NULL
TABLE_SCHEMA
varchar(64)
utf8_general_ci
LIKE LIKE %...% NOT LIKE NOT LIKE %...% = != REGEXP REGEXP ^...$ NOT REGEXP = '' != '' IN (...) NOT IN (...) BETWEEN NOT BETWEEN IS NULL IS NOT NULL
def - information_schema def - phpmyadmin def - test def - performance_schema def - mysql def - emp_recruit def - emp_nontech emp_nontech - def emp_recruit - def information_schema - def mysql - def performance_schema - def phpmyadmin - def test - def
TABLE_NAME
varchar(64)
utf8_general_ci
LIKE LIKE %...% NOT LIKE NOT LIKE %...% = != REGEXP REGEXP ^...$ NOT REGEXP = '' != '' IN (...) NOT IN (...) BETWEEN NOT BETWEEN IS NULL IS NOT NULL
COLUMN_NAME
varchar(64)
utf8_general_ci
LIKE LIKE %...% NOT LIKE NOT LIKE %...% = != REGEXP REGEXP ^...$ NOT REGEXP = '' != '' IN (...) NOT IN (...) BETWEEN NOT BETWEEN IS NULL IS NOT NULL
ORDINAL_POSITION
bigint(21)
= > >= < <= != LIKE LIKE %...% NOT LIKE NOT LIKE %...% IN (...) NOT IN (...) BETWEEN NOT BETWEEN IS NULL IS NOT NULL
COLUMN_DEFAULT
longtext
utf8_general_ci
LIKE LIKE %...% NOT LIKE NOT LIKE %...% = != REGEXP REGEXP ^...$ NOT REGEXP = '' != '' IN (...) NOT IN (...) BETWEEN NOT BETWEEN IS NULL IS NOT NULL
IS_NULLABLE
varchar(3)
utf8_general_ci
LIKE LIKE %...% NOT LIKE NOT LIKE %...% = != REGEXP REGEXP ^...$ NOT REGEXP = '' != '' IN (...) NOT IN (...) BETWEEN NOT BETWEEN IS NULL IS NOT NULL
DATA_TYPE
varchar(64)
utf8_general_ci
LIKE LIKE %...% NOT LIKE NOT LIKE %...% = != REGEXP REGEXP ^...$ NOT REGEXP = '' != '' IN (...) NOT IN (...) BETWEEN NOT BETWEEN IS NULL IS NOT NULL
CHARACTER_MAXIMUM_LENGTH
bigint(21)
= > >= < <= != LIKE LIKE %...% NOT LIKE NOT LIKE %...% IN (...) NOT IN (...) BETWEEN NOT BETWEEN IS NULL IS NOT NULL
CHARACTER_OCTET_LENGTH
bigint(21)
= > >= < <= != LIKE LIKE %...% NOT LIKE NOT LIKE %...% IN (...) NOT IN (...) BETWEEN NOT BETWEEN IS NULL IS NOT NULL
NUMERIC_PRECISION
bigint(21)
= > >= < <= != LIKE LIKE %...% NOT LIKE NOT LIKE %...% IN (...) NOT IN (...) BETWEEN NOT BETWEEN IS NULL IS NOT NULL
NUMERIC_SCALE
bigint(21)
= > >= < <= != LIKE LIKE %...% NOT LIKE NOT LIKE %...% IN (...) NOT IN (...) BETWEEN NOT BETWEEN IS NULL IS NOT NULL
DATETIME_PRECISION
bigint(21)
= > >= < <= != LIKE LIKE %...% NOT LIKE NOT LIKE %...% IN (...) NOT IN (...) BETWEEN NOT BETWEEN IS NULL IS NOT NULL
CHARACTER_SET_NAME
varchar(32)
utf8_general_ci
LIKE LIKE %...% NOT LIKE NOT LIKE %...% = != REGEXP REGEXP ^...$ NOT REGEXP = '' != '' IN (...) NOT IN (...) BETWEEN NOT BETWEEN IS NULL IS NOT NULL
7bit Swedish - swe7 ARMSCII-8 Armenian - armscii8 Big5 Traditional Chinese - big5 Binary pseudo charset - binary cp1252 West European - latin1 DEC West European - dec8 DOS Central European - cp852 DOS Kamenicky Czech-Slovak - keybcs2 DOS Russian - cp866 DOS West European - cp850 EUC-JP Japanese - ujis EUC-KR Korean - euckr GB2312 Simplified Chinese - gb2312 GBK Simplified Chinese - gbk GEOSTD8 Georgian - geostd8 HP West European - hp8 ISO 8859-2 Central European - latin2 ISO 8859-7 Greek - greek ISO 8859-8 Hebrew - hebrew ISO 8859-9 Turkish - latin5 ISO 8859-13 Baltic - latin7 KOI8-R Relcom Russian - koi8r KOI8-U Ukrainian - koi8u Mac Central European - macce Mac West European - macroman Shift-JIS Japanese - sjis SJIS for Windows Japanese - cp932 TIS620 Thai - tis620 UCS-2 Unicode - ucs2 UJIS for Windows Japanese - eucjpms US ASCII - ascii UTF-8 Unicode - utf8 UTF-8 Unicode - utf8mb4 UTF-16 Unicode - utf16 UTF-16LE Unicode - utf16le UTF-32 Unicode - utf32 Windows Arabic - cp1256 Windows Baltic - cp1257 Windows Central European - cp1250 Windows Cyrillic - cp1251 armscii8 - ARMSCII-8 Armenian ascii - US ASCII big5 - Big5 Traditional Chinese binary - Binary pseudo charset cp850 - DOS West European cp852 - DOS Central European cp866 - DOS Russian cp932 - SJIS for Windows Japanese cp1250 - Windows Central European cp1251 - Windows Cyrillic cp1256 - Windows Arabic cp1257 - Windows Baltic dec8 - DEC West European eucjpms - UJIS for Windows Japanese euckr - EUC-KR Korean gb2312 - GB2312 Simplified Chinese gbk - GBK Simplified Chinese geostd8 - GEOSTD8 Georgian greek - ISO 8859-7 Greek hebrew - ISO 8859-8 Hebrew hp8 - HP West European keybcs2 - DOS Kamenicky Czech-Slovak koi8r - KOI8-R Relcom Russian koi8u - KOI8-U Ukrainian latin1 - cp1252 West European latin2 - ISO 8859-2 Central European latin5 - ISO 8859-9 Turkish latin7 - ISO 8859-13 Baltic macce - Mac Central European macroman - Mac West European sjis - Shift-JIS Japanese swe7 - 7bit Swedish tis620 - TIS620 Thai ucs2 - UCS-2 Unicode ujis - EUC-JP Japanese utf8 - UTF-8 Unicode utf8mb4 - UTF-8 Unicode utf16 - UTF-16 Unicode utf16le - UTF-16LE Unicode utf32 - UTF-32 Unicode
COLLATION_NAME
varchar(32)
utf8_general_ci
LIKE LIKE %...% NOT LIKE NOT LIKE %...% = != REGEXP REGEXP ^...$ NOT REGEXP = '' != '' IN (...) NOT IN (...) BETWEEN NOT BETWEEN IS NULL IS NOT NULL
COLUMN_TYPE
longtext
utf8_general_ci
LIKE LIKE %...% NOT LIKE NOT LIKE %...% = != REGEXP REGEXP ^...$ NOT REGEXP = '' != '' IN (...) NOT IN (...) BETWEEN NOT BETWEEN IS NULL IS NOT NULL
COLUMN_KEY
varchar(3)
utf8_general_ci
LIKE LIKE %...% NOT LIKE NOT LIKE %...% = != REGEXP REGEXP ^...$ NOT REGEXP = '' != '' IN (...) NOT IN (...) BETWEEN NOT BETWEEN IS NULL IS NOT NULL
EXTRA
varchar(80)
utf8_general_ci
LIKE LIKE %...% NOT LIKE NOT LIKE %...% = != REGEXP REGEXP ^...$ NOT REGEXP = '' != '' IN (...) NOT IN (...) BETWEEN NOT BETWEEN IS NULL IS NOT NULL
PRIVILEGES
varchar(80)
utf8_general_ci
LIKE LIKE %...% NOT LIKE NOT LIKE %...% = != REGEXP REGEXP ^...$ NOT REGEXP = '' != '' IN (...) NOT IN (...) BETWEEN NOT BETWEEN IS NULL IS NOT NULL
COLUMN_COMMENT
varchar(1024)
utf8_general_ci
LIKE LIKE %...% NOT LIKE NOT LIKE %...% = != REGEXP REGEXP ^...$ NOT REGEXP = '' != '' IN (...) NOT IN (...) BETWEEN NOT BETWEEN IS NULL IS NOT NULL
IS_GENERATED
varchar(6)
utf8_general_ci
LIKE LIKE %...% NOT LIKE NOT LIKE %...% = != REGEXP REGEXP ^...$ NOT REGEXP = '' != '' IN (...) NOT IN (...) BETWEEN NOT BETWEEN IS NULL IS NOT NULL
GENERATION_EXPRESSION
longtext
utf8_general_ci
LIKE LIKE %...% NOT LIKE NOT LIKE %...% = != REGEXP REGEXP ^...$ NOT REGEXP = '' != '' IN (...) NOT IN (...) BETWEEN NOT BETWEEN IS NULL IS NOT NULL
