近期访问
`information_schema`.`STATISTICS`
`abcschool333`.`hostel_rooms`
`information_schema`.`SCHEMATA`
`smartschool`.`staff_leave_details`
`abcschool333`.`fees_discounts`
`abcschool333`.`income_head`
`abcschool333`.`class_sections`
`abcschool333`.`content_for`
`abcschool333`.`id_card`
`abcschool333`.`onlineexam`
表收藏夹
`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
»
数据库: abcschool2
结构
SQL
搜索
查询
导出
导入
操作
权限
程序
事件
触发器
追踪
设计器
文本框列
控制台
清除
历史
选项
书签
调试 SQL
按 Ctrl+Enter 键执行查询
按 Enter 执行查询
递增排序
递减排序
命令:
调试 SQL
数量
运行顺序
用时
排序条件:
联合查询
不使用联合查询
崩溃
扩展
显示跟踪
隐藏跟踪
数量
用时
书签
刷新
添加
没有书签
添加书签
标签:
目标数据库:
共享和谐书签
确定
选项
恢复默认
总是扩展查询消息
在开始时显示查询历史
显示当前浏览查询
浏览设置,使按Shift+Enter键执行输入和插入新行作为永久设置。
切换到黑色主题
崩溃
扩展
重新查询
编辑
解析
性能分析
书签
查询失败
数据库 :
查询时间 :
多表查询
通过示例查询
*
id
type
key_value
is_active
created_at
updated_at
*
id
book_title
book_no
isbn_no
subject
rack_no
publish
author
qty
perunitcost
postdate
description
available
is_active
created_at
updated_at
*
id
book_id
duereturn_date
return_date
issue_date
is_returned
member_id
is_active
created_at
*
id
category
is_active
created_at
updated_at
*
id
certificate_name
certificate_text
left_header
center_header
right_header
left_footer
right_footer
center_footer
background_image
created_at
updated_at
created_for
status
header_height
content_height
footer_height
content_width
enable_student_image
enable_image_height
*
id
chat_user_one
chat_user_two
ip
time
created_at
updated_at
*
id
message
chat_user_id
ip
time
is_first
is_read
chat_connection_id
created_at
*
id
user_type
staff_id
student_id
create_staff_id
create_student_id
is_active
created_at
updated_at
*
id
class
is_active
created_at
updated_at
*
id
class_id
section_id
is_active
created_at
updated_at
*
id
class_id
staff_id
section_id
session_id
*
id
complaint_type
source
name
contact
email
date
description
action_taken
assigned
note
image
*
id
complaint_type
description
created_at
*
id
title
type
is_public
class_id
cls_sec_id
file
created_by
note
is_active
created_at
updated_at
date
*
id
role
content_id
user_id
created_at
*
id
name
belong_to
type
bs_column
validation
field_values
show_table
visible_on_table
weight
is_active
created_at
updated_at
*
id
belong_table_id
custom_field_id
field_value
created_at
updated_at
*
id
department_name
is_active
*
id
reason
created_at
*
id
reference_no
to_title
address
note
from_title
date
image
created_at
updated_at
type
*
id
email_type
smtp_server
smtp_port
smtp_username
smtp_password
ssl_tls
is_active
created_at
*
id
name
contact
address
reference
date
description
follow_up_date
note
source
email
assigned
class
no_of_child
status
*
id
enquiry_type
description
*
id
event_title
event_description
start_date
end_date
event_type
event_color
event_for
role_id
is_active
*
id
name
sesion_id
note
is_active
created_at
updated_at
*
id
name
exam_type
description
is_active
created_at
updated_at
*
id
exam
session_id
date_from
date_to
description
exam_group_id
is_publish
is_active
created_at
updated_at
*
id
exam_group_class_batch_exam_id
student_id
student_session_id
roll_no
is_active
created_at
updated_at
*
id
exam_group_class_batch_exams_id
subject_id
date_from
time_from
duration
room_no
max_marks
min_marks
credit_hours
date_to
is_active
created_at
updated_at
*
id
exam_group_id
exam_group_class_batch_exams_id
exam_weightage
is_active
created_at
updated_at
*
id
exam_group_class_batch_exam_student_id
exam_group_class_batch_exam_subject_id
attendence
get_marks
note
is_active
created_at
updated_at
exam_group_student_id
*
id
exam_group_id
student_id
student_session_id
is_active
created_at
updated_at
*
id
attendence
exam_schedule_id
student_id
get_marks
note
is_active
created_at
updated_at
*
id
session_id
exam_id
teacher_subject_id
date_of_exam
start_to
end_from
room_no
full_marks
passing_marks
note
is_active
created_at
updated_at
*
id
exp_head_id
name
invoice_no
date
amount
documents
note
is_active
is_deleted
created_at
updated_at
*
id
exp_category
description
is_active
is_deleted
created_at
updated_at
*
id
category
is_active
created_at
updated_at
*
id
session_id
feetype_id
class_id
amount
description
is_active
created_at
updated_at
*
id
session_id
name
code
amount
description
is_active
created_at
*
id
reminder_type
day
is_active
created_at
updated_at
*
id
is_system
feecategory_id
type
code
is_active
created_at
updated_at
description
*
id
name
is_system
description
is_active
created_at
*
id
fee_session_group_id
fee_groups_id
feetype_id
session_id
amount
fine_type
due_date
fine_percentage
fine_amount
is_active
created_at
*
id
payment
*
id
fee_groups_id
session_id
is_active
created_at
*
id
enquiry_id
date
next_date
response
note
followup_by
*
id
image
thumb_path
dir_path
img_name
thumb_name
created_at
file_type
file_size
vid_url
vid_title
*
id
menu
slug
description
open_new_tab
ext_url
ext_url_link
publish
content_type
is_active
created_at
*
id
menu_id
menu
page_id
parent_id
ext_url
open_new_tab
ext_url_link
slug
weight
publish
description
is_active
created_at
*
id
page_type
is_homepage
title
url
type
slug
meta_title
meta_description
meta_keyword
feature_image
description
publish_date
publish
sidebar
is_active
created_at
*
id
page_id
content_type
created_at
*
id
type
slug
url
title
date
event_start
event_end
event_venue
description
is_active
created_at
meta_title
meta_description
meta_keyword
feature_image
publish_date
publish
sidebar
*
id
program_id
media_gallery_id
created_at
*
id
theme
is_active_rtl
is_active_front_cms
is_active_sidebar
logo
contact_us_email
complain_form_email
sidebar_options
fb_url
twitter_url
youtube_url
google_plus
instagram_url
pinterest_url
linkedin_url
google_analytics
footer_text
fav_icon
created_at
*
id
name
contact
date
description
follow_up_date
call_dureation
note
call_type
*
id
exam_type
name
point
mark_from
mark_upto
description
is_active
created_at
updated_at
*
id
class_id
section_id
session_id
homework_date
submit_date
staff_id
subject_group_subject_id
subject_id
description
create_date
evaluation_date
document
created_by
evaluated_by
选择表
attendence_type
books
book_issues
categories
certificates
chat_connections
chat_messages
chat_users
classes
class_sections
class_teacher
complaint
complaint_type
contents
content_for
custom_fields
custom_field_values
department
disable_reason
dispatch_receive
email_config
enquiry
enquiry_type
events
exams
exam_groups
exam_group_class_batch_exams
exam_group_class_batch_exam_students
exam_group_class_batch_exam_subjects
exam_group_exam_connections
exam_group_exam_results
exam_group_students
exam_results
exam_schedules
expenses
expense_head
feecategory
feemasters
fees_discounts
fees_reminder
feetype
fee_groups
fee_groups_feetype
fee_receipt_no
fee_session_groups
follow_up
front_cms_media_gallery
front_cms_menus
front_cms_menu_items
front_cms_pages
front_cms_page_contents
front_cms_programs
front_cms_program_photos
front_cms_settings
general_calls
grades
homework
.
选择字段
显示
排序
递增
递减
添加为
AND
OR
Op
=
>
>=
<
<=
!=
LIKE
LIKE %...%
NOT LIKE
IN (...)
NOT IN (...)
BETWEEN
NOT BETWEEN
IS NULL
IS NOT NULL
REGEXP
REGEXP ^...$
NOT REGEXP
文字
另一个字段
选择表
attendence_type
books
book_issues
categories
certificates
chat_connections
chat_messages
chat_users
classes
class_sections
class_teacher
complaint
complaint_type
contents
content_for
custom_fields
custom_field_values
department
disable_reason
dispatch_receive
email_config
enquiry
enquiry_type
events
exams
exam_groups
exam_group_class_batch_exams
exam_group_class_batch_exam_students
exam_group_class_batch_exam_subjects
exam_group_exam_connections
exam_group_exam_results
exam_group_students
exam_results
exam_schedules
expenses
expense_head
feecategory
feemasters
fees_discounts
fees_reminder
feetype
fee_groups
fee_groups_feetype
fee_receipt_no
fee_session_groups
follow_up
front_cms_media_gallery
front_cms_menus
front_cms_menu_items
front_cms_pages
front_cms_page_contents
front_cms_programs
front_cms_program_photos
front_cms_settings
general_calls
grades
homework
.
选择字段
X
选择表
attendence_type
books
book_issues
categories
certificates
chat_connections
chat_messages
chat_users
classes
class_sections
class_teacher
complaint
complaint_type
contents
content_for
custom_fields
custom_field_values
department
disable_reason
dispatch_receive
email_config
enquiry
enquiry_type
events
exams
exam_groups
exam_group_class_batch_exams
exam_group_class_batch_exam_students
exam_group_class_batch_exam_subjects
exam_group_exam_connections
exam_group_exam_results
exam_group_students
exam_results
exam_schedules
expenses
expense_head
feecategory
feemasters
fees_discounts
fees_reminder
feetype
fee_groups
fee_groups_feetype
fee_receipt_no
fee_session_groups
follow_up
front_cms_media_gallery
front_cms_menus
front_cms_menu_items
front_cms_pages
front_cms_page_contents
front_cms_programs
front_cms_program_photos
front_cms_settings
general_calls
grades
homework
.
选择字段
显示
排序
递增
递减
添加为
AND
OR
Op
=
>
>=
<
<=
!=
LIKE
LIKE %...%
NOT LIKE
IN (...)
NOT IN (...)
BETWEEN
NOT BETWEEN
IS NULL
IS NOT NULL
REGEXP
REGEXP ^...$
NOT REGEXP
文字
另一个字段
选择表
attendence_type
books
book_issues
categories
certificates
chat_connections
chat_messages
chat_users
classes
class_sections
class_teacher
complaint
complaint_type
contents
content_for
custom_fields
custom_field_values
department
disable_reason
dispatch_receive
email_config
enquiry
enquiry_type
events
exams
exam_groups
exam_group_class_batch_exams
exam_group_class_batch_exam_students
exam_group_class_batch_exam_subjects
exam_group_exam_connections
exam_group_exam_results
exam_group_students
exam_results
exam_schedules
expenses
expense_head
feecategory
feemasters
fees_discounts
fees_reminder
feetype
fee_groups
fee_groups_feetype
fee_receipt_no
fee_session_groups
follow_up
front_cms_media_gallery
front_cms_menus
front_cms_menu_items
front_cms_pages
front_cms_page_contents
front_cms_programs
front_cms_program_photos
front_cms_settings
general_calls
grades
homework
.
选择字段
X
选择表
attendence_type
books
book_issues
categories
certificates
chat_connections
chat_messages
chat_users
classes
class_sections
class_teacher
complaint
complaint_type
contents
content_for
custom_fields
custom_field_values
department
disable_reason
dispatch_receive
email_config
enquiry
enquiry_type
events
exams
exam_groups
exam_group_class_batch_exams
exam_group_class_batch_exam_students
exam_group_class_batch_exam_subjects
exam_group_exam_connections
exam_group_exam_results
exam_group_students
exam_results
exam_schedules
expenses
expense_head
feecategory
feemasters
fees_discounts
fees_reminder
feetype
fee_groups
fee_groups_feetype
fee_receipt_no
fee_session_groups
follow_up
front_cms_media_gallery
front_cms_menus
front_cms_menu_items
front_cms_pages
front_cms_page_contents
front_cms_programs
front_cms_program_photos
front_cms_settings
general_calls
grades
homework
.
选择字段
显示
排序
递增
递减
添加为
AND
OR
Op
=
>
>=
<
<=
!=
LIKE
LIKE %...%
NOT LIKE
IN (...)
NOT IN (...)
BETWEEN
NOT BETWEEN
IS NULL
IS NOT NULL
REGEXP
REGEXP ^...$
NOT REGEXP
文字
另一个字段
选择表
attendence_type
books
book_issues
categories
certificates
chat_connections
chat_messages
chat_users
classes
class_sections
class_teacher
complaint
complaint_type
contents
content_for
custom_fields
custom_field_values
department
disable_reason
dispatch_receive
email_config
enquiry
enquiry_type
events
exams
exam_groups
exam_group_class_batch_exams
exam_group_class_batch_exam_students
exam_group_class_batch_exam_subjects
exam_group_exam_connections
exam_group_exam_results
exam_group_students
exam_results
exam_schedules
expenses
expense_head
feecategory
feemasters
fees_discounts
fees_reminder
feetype
fee_groups
fee_groups_feetype
fee_receipt_no
fee_session_groups
follow_up
front_cms_media_gallery
front_cms_menus
front_cms_menu_items
front_cms_pages
front_cms_page_contents
front_cms_programs
front_cms_program_photos
front_cms_settings
general_calls
grades
homework
.
选择字段
X
选择表
attendence_type
books
book_issues
categories
certificates
chat_connections
chat_messages
chat_users
classes
class_sections
class_teacher
complaint
complaint_type
contents
content_for
custom_fields
custom_field_values
department
disable_reason
dispatch_receive
email_config
enquiry
enquiry_type
events
exams
exam_groups
exam_group_class_batch_exams
exam_group_class_batch_exam_students
exam_group_class_batch_exam_subjects
exam_group_exam_connections
exam_group_exam_results
exam_group_students
exam_results
exam_schedules
expenses
expense_head
feecategory
feemasters
fees_discounts
fees_reminder
feetype
fee_groups
fee_groups_feetype
fee_receipt_no
fee_session_groups
follow_up
front_cms_media_gallery
front_cms_menus
front_cms_menu_items
front_cms_pages
front_cms_page_contents
front_cms_programs
front_cms_program_photos
front_cms_settings
general_calls
grades
homework
.
选择字段
显示
排序
递增
递减
添加为
AND
OR
Op
=
>
>=
<
<=
!=
LIKE
LIKE %...%
NOT LIKE
IN (...)
NOT IN (...)
BETWEEN
NOT BETWEEN
IS NULL
IS NOT NULL
REGEXP
REGEXP ^...$
NOT REGEXP
文字
另一个字段
选择表
attendence_type
books
book_issues
categories
certificates
chat_connections
chat_messages
chat_users
classes
class_sections
class_teacher
complaint
complaint_type
contents
content_for
custom_fields
custom_field_values
department
disable_reason
dispatch_receive
email_config
enquiry
enquiry_type
events
exams
exam_groups
exam_group_class_batch_exams
exam_group_class_batch_exam_students
exam_group_class_batch_exam_subjects
exam_group_exam_connections
exam_group_exam_results
exam_group_students
exam_results
exam_schedules
expenses
expense_head
feecategory
feemasters
fees_discounts
fees_reminder
feetype
fee_groups
fee_groups_feetype
fee_receipt_no
fee_session_groups
follow_up
front_cms_media_gallery
front_cms_menus
front_cms_menu_items
front_cms_pages
front_cms_page_contents
front_cms_programs
front_cms_program_photos
front_cms_settings
general_calls
grades
homework
.
选择字段
X