Recent
`rceadmin_rceerp`.`message_sent`
`rceadmin_rceerp`.`quiz`
`mysql`.`innodb_index_stats`
`rceadmin_rceerp`.`student5`
`hu_website_db`.`programs_hod_message_specoutcome`
`rce_blog1`.`rce_bloghustle_tracking`
`rceroork_lms_rceroorkee`.`wh_lms_leads_history`
`rce_blog1`.`rce_blogactionscheduler_groups`
`rceadmin_rceerp`.`student_master`
`rce_blog1`.`rce_blogyoast_indexable`
Favourites
There are no favourite tables.
New
admin_attend
agarwalsabha
csv
csv_db 17
csv_db 18
edurcero_rcerke
hu_website_db
information_schema
mysql
performance_schema
phpmyadmin
rce
rce_blog1
rce_website_db
rceadmin
rceadmin_admission
rceadmin_attend
rceadmin_rceerp
rceadmin_result
rceroork_lms_rceroorkee
test
Navigation panel
Navigation tree
Servers
Databases
Tables
Navigation panel
Customise appearance of the navigation panel.
Navigation panel
Show databases navigation as tree
In the navigation panel, replaces the database tree with a selector
Link with main panel
Link with main panel by highlighting the current database or table.
Display logo
Show logo in navigation panel.
Logo link URL
URL where logo in the navigation panel will point to.
Logo link target
Open the linked page in the main window (
main
) or in a new one (
new
).
main
new
Enable highlighting
Highlight server under the mouse cursor.
Maximum items on first level
The number of items that can be displayed on each page on the first level of the navigation tree.
Minimum number of items to display the filter box
Defines the minimum number of items (tables, views, routines and events) to display a filter box.
Recently used tables
Maximum number of recently used tables; set 0 to disable.
Favourite tables
Maximum number of favourite tables; set 0 to disable.
Navigation panel width
Set to 0 to collapse navigation panel.
Not a non-negative number!
Navigation tree
Customise the navigation tree.
Navigation tree
Maximum items in branch
The number of items that can be displayed on each page of the navigation tree.
Group items in the tree
Group items in the navigation tree (determined by the separator defined in the Databases and Tables tabs above).
Enable navigation tree expansion
Whether to offer the possibility of tree expansion in the navigation panel.
Show tables in tree
Whether to show tables under database in the navigation tree
Show views in tree
Whether to show views under database in the navigation tree
Show functions in tree
Whether to show functions under database in the navigation tree
Show procedures in tree
Whether to show procedures under database in the navigation tree
Show events in tree
Whether to show events under database in the navigation tree
Expand single database
Whether to expand single database in the navigation tree automatically.
Servers
Servers display options.
Servers
Display servers selection
Display server choice at the top of the navigation panel.
Display servers as a list
Show server listing as a list instead of a drop down.
Databases
Databases display options.
Databases
Minimum number of databases to display the database filter box
Database tree separator
String that separates databases into different tree levels.
Tables
Tables display options.
Tables
Target for quick access icon
Structure
SQL
Search
Insert
Browse
Target for second quick access icon
Structure
SQL
Search
Insert
Browse
Table tree separator
String that separates tables into different tree levels.
Maximum table tree depth
Drop files here
SQL upload (
0
)
x
-
Show hidden navigation tree items.
Create view
Javascript must be enabled past this point!
Server: 127.0.0.1
Database: rceadmin_attend
Structure
SQL
Search
Query
(current)
Export
Import
Operations
Privileges
Routines
Events
Triggers
Tracking
Designer
Central columns
Console
Clear
History
Options
Bookmarks
Debug SQL
Press Ctrl+Enter to execute query
Press Enter to execute query
ascending
descending
Order:
Debug SQL
Count
Execution order
Time taken
Order by:
Group queries
Ungroup queries
Collapse
Expand
Show trace
Hide trace
Count :
Time taken :
Bookmarks
Refresh
Add
No bookmarks
Add bookmark
Label:
Target database:
Share this bookmark
OK
Options
Set default
Always expand query messages
Show query history at start
Show current browsing query
Execute queries on Enter and insert new line with Shift+Enter. To make this permanent, view settings.
Switch to dark theme
Collapse
Expand
Requery
Edit
Explain
Profiling
Bookmark
Query failed
Database :
Queried time :
Loading
ENUM/SET editor
Create view
Multi-table query
Query by example
Query window
*
id
regno
email
sname
fname
dob
gender
religion
domicile
addr
phone
course
hsyear
hsmarks
ityear
itmarks
pcm
reference
inspiration
ocp
time
dor
ip
*
id
regno
fname
email
mobile
city
query
course
date_time
ip
*
PageID
IP
Time
Count
*
id
guid
user_id
operator_id
message
seen
operator
created_at
*
id
name
description
disabled
created_at
updated_at
*
id
operator_id
department
token
name
email
website
gravatar
status
ip
uri
country
city
cc
ping_at
created_at
*
id
name
function
*
histid
user_caps
action
object_type
object_subtype
object_name
object_id
user_id
hist_ip
hist_time
*
id
user_id
component
type
action
content
primary_link
item_id
secondary_item_id
date_recorded
hide_sitewide
mptt_left
mptt_right
is_spam
*
id
activity_id
meta_key
meta_value
*
id
creator_id
name
slug
description
status
enable_forum
date_created
*
id
group_id
meta_key
meta_value
*
id
group_id
user_id
inviter_id
is_admin
is_mod
user_title
date_modified
comments
is_confirmed
is_banned
invite_sent
*
id
thread_id
sender_id
subject
message
date_sent
*
id
message_id
meta_key
meta_value
*
id
subject
message
date_sent
is_active
*
id
user_id
thread_id
unread_count
sender_only
is_deleted
*
id
user_id
item_id
secondary_item_id
component_name
component_action
date_notified
is_new
*
id
notification_id
meta_key
meta_value
*
id
user_id
blog_id
*
id
blog_id
meta_key
meta_value
*
id
field_id
user_id
value
last_updated
*
id
group_id
parent_id
type
name
description
is_required
is_default_option
field_order
option_order
order_by
can_delete
*
id
name
description
group_order
can_delete
*
id
object_id
object_type
meta_key
meta_value
*
submit_time
*
submit_time
form_name
field_name
field_value
field_order
file
*
id
created
*
id
cf7_id
data_id
name
value
*
meta_id
comment_id
meta_key
meta_value
*
comment_ID
comment_post_ID
comment_author
comment_author_email
comment_author_url
comment_author_IP
comment_date
comment_date_gmt
comment_content
comment_karma
comment_approved
comment_agent
comment_type
comment_parent
user_id
*
id
form_name
form_structure
fp_from_email
fp_destination_emails
fp_subject
fp_inc_additional_info
fp_return_page
fp_message
cu_enable_copy_to_user
cu_user_email_field
cu_subject
cu_message
vs_use_validation
vs_text_is_required
vs_text_is_email
vs_text_datemmddyyyy
vs_text_dateddmmyyyy
vs_text_number
vs_text_digits
vs_text_max
vs_text_min
vs_text_submitbtn
vs_text_previousbtn
vs_text_nextbtn
cv_enable_captcha
cv_width
cv_height
cv_chars
cv_font
cv_min_font_size
cv_max_font_size
cv_noise
cv_noise_length
cv_background
cv_border
cv_text_enter_valid_captcha
*
id
title
data
width
height
status
*
url
title
keywords
description
content
full_content
*
form_id
form_post_id
form_value
form_date
*
id
session_id
es_date
es_time
es_endtime
userid
event
browser
platform
ip
city
region
countryName
url_id
url_term
referer_doamin
referer_url
screensize
isunique
landing
select table
adm
popupenquiry
wprce_adspage
wprce_alc_chat
wprce_alc_departments
wprce_alc_users
wprce_allowphp_functions
wprce_aryo_activity_log
wprce_bp_activity
wprce_bp_activity_meta
wprce_bp_groups
wprce_bp_groups_groupmeta
wprce_bp_groups_members
wprce_bp_messages_messages
wprce_bp_messages_meta
wprce_bp_messages_notices
wprce_bp_messages_recipients
wprce_bp_notifications
wprce_bp_notifications_meta
wprce_bp_user_blogs
wprce_bp_user_blogs_blogmeta
wprce_bp_xprofile_data
wprce_bp_xprofile_fields
wprce_bp_xprofile_groups
wprce_bp_xprofile_meta
wprce_cf7dbplugin_st
wprce_cf7dbplugin_submits
wprce_cf7_data
wprce_cf7_data_entry
wprce_commentmeta
wprce_comments
wprce_cp_easy_form_settings
wprce_custommaps
wprce_datalist
wprce_db7_forms
wprce_es
.
select column
Show
criteria
Sort
Ascending
Descending
Add as
AND
OR
Op
=
>
>=
<
<=
!=
LIKE
LIKE %...%
NOT LIKE
NOT LIKE %...%
IN (...)
NOT IN (...)
BETWEEN
NOT BETWEEN
IS NULL
IS NOT NULL
REGEXP
REGEXP ^...$
NOT REGEXP
Text
Another column
select table
adm
popupenquiry
wprce_adspage
wprce_alc_chat
wprce_alc_departments
wprce_alc_users
wprce_allowphp_functions
wprce_aryo_activity_log
wprce_bp_activity
wprce_bp_activity_meta
wprce_bp_groups
wprce_bp_groups_groupmeta
wprce_bp_groups_members
wprce_bp_messages_messages
wprce_bp_messages_meta
wprce_bp_messages_notices
wprce_bp_messages_recipients
wprce_bp_notifications
wprce_bp_notifications_meta
wprce_bp_user_blogs
wprce_bp_user_blogs_blogmeta
wprce_bp_xprofile_data
wprce_bp_xprofile_fields
wprce_bp_xprofile_groups
wprce_bp_xprofile_meta
wprce_cf7dbplugin_st
wprce_cf7dbplugin_submits
wprce_cf7_data
wprce_cf7_data_entry
wprce_commentmeta
wprce_comments
wprce_cp_easy_form_settings
wprce_custommaps
wprce_datalist
wprce_db7_forms
wprce_es
.
select column
select table
adm
popupenquiry
wprce_adspage
wprce_alc_chat
wprce_alc_departments
wprce_alc_users
wprce_allowphp_functions
wprce_aryo_activity_log
wprce_bp_activity
wprce_bp_activity_meta
wprce_bp_groups
wprce_bp_groups_groupmeta
wprce_bp_groups_members
wprce_bp_messages_messages
wprce_bp_messages_meta
wprce_bp_messages_notices
wprce_bp_messages_recipients
wprce_bp_notifications
wprce_bp_notifications_meta
wprce_bp_user_blogs
wprce_bp_user_blogs_blogmeta
wprce_bp_xprofile_data
wprce_bp_xprofile_fields
wprce_bp_xprofile_groups
wprce_bp_xprofile_meta
wprce_cf7dbplugin_st
wprce_cf7dbplugin_submits
wprce_cf7_data
wprce_cf7_data_entry
wprce_commentmeta
wprce_comments
wprce_cp_easy_form_settings
wprce_custommaps
wprce_datalist
wprce_db7_forms
wprce_es
.
select column
Show
criteria
Sort
Ascending
Descending
Add as
AND
OR
Op
=
>
>=
<
<=
!=
LIKE
LIKE %...%
NOT LIKE
NOT LIKE %...%
IN (...)
NOT IN (...)
BETWEEN
NOT BETWEEN
IS NULL
IS NOT NULL
REGEXP
REGEXP ^...$
NOT REGEXP
Text
Another column
select table
adm
popupenquiry
wprce_adspage
wprce_alc_chat
wprce_alc_departments
wprce_alc_users
wprce_allowphp_functions
wprce_aryo_activity_log
wprce_bp_activity
wprce_bp_activity_meta
wprce_bp_groups
wprce_bp_groups_groupmeta
wprce_bp_groups_members
wprce_bp_messages_messages
wprce_bp_messages_meta
wprce_bp_messages_notices
wprce_bp_messages_recipients
wprce_bp_notifications
wprce_bp_notifications_meta
wprce_bp_user_blogs
wprce_bp_user_blogs_blogmeta
wprce_bp_xprofile_data
wprce_bp_xprofile_fields
wprce_bp_xprofile_groups
wprce_bp_xprofile_meta
wprce_cf7dbplugin_st
wprce_cf7dbplugin_submits
wprce_cf7_data
wprce_cf7_data_entry
wprce_commentmeta
wprce_comments
wprce_cp_easy_form_settings
wprce_custommaps
wprce_datalist
wprce_db7_forms
wprce_es
.
select column
select table
adm
popupenquiry
wprce_adspage
wprce_alc_chat
wprce_alc_departments
wprce_alc_users
wprce_allowphp_functions
wprce_aryo_activity_log
wprce_bp_activity
wprce_bp_activity_meta
wprce_bp_groups
wprce_bp_groups_groupmeta
wprce_bp_groups_members
wprce_bp_messages_messages
wprce_bp_messages_meta
wprce_bp_messages_notices
wprce_bp_messages_recipients
wprce_bp_notifications
wprce_bp_notifications_meta
wprce_bp_user_blogs
wprce_bp_user_blogs_blogmeta
wprce_bp_xprofile_data
wprce_bp_xprofile_fields
wprce_bp_xprofile_groups
wprce_bp_xprofile_meta
wprce_cf7dbplugin_st
wprce_cf7dbplugin_submits
wprce_cf7_data
wprce_cf7_data_entry
wprce_commentmeta
wprce_comments
wprce_cp_easy_form_settings
wprce_custommaps
wprce_datalist
wprce_db7_forms
wprce_es
.
select column
Show
criteria
Sort
Ascending
Descending
Add as
AND
OR
Op
=
>
>=
<
<=
!=
LIKE
LIKE %...%
NOT LIKE
NOT LIKE %...%
IN (...)
NOT IN (...)
BETWEEN
NOT BETWEEN
IS NULL
IS NOT NULL
REGEXP
REGEXP ^...$
NOT REGEXP
Text
Another column
select table
adm
popupenquiry
wprce_adspage
wprce_alc_chat
wprce_alc_departments
wprce_alc_users
wprce_allowphp_functions
wprce_aryo_activity_log
wprce_bp_activity
wprce_bp_activity_meta
wprce_bp_groups
wprce_bp_groups_groupmeta
wprce_bp_groups_members
wprce_bp_messages_messages
wprce_bp_messages_meta
wprce_bp_messages_notices
wprce_bp_messages_recipients
wprce_bp_notifications
wprce_bp_notifications_meta
wprce_bp_user_blogs
wprce_bp_user_blogs_blogmeta
wprce_bp_xprofile_data
wprce_bp_xprofile_fields
wprce_bp_xprofile_groups
wprce_bp_xprofile_meta
wprce_cf7dbplugin_st
wprce_cf7dbplugin_submits
wprce_cf7_data
wprce_cf7_data_entry
wprce_commentmeta
wprce_comments
wprce_cp_easy_form_settings
wprce_custommaps
wprce_datalist
wprce_db7_forms
wprce_es
.
select column
select table
adm
popupenquiry
wprce_adspage
wprce_alc_chat
wprce_alc_departments
wprce_alc_users
wprce_allowphp_functions
wprce_aryo_activity_log
wprce_bp_activity
wprce_bp_activity_meta
wprce_bp_groups
wprce_bp_groups_groupmeta
wprce_bp_groups_members
wprce_bp_messages_messages
wprce_bp_messages_meta
wprce_bp_messages_notices
wprce_bp_messages_recipients
wprce_bp_notifications
wprce_bp_notifications_meta
wprce_bp_user_blogs
wprce_bp_user_blogs_blogmeta
wprce_bp_xprofile_data
wprce_bp_xprofile_fields
wprce_bp_xprofile_groups
wprce_bp_xprofile_meta
wprce_cf7dbplugin_st
wprce_cf7dbplugin_submits
wprce_cf7_data
wprce_cf7_data_entry
wprce_commentmeta
wprce_comments
wprce_cp_easy_form_settings
wprce_custommaps
wprce_datalist
wprce_db7_forms
wprce_es
.
select column
Show
criteria
Sort
Ascending
Descending
Add as
AND
OR
Op
=
>
>=
<
<=
!=
LIKE
LIKE %...%
NOT LIKE
NOT LIKE %...%
IN (...)
NOT IN (...)
BETWEEN
NOT BETWEEN
IS NULL
IS NOT NULL
REGEXP
REGEXP ^...$
NOT REGEXP
Text
Another column
select table
adm
popupenquiry
wprce_adspage
wprce_alc_chat
wprce_alc_departments
wprce_alc_users
wprce_allowphp_functions
wprce_aryo_activity_log
wprce_bp_activity
wprce_bp_activity_meta
wprce_bp_groups
wprce_bp_groups_groupmeta
wprce_bp_groups_members
wprce_bp_messages_messages
wprce_bp_messages_meta
wprce_bp_messages_notices
wprce_bp_messages_recipients
wprce_bp_notifications
wprce_bp_notifications_meta
wprce_bp_user_blogs
wprce_bp_user_blogs_blogmeta
wprce_bp_xprofile_data
wprce_bp_xprofile_fields
wprce_bp_xprofile_groups
wprce_bp_xprofile_meta
wprce_cf7dbplugin_st
wprce_cf7dbplugin_submits
wprce_cf7_data
wprce_cf7_data_entry
wprce_commentmeta
wprce_comments
wprce_cp_easy_form_settings
wprce_custommaps
wprce_datalist
wprce_db7_forms
wprce_es
.
select column