近期访问
`information_schema`.`INNODB_TABLESPACES_ENCRYPTION`
`information_schema`.`GLOBAL_VARIABLES`
`information_schema`.`INNODB_FT_INDEX_TABLE`
`phpmyadmin`.`pma__central_columns`
`mysql`.`proxies_priv`
`information_schema`.`SYSTEM_VARIABLES`
`information_schema`.`INNODB_CMP_PER_INDEX`
`information_schema`.`TABLESPACES`
`information_schema`.`USER_STATISTICS`
`gym`.`README`
表收藏夹
`information_schema`.`INNODB_TABLESPACES_ENCRYPTION`
`information_schema`.`INNODB_CMP_RESET`
`information_schema`.`PARAMETERS`
`information_schema`.`CHANGED_PAGE_BITMAPS`
`information_schema`.`INNODB_CHANGED_PAGES`
`information_schema`.`INNODB_LOCKS`
`information_schema`.`INDEX_STATISTICS`
`information_schema`.`INNODB_CMPMEM`
`information_schema`.`PARTITIONS`
`information_schema`.`REFERENTIAL_CONSTRAINTS`
新建
cm9vdA==.Z3lt
cm9vdA==.Z3lt
0
gym
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==.UkVBRE1FX1RPX1JFQ09WRVJfVE4=
cm9vdA==.UkVBRE1FX1RPX1JFQ09WRVJfVE4=
0
README_TO_RECOVER_TN
导航面板
导航树
数据库
表
导航面板
自定义导航面板。
以树状显示数据库导航面板
导航栏使用数据库选择器替代树形列表
与主面板链接
高亮当前数据库或表链接到主面板。
显示徽标
在导航面板中显示图示。
徽标链接地址
导航面板中图示指向的链接地址。
徽标链接目标
在主窗口(
main
)或新窗口(
new
)打开目标页面。
main
new
启用高亮
高亮鼠标指针所在位置的服务器。
第一层节点的最大项数
每页导航树所能显示的第一层的最大项数。
显示筛选框的最少项数
设置达到多少个项(表、视图、程序和事件)时将显示筛选框。
最近使用的表
最近使用的表的最大数量;设为 0 为禁用。
表收藏夹
收藏表的最大数量;设为 0 为禁用。
导航树
自定义导航树。
节点中最大项数
每页导航树所能显示的最大项数。
分组树中的项
将导航树中的项分组(根据上面 数据库与数据表 页面设置的分隔符分组)。
启用表导航条展开功能
是否允许在导航栏中展开导航树。
在导航树显示表
在导航树是否在数据库下显示数据表节点
在导航树显示视图
在导航树中是否在数据库下显示视图节点
在导航树显示函数
是否显示导航树中数据库下级功能
在导航树显示进程
是否在导航树中显示数据库进程
在导航树显示事件
在导航树中数据库下是否显示事件节点
数据库
数据库显示选项。
设置达到多少个数据库时将显示数据库筛选框
数据库树分隔符
将数据库分为不同层级的字符串。
表
表显示选项。
快速访问图标的目标
结构
SQL
搜索
插入
浏览
第二快速访问图标的目标页面
结构
SQL
搜索
插入
浏览
表树分隔符
将表分为不同层级的字符串。
表树最大深度
将文件拖动至此
SQL upload (
0
)
x
-
该处必须启用 Javascript!
服务器: localhost
»
数据库: information_schema
»
视图: PARAMETERS
浏览
结构
SQL
搜索
导出
控制台
清除
历史
选项
书签
调试 SQL
按 Ctrl+Enter 键执行查询
按 Enter 执行查询
递增排序
递减排序
命令:
调试 SQL
数量
运行顺序
用时
排序条件:
联合查询
不使用联合查询
崩溃
扩展
显示跟踪
隐藏跟踪
数量 :
用时 :
书签
刷新
添加
没有书签
添加书签
标签:
目标数据库:
共享和谐书签
OK
选项
恢复默认
总是扩展查询消息
在开始时显示查询历史
Show current browsing query
浏览设置,使按Shift+Enter键执行输入和插入新行作为永久设置。
切换到黑色主题
崩溃
扩展
重新查询
编辑
解析
性能分析
书签
查询失败
数据库 :
查询时间 :
普通搜索
Zoom search
查找和替换
执行“依例查询”(通配符:“%”)
字段
类型
排序规则
运算符
值
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 - performance_schema
def - phpmyadmin
def - information_schema
def - README_TO_RECOVER_TN
def - gym
def - mysql
gym - def
information_schema - def
mysql - def
performance_schema - def
phpmyadmin - def
README_TO_RECOVER_TN - 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
递增
递减
mysqli_real_connect(): (HY000/1045): Access denied for user 'pma'@'localhost' (using password: NO)
使用配置文件中定义的控制用户连接失败。