近期访问
`information_schema`.`SYSTEM_VARIABLES`
`information_schema`.`PARTITIONS`
`information_schema`.`INNODB_MUTEXES`
`information_schema`.`INNODB_SYS_TABLESPACES`
`information_schema`.`INNODB_LOCKS`
`information_schema`.`INNODB_FT_BEING_DELETED`
`information_schema`.`INNODB_TABLESPACES_SCRUBBING`
`information_schema`.`PARAMETERS`
`mysql`.`columns_priv`
`information_schema`.`CHARACTER_SETS`
表收藏夹
`abcschool333`.`expenses`
`abcschool333`.`permission_parent`
`abcschool333`.`multi_class_students`
`abcschool333`.`front_cms_media_gallery`
`abcschool333`.`disable_reason`
`abcschool333`.`front_cms_program_photos`
`abcschool333`.`send_notification`
`abcschool333`.`class_teacher`
`abcschool333`.`front_cms_menu_items`
`abcschool333`.`messages`
新建
cm9vdA==.YWJj
cm9vdA==.YWJj
0
abc
cm9vdA==.YWJjc2Nob29sMg==
cm9vdA==.YWJjc2Nob29sMg==
0
abcschool2
cm9vdA==.YWJjc2Nob29sMzM=
cm9vdA==.YWJjc2Nob29sMzM=
0
abcschool33
cm9vdA==.YWJjc2Nob29sMzMz
cm9vdA==.YWJjc2Nob29sMzMz
0
abcschool333
cm9vdA==.aW5mb3JtYXRpb25fc2NoZW1h
cm9vdA==.aW5mb3JtYXRpb25fc2NoZW1h
0
information_schema
cm9vdA==.bXlzcWw=
cm9vdA==.bXlzcWw=
0
mysql
cm9vdA==.cGVyZm9ybWFuY2Vfc2NoZW1h
cm9vdA==.cGVyZm9ybWFuY2Vfc2NoZW1h
0
performance_schema
cm9vdA==.cGhwbXlhZG1pbg==
cm9vdA==.cGhwbXlhZG1pbg==
0
phpmyadmin
cm9vdA==.c21hcnRzY2hvb2w=
cm9vdA==.c21hcnRzY2hvb2w=
0
smartschool
cm9vdA==.c21hcnRzY2hvb2wx
cm9vdA==.c21hcnRzY2hvb2wx
0
smartschool1
cm9vdA==.c21hcnRzY2hvb2wz
cm9vdA==.c21hcnRzY2hvb2wz
0
smartschool3
cm9vdA==.c21hcnRzY2hvb2wxMTE=
cm9vdA==.c21hcnRzY2hvb2wxMTE=
0
smartschool111
cm9vdA==.c21hcnRzY2hvb2wyMjI=
cm9vdA==.c21hcnRzY2hvb2wyMjI=
0
smartschool222
cm9vdA==.dGVzdA==
cm9vdA==.dGVzdA==
0
test
导航面板
导航树
服务器
数据库
表
导航面板
自定义导航面板。
以树状显示数据库导航面板
导航栏使用数据库选择器替代树形列表
与主面板链接
高亮当前数据库或表链接到主面板。
显示徽标
在导航面板中显示图示。
徽标链接地址
导航面板中图示指向的链接地址。
徽标链接目标
在主窗口(
main
)或新窗口(
new
)打开目标页面。
main
new
启用高亮
高亮鼠标指针所在位置的服务器。
第一层节点的最大项数
每页导航树所能显示的第一层的最大项数。
显示筛选框的最少项数
设置达到多少个项(表、视图、程序和事件)时将显示筛选框。
最近使用的表
最近使用的表的最大数量;设为 0 为禁用。
表收藏夹
收藏表的最大数量;设为 0 为禁用。
导航面板宽度
设置为0以折叠导航面板。
导航树
自定义导航树。
节点中最大项数
每页导航树所能显示的最大项数。
分组树中的项
将导航树中的项分组(根据上面 数据库与数据表 页面设置的分隔符分组)。
启用表导航条展开功能
是否允许在导航栏中展开导航树。
在导航树显示表
在导航树是否在数据库下显示数据表节点
在导航树显示视图
在导航树中是否在数据库下显示视图节点
在导航树显示函数
是否显示导航树中数据库下级功能
在导航树显示进程
是否在导航树中显示数据库进程
在导航树显示事件
在导航树中数据库下是否显示事件节点
展开单个数据库
是否自动在导航树中展开单个数据库。
服务器
服务器显示选项。
显示服务器选择
在导航面板顶部显示可选的服务器。
列表显示服务器
直接显示服务器列表而不使用下拉框。
数据库
数据库显示选项。
设置达到多少个数据库时将显示数据库筛选框
数据库树分隔符
将数据库分为不同层级的字符串。
表
表显示选项。
快速访问图标的目标
结构
SQL
搜索
插入
浏览
第二快速访问图标的目标页面
结构
SQL
搜索
插入
浏览
表树分隔符
将表分为不同层级的字符串。
表树最大深度
将文件拖动至此
SQL 上传 (
0
)
x
-
该处必须启用 Javascript!
服务器: 127.0.0.1
»
数据库: information_schema
»
视图: PARAMETERS
浏览
结构
SQL
搜索
导出
控制台
清除
历史
选项
书签
调试 SQL
按 Ctrl+Enter 键执行查询
按 Enter 执行查询
递增排序
递减排序
命令:
调试 SQL
数量
运行顺序
用时
排序条件:
联合查询
不使用联合查询
崩溃
扩展
显示跟踪
隐藏跟踪
数量
用时
书签
刷新
添加
没有书签
添加书签
标签:
目标数据库:
共享和谐书签
确定
选项
恢复默认
总是扩展查询消息
在开始时显示查询历史
显示当前浏览查询
浏览设置,使按Shift+Enter键执行输入和插入新行作为永久设置。
切换到黑色主题
崩溃
扩展
重新查询
编辑
解析
性能分析
书签
查询失败
数据库 :
查询时间 :
普通搜索
缩放搜索
查找和替换
执行“依例查询”(通配符:“%”)
字段
类型
排序规则
运算符
值
SPECIFIC_CATALOG
varchar(512)
utf8_general_ci
LIKE
LIKE %...%
NOT LIKE
=
!=
REGEXP
REGEXP ^...$
NOT REGEXP
= ''
!= ''
IN (...)
NOT IN (...)
BETWEEN
NOT BETWEEN
IS NULL
IS NOT NULL
SPECIFIC_SCHEMA
varchar(64)
utf8_general_ci
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 - smartschool1
def - abcschool333
def - test
def - smartschool
def - abcschool33
def - smartschool3
def - phpmyadmin
def - abcschool2
def - smartschool222
def - performance_schema
def - abc
def - smartschool111
abc - def
abcschool2 - def
abcschool33 - def
abcschool333 - def
information_schema - def
mysql - def
performance_schema - def
phpmyadmin - def
smartschool - def
smartschool1 - def
smartschool3 - def
smartschool111 - def
smartschool222 - def
test - def
SPECIFIC_NAME
varchar(64)
utf8_general_ci
LIKE
LIKE %...%
NOT LIKE
=
!=
REGEXP
REGEXP ^...$
NOT REGEXP
= ''
!= ''
IN (...)
NOT IN (...)
BETWEEN
NOT BETWEEN
IS NULL
IS NOT NULL
ORDINAL_POSITION
int(21)
=
>
>=
<
<=
!=
LIKE
LIKE %...%
NOT LIKE
IN (...)
NOT IN (...)
BETWEEN
NOT BETWEEN
IS NULL
IS NOT NULL
PARAMETER_MODE
varchar(5)
utf8_general_ci
LIKE
LIKE %...%
NOT LIKE
=
!=
REGEXP
REGEXP ^...$
NOT REGEXP
= ''
!= ''
IN (...)
NOT IN (...)
BETWEEN
NOT BETWEEN
IS NULL
IS NOT NULL
PARAMETER_NAME
varchar(64)
utf8_general_ci
LIKE
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
=
!=
REGEXP
REGEXP ^...$
NOT REGEXP
= ''
!= ''
IN (...)
NOT IN (...)
BETWEEN
NOT BETWEEN
IS NULL
IS NOT NULL
CHARACTER_MAXIMUM_LENGTH
int(21)
=
>
>=
<
<=
!=
LIKE
LIKE %...%
NOT LIKE
IN (...)
NOT IN (...)
BETWEEN
NOT BETWEEN
IS NULL
IS NOT NULL
CHARACTER_OCTET_LENGTH
int(21)
=
>
>=
<
<=
!=
LIKE
LIKE %...%
NOT LIKE
IN (...)
NOT IN (...)
BETWEEN
NOT BETWEEN
IS NULL
IS NOT NULL
NUMERIC_PRECISION
int(21)
=
>
>=
<
<=
!=
LIKE
LIKE %...%
NOT LIKE
IN (...)
NOT IN (...)
BETWEEN
NOT BETWEEN
IS NULL
IS NOT NULL
NUMERIC_SCALE
int(21)
=
>
>=
<
<=
!=
LIKE
LIKE %...%
NOT LIKE
IN (...)
NOT IN (...)
BETWEEN
NOT BETWEEN
IS NULL
IS NOT NULL
DATETIME_PRECISION
bigint(21)
=
>
>=
<
<=
!=
LIKE
LIKE %...%
NOT LIKE
IN (...)
NOT IN (...)
BETWEEN
NOT BETWEEN
IS NULL
IS NOT NULL
CHARACTER_SET_NAME
varchar(64)
utf8_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
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(64)
utf8_general_ci
LIKE
LIKE %...%
NOT LIKE
=
!=
REGEXP
REGEXP ^...$
NOT REGEXP
= ''
!= ''
IN (...)
NOT IN (...)
BETWEEN
NOT BETWEEN
IS NULL
IS NOT NULL
浏览不相关的值
DTD_IDENTIFIER
longtext
utf8_general_ci
LIKE
LIKE %...%
NOT LIKE
=
!=
REGEXP
REGEXP ^...$
NOT REGEXP
= ''
!= ''
IN (...)
NOT IN (...)
BETWEEN
NOT BETWEEN
IS NULL
IS NOT NULL
ROUTINE_TYPE
varchar(9)
utf8_general_ci
LIKE
LIKE %...%
NOT LIKE
=
!=
REGEXP
REGEXP ^...$
NOT REGEXP
= ''
!= ''
IN (...)
NOT IN (...)
BETWEEN
NOT BETWEEN
IS NULL
IS NOT NULL
选择字段(至少一个):
SPECIFIC_CATALOG
SPECIFIC_SCHEMA
SPECIFIC_NAME
ORDINAL_POSITION
PARAMETER_MODE
PARAMETER_NAME
DATA_TYPE
CHARACTER_MAXIMUM_LENGTH
CHARACTER_OCTET_LENGTH
NUMERIC_PRECISION
NUMERIC_SCALE
DATETIME_PRECISION
CHARACTER_SET_NAME
COLLATION_NAME
DTD_IDENTIFIER
ROUTINE_TYPE
DISTINCT
或
添加搜索条件(“where”从句的主体):
每页行数
显示顺序:
SPECIFIC_CATALOG
SPECIFIC_SCHEMA
SPECIFIC_NAME
ORDINAL_POSITION
PARAMETER_MODE
PARAMETER_NAME
DATA_TYPE
CHARACTER_MAXIMUM_LENGTH
CHARACTER_OCTET_LENGTH
NUMERIC_PRECISION
NUMERIC_SCALE
DATETIME_PRECISION
CHARACTER_SET_NAME
COLLATION_NAME
DTD_IDENTIFIER
ROUTINE_TYPE
递增
递减