db
char(64)
utf8_bin
LIKE LIKE %...% NOT LIKE NOT LIKE %...% = != REGEXP REGEXP ^...$ NOT REGEXP = '' != '' IN (...) NOT IN (...) BETWEEN NOT BETWEEN IS NULL IS NOT NULL
def - mysql def - information_schema def - test def - phpmyadmin def - performance_schema information_schema - def mysql - def performance_schema - def phpmyadmin - def test - def
name
char(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
type
enum('FUNCTION', 'PROCEDURE', 'PACKAGE', 'PACKAGE BODY')
utf8_general_ci
= != IS NULL IS NOT NULL
FUNCTION
PROCEDURE
PACKAGE
PACKAGE BODY
specific_name
char(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
language
enum('SQL')
utf8_general_ci
= != IS NULL IS NOT NULL
SQL
sql_data_access
enum('CONTAINS_SQL', 'NO_SQL', 'READS_SQL_DATA', 'MODIFIES_SQL_DATA')
utf8_general_ci
= != IS NULL IS NOT NULL
CONTAINS_SQL
NO_SQL
READS_SQL_DATA
MODIFIES_SQL_DATA
is_deterministic
enum('YES', 'NO')
utf8_general_ci
= != IS NULL IS NOT NULL
YES
NO
security_type
enum('INVOKER', 'DEFINER')
utf8_general_ci
= != IS NULL IS NOT NULL
INVOKER
DEFINER
param_list
blob
LIKE LIKE %...% NOT LIKE NOT LIKE %...% = != REGEXP REGEXP ^...$ NOT REGEXP = '' != '' IN (...) NOT IN (...) BETWEEN NOT BETWEEN IS NULL IS NOT NULL
returns
longblob
LIKE LIKE %...% NOT LIKE NOT LIKE %...% = != REGEXP REGEXP ^...$ NOT REGEXP = '' != '' IN (...) NOT IN (...) BETWEEN NOT BETWEEN IS NULL IS NOT NULL
body
longblob
LIKE LIKE %...% NOT LIKE NOT LIKE %...% = != REGEXP REGEXP ^...$ NOT REGEXP = '' != '' IN (...) NOT IN (...) BETWEEN NOT BETWEEN IS NULL IS NOT NULL
definer
char(141)
utf8_bin
LIKE LIKE %...% NOT LIKE NOT LIKE %...% = != REGEXP REGEXP ^...$ NOT REGEXP = '' != '' IN (...) NOT IN (...) BETWEEN NOT BETWEEN IS NULL IS NOT NULL
created
timestamp
= > >= < <= != LIKE LIKE %...% NOT LIKE NOT LIKE %...% IN (...) NOT IN (...) BETWEEN NOT BETWEEN IS NULL IS NOT NULL
modified
timestamp
= > >= < <= != LIKE LIKE %...% NOT 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', 'IGNORE_BAD_TABLE_OPTIONS', 'ONLY_FULL_GROUP_BY', 'NO_UNSIGNED_SUBTRACTION', 'NO_DIR_IN_CREATE', 'POSTGRESQL', 'ORACLE', 'MSSQL', 'DB2', 'MAXDB', 'NO_KEY_OPTIONS', 'NO_TABLE_OPTIONS', 'NO_FIELD_OPTIONS', 'MYSQL323', 'MYSQL40', 'ANSI', 'NO_AUTO_VALUE_ON_ZERO', 'NO_BACKSLASH_ESCAPES', 'STRICT_TRANS_TABLES', 'STRICT_ALL_TABLES', 'NO_ZERO_IN_DATE', 'NO_ZERO_DATE', 'INVALID_DATES', 'ERROR_FOR_DIVISION_BY_ZERO', 'TRADITIONAL', 'NO_AUTO_CREATE_USER', 'HIGH_NOT_PRECEDENCE', 'NO_ENGINE_SUBSTITUTION', 'PAD_CHAR_TO_FULL_LENGTH', 'EMPTY_STRING_IS_NULL', 'SIMULTANEOUS_ASSIGNMENT', 'TIME_ROUND_FRACTIONAL')
utf8_general_ci
LIKE LIKE %...% NOT LIKE NOT LIKE %...% = != REGEXP REGEXP ^...$ NOT REGEXP = '' != '' IN (...) NOT IN (...) BETWEEN NOT BETWEEN IS NULL IS NOT NULL
comment
text
utf8_bin
LIKE LIKE %...% NOT LIKE NOT LIKE %...% = != REGEXP REGEXP ^...$ NOT REGEXP = '' != '' IN (...) NOT IN (...) BETWEEN NOT BETWEEN IS NULL IS NOT NULL
character_set_client
char(32)
utf8_bin
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 - utf8mb4 UTF-8 Unicode - utf8 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_connection
char(32)
utf8_bin
LIKE LIKE %...% NOT LIKE NOT LIKE %...% = != REGEXP REGEXP ^...$ NOT REGEXP = '' != '' IN (...) NOT IN (...) BETWEEN NOT BETWEEN IS NULL IS NOT NULL
db_collation
char(32)
utf8_bin
LIKE LIKE %...% NOT LIKE NOT LIKE %...% = != REGEXP REGEXP ^...$ NOT REGEXP = '' != '' IN (...) NOT IN (...) BETWEEN NOT BETWEEN IS NULL IS NOT NULL
body_utf8
longblob
LIKE LIKE %...% NOT LIKE NOT LIKE %...% = != REGEXP REGEXP ^...$ NOT REGEXP = '' != '' IN (...) NOT IN (...) BETWEEN NOT BETWEEN IS NULL IS NOT NULL
aggregate
enum('NONE', 'GROUP')
utf8_general_ci
= != IS NULL IS NOT NULL
NONE
GROUP
