SPECIFIC_NAME
varchar(64)
utf8mb3_general_ci
LIKE LIKE %...% NOT LIKE = != REGEXP REGEXP ^...$ NOT REGEXP = '' != '' IN (...) NOT IN (...) BETWEEN NOT BETWEEN IS NULL IS NOT NULL
ROUTINE_CATALOG
varchar(64)
utf8mb3_bin
LIKE LIKE %...% NOT LIKE = != REGEXP REGEXP ^...$ NOT REGEXP = '' != '' IN (...) NOT IN (...) BETWEEN NOT BETWEEN IS NULL IS NOT NULL
ROUTINE_SCHEMA
varchar(64)
utf8mb3_bin
LIKE LIKE %...% NOT LIKE = != REGEXP REGEXP ^...$ NOT REGEXP = '' != '' IN (...) NOT IN (...) BETWEEN NOT BETWEEN IS NULL IS NOT NULL
def - mysql def - information_schema def - performance_schema def - sys def - phpmyadmin def - fiscco def - nome_do_banco fiscco - def information_schema - def mysql - def nome_do_banco - def performance_schema - def phpmyadmin - def sys - def
ROUTINE_NAME
varchar(64)
utf8mb3_general_ci
LIKE LIKE %...% NOT LIKE = != REGEXP REGEXP ^...$ NOT REGEXP = '' != '' IN (...) NOT IN (...) BETWEEN NOT BETWEEN IS NULL IS NOT NULL
ROUTINE_TYPE
enum('FUNCTION', 'PROCEDURE')
utf8mb3_bin
= != IS NULL IS NOT NULL
FUNCTION
PROCEDURE
DATA_TYPE
longtext
utf8mb3_bin
LIKE LIKE %...% NOT LIKE = != REGEXP REGEXP ^...$ NOT REGEXP = '' != '' IN (...) NOT IN (...) BETWEEN NOT BETWEEN IS NULL IS NOT NULL
CHARACTER_MAXIMUM_LENGTH
bigint
= > >= < <= != LIKE LIKE %...% NOT LIKE IN (...) NOT IN (...) BETWEEN NOT BETWEEN IS NULL IS NOT NULL
CHARACTER_OCTET_LENGTH
bigint
= > >= < <= != LIKE LIKE %...% NOT LIKE IN (...) NOT IN (...) BETWEEN NOT BETWEEN IS NULL IS NOT NULL
NUMERIC_PRECISION
int
= > >= < <= != LIKE LIKE %...% NOT LIKE IN (...) NOT IN (...) BETWEEN NOT BETWEEN IS NULL IS NOT NULL
NUMERIC_SCALE
int
= > >= < <= != LIKE LIKE %...% NOT LIKE IN (...) NOT IN (...) BETWEEN NOT BETWEEN IS NULL IS NOT NULL
DATETIME_PRECISION
int
= > >= < <= != LIKE LIKE %...% NOT LIKE IN (...) NOT IN (...) BETWEEN NOT BETWEEN IS NULL IS NOT NULL
CHARACTER_SET_NAME
varchar(64)
utf8mb3_general_ci
LIKE 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 China National Standard GB18030 - gb18030 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 - utf8mb3 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 gb18030 - China National Standard GB18030 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 utf8mb3 - UTF-8 Unicode utf8mb4 - UTF-8 Unicode utf16 - UTF-16 Unicode utf16le - UTF-16LE Unicode utf32 - UTF-32 Unicode
COLLATION_NAME
varchar(64)
utf8mb3_general_ci
LIKE LIKE %...% NOT LIKE = != REGEXP REGEXP ^...$ NOT REGEXP = '' != '' IN (...) NOT IN (...) BETWEEN NOT BETWEEN IS NULL IS NOT NULL
DTD_IDENTIFIER
longtext
utf8mb3_bin
LIKE LIKE %...% NOT LIKE = != REGEXP REGEXP ^...$ NOT REGEXP = '' != '' IN (...) NOT IN (...) BETWEEN NOT BETWEEN IS NULL IS NOT NULL
ROUTINE_BODY
varchar(3)
utf8mb3_general_ci
LIKE LIKE %...% NOT LIKE = != REGEXP REGEXP ^...$ NOT REGEXP = '' != '' IN (...) NOT IN (...) BETWEEN NOT BETWEEN IS NULL IS NOT NULL
ROUTINE_DEFINITION
longtext
utf8mb3_bin
LIKE LIKE %...% NOT LIKE = != REGEXP REGEXP ^...$ NOT REGEXP = '' != '' IN (...) NOT IN (...) BETWEEN NOT BETWEEN IS NULL IS NOT NULL
EXTERNAL_NAME
binary(0)
LIKE LIKE %...% NOT LIKE = != REGEXP REGEXP ^...$ NOT REGEXP = '' != '' IN (...) NOT IN (...) BETWEEN NOT BETWEEN IS NULL IS NOT NULL
EXTERNAL_LANGUAGE
varchar(64)
utf8mb3_bin
LIKE LIKE %...% NOT LIKE = != REGEXP REGEXP ^...$ NOT REGEXP = '' != '' IN (...) NOT IN (...) BETWEEN NOT BETWEEN IS NULL IS NOT NULL
PARAMETER_STYLE
varchar(3)
utf8mb3_general_ci
LIKE LIKE %...% NOT LIKE = != REGEXP REGEXP ^...$ NOT REGEXP = '' != '' IN (...) NOT IN (...) BETWEEN NOT BETWEEN IS NULL IS NOT NULL
IS_DETERMINISTIC
varchar(3)
utf8mb3_general_ci
LIKE LIKE %...% NOT LIKE = != REGEXP REGEXP ^...$ NOT REGEXP = '' != '' IN (...) NOT IN (...) BETWEEN NOT BETWEEN IS NULL IS NOT NULL
SQL_DATA_ACCESS
enum('CONTAINS SQL', 'NO SQL', 'READS SQL DATA', 'MODIFIES SQL DATA')
utf8mb3_bin
= != IS NULL IS NOT NULL
CONTAINS SQL
NO SQL
READS SQL DATA
MODIFIES SQL DATA
SQL_PATH
binary(0)
LIKE LIKE %...% NOT LIKE = != REGEXP REGEXP ^...$ NOT REGEXP = '' != '' IN (...) NOT IN (...) BETWEEN NOT BETWEEN IS NULL IS NOT NULL
SECURITY_TYPE
enum('DEFAULT', 'INVOKER', 'DEFINER')
utf8mb3_bin
= != IS NULL IS NOT NULL
DEFAULT
INVOKER
DEFINER
CREATED
timestamp
= > >= < <= != LIKE LIKE %...% NOT LIKE IN (...) NOT IN (...) BETWEEN NOT BETWEEN IS NULL IS NOT NULL
LAST_ALTERED
timestamp
= > >= < <= != LIKE LIKE %...% NOT LIKE IN (...) NOT IN (...) BETWEEN NOT BETWEEN IS NULL IS NOT NULL
SQL_MODE
set('REAL_AS_FLOAT', 'PIPES_AS_CONCAT', 'ANSI_QUOTES', 'IGNORE_SPACE', 'NOT_USED', 'ONLY_FULL_GROUP_BY', 'NO_UNSIGNED_SUBTRACTION', 'NO_DIR_IN_CREATE', 'NOT_USED_9', 'NOT_USED_10', 'NOT_USED_11', 'NOT_USED_12', 'NOT_USED_13', 'NOT_USED_14', 'NOT_USED_15', 'NOT_USED_16', 'NOT_USED_17', 'NOT_USED_18', 'ANSI', 'NO_AUTO_VALUE_ON_ZERO', 'NO_BACKSLASH_ESCAPES', 'STRICT_TRANS_TABLES', 'STRICT_ALL_TABLES', 'NO_ZERO_IN_DATE', 'NO_ZERO_DATE', 'ALLOW_INVALID_DATES', 'ERROR_FOR_DIVISION_BY_ZERO', 'TRADITIONAL', 'NOT_USED_29', 'HIGH_NOT_PRECEDENCE', 'NO_ENGINE_SUBSTITUTION', 'PAD_CHAR_TO_FULL_LENGTH', 'TIME_TRUNCATE_FRACTIONAL')
utf8mb3_bin
LIKE LIKE %...% NOT LIKE = != REGEXP REGEXP ^...$ NOT REGEXP = '' != '' IN (...) NOT IN (...) BETWEEN NOT BETWEEN IS NULL IS NOT NULL
ROUTINE_COMMENT
text
utf8mb3_bin
LIKE LIKE %...% NOT LIKE = != REGEXP REGEXP ^...$ NOT REGEXP = '' != '' IN (...) NOT IN (...) BETWEEN NOT BETWEEN IS NULL IS NOT NULL
DEFINER
varchar(288)
utf8mb3_bin
LIKE LIKE %...% NOT LIKE = != REGEXP REGEXP ^...$ NOT REGEXP = '' != '' IN (...) NOT IN (...) BETWEEN NOT BETWEEN IS NULL IS NOT NULL
CHARACTER_SET_CLIENT
varchar(64)
utf8mb3_general_ci
LIKE 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 China National Standard GB18030 - gb18030 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 - utf8mb3 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 gb18030 - China National Standard GB18030 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 utf8mb3 - UTF-8 Unicode utf8mb4 - UTF-8 Unicode utf16 - UTF-16 Unicode utf16le - UTF-16LE Unicode utf32 - UTF-32 Unicode
COLLATION_CONNECTION
varchar(64)
utf8mb3_general_ci
LIKE LIKE %...% NOT LIKE = != REGEXP REGEXP ^...$ NOT REGEXP = '' != '' IN (...) NOT IN (...) BETWEEN NOT BETWEEN IS NULL IS NOT NULL
DATABASE_COLLATION
varchar(64)
utf8mb3_general_ci
LIKE LIKE %...% NOT LIKE = != REGEXP REGEXP ^...$ NOT REGEXP = '' != '' IN (...) NOT IN (...) BETWEEN NOT BETWEEN IS NULL IS NOT NULL
