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 - performance_schema def - information_schema def - mysql def - helixrp def - test def - altvserver def - phpmyadmin def - admin admin - def altvserver - def helixrp - def 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
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
execute_at
datetime
= > >= < <= != LIKE LIKE %...% NOT LIKE NOT LIKE %...% IN (...) NOT IN (...) BETWEEN NOT BETWEEN IS NULL IS NOT NULL
interval_value
int(11)
= > >= < <= != LIKE LIKE %...% NOT LIKE NOT LIKE %...% IN (...) NOT IN (...) BETWEEN NOT BETWEEN IS NULL IS NOT NULL
interval_field
enum('YEAR', 'QUARTER', 'MONTH', 'DAY', 'HOUR', 'MINUTE', 'WEEK', 'SECOND', 'MICROSECOND', 'YEAR_MONTH', 'DAY_HOUR', 'DAY_MINUTE', 'DAY_SECOND', 'HOUR_MINUTE', 'HOUR_SECOND', 'MINUTE_SECOND', 'DAY_MICROSECOND', 'HOUR_MICROSECOND', 'MINUTE_MICROSECOND', 'SECOND_MICROSECOND')
utf8_general_ci
= != IS NULL IS NOT NULL
YEAR
QUARTER
MONTH
DAY
HOUR
MINUTE
WEEK
SECOND
MICROSECOND
YEAR_MONTH
DAY_HOUR
DAY_MINUTE
DAY_SECOND
HOUR_MINUTE
HOUR_SECOND
MINUTE_SECOND
DAY_MICROSECOND
HOUR_MICROSECOND
MINUTE_MICROSECOND
SECOND_MICROSECOND
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
last_executed
datetime
= > >= < <= != LIKE LIKE %...% NOT LIKE NOT LIKE %...% IN (...) NOT IN (...) BETWEEN NOT BETWEEN IS NULL IS NOT NULL
starts
datetime
= > >= < <= != LIKE LIKE %...% NOT LIKE NOT LIKE %...% IN (...) NOT IN (...) BETWEEN NOT BETWEEN IS NULL IS NOT NULL
ends
datetime
= > >= < <= != LIKE LIKE %...% NOT LIKE NOT LIKE %...% IN (...) NOT IN (...) BETWEEN NOT BETWEEN IS NULL IS NOT NULL
status
enum('ENABLED', 'DISABLED', 'SLAVESIDE_DISABLED')
utf8_general_ci
= != IS NULL IS NOT NULL
ENABLED
DISABLED
SLAVESIDE_DISABLED
on_completion
enum('DROP', 'PRESERVE')
utf8_general_ci
= != IS NULL IS NOT NULL
DROP
PRESERVE
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
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
originator
int(10)
= > >= < <= != LIKE LIKE %...% NOT LIKE NOT LIKE %...% IN (...) NOT IN (...) BETWEEN NOT BETWEEN IS NULL IS NOT NULL
time_zone
char(64)
latin1_swedish_ci
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 - 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_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
