Recent
`test`.`login_log`
`test`.`login_attempts`
`test`.`accountmanger`
`test`.`news`
`mysql`.`help_category`
`mysql`.`proc`
`mysql`.`innodb_index_stats`
`mysql`.`columns_priv`
`mysql`.`event`
`mysql`.`help_relation`
Favorites
There are no favorite tables.
New
information_schema
mysql
performance_schema
phpmyadmin
test
Navigation panel
Navigation tree
Servers
Databases
Tables
Navigation panel
Customize 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.
Favorite tables
Maximum number of favorite tables; set 0 to disable.
Navigation panel width
Set to 0 to collapse navigation panel.
Navigation tree
Customize 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: test
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
*
log_id
user_id
resource_type
resource_id
action
result
ip_address
user_agent
access_time
*
user_Id
email
Password_hash
FirstName
LastName
Institution
Department
Position
PhoneNumber
ProfilePicture
Bio
RegistrationDate
LastLoginDate
AccountType
CreatedAt
UpdatedAt
VerificationStatus
AccountStatus
ResetToken
Country
LoginCount
LastLoginCountry
Title
FailedLoginCount
AccountLockedUntil
PasswordChangeRequired
LastPasswordChange
*
total_attendees
regular_count
vegetarian_count
special_count
extra_tickets_total
*
id
name
display_order
*
id
category_id
name
affiliation
display_order
*
id
year
start_date
end_date
location
theme
participants
countries_count
format
*
id
year
title
location
start_date
end_date
host_organization
description
sponsor_info
*
id
icon
title
description
*
id
title
description
image_path
display_order
*
id
category_id
subtopic_code
topic_name
*
id
topic_code
category_name
description
*
country_id
country_code
country_name_zh
country_name_en
region
*
id
vocabulary
meaning
*
id
title
date_start
date_end
old_date
is_strikethrough
is_highlight
description
icon
sort_order
is_active
created_at
updated_at
*
attempt_id
email
ip_address
user_agent
status
attempt_time
*
log_id
user_id
login_time
login_ip
country
device_info
login_status
*
lunch_day
total_needed
regular_count
vegetarian_count
special_count
*
news_id
title
content
type
important
status
visibility
create_date
publish_date
author_id
updated_by
update_date
created_at
updated_at
*
attachment_id
news_id
filename
original_filename
file_path
file_size
file_type
upload_date
uploader_id
created_at
*
log_id
news_id
user_id
read_at
*
type_id
type_name
type_color
sort_order
is_active
created_at
updated_at
*
Decision_Id
Paper_Id
Decision
DecisionDate
Comments
Editor_Id
Notification_Sent
NotificationDate
RevisionDueDate
IsFinal
Volume
Issue
*
id
paper_id
author_order
first_name
last_name
email
phone
institution
department
position
country
is_corresponding
created_at
*
id
user_Id
changed_at
ip_address
*
history_id
user_id
password_hash
created_time
*
Payment_id
Paper_Id
Amount
PaymentStatus
PaymentMethod
PaymentDate
InvoiceNumber
Transaction_Id
Remark
CreatedAt
user_id
Currency
ReceiptUrl
created_at
updated_at
*
payment_status
payment_method
count
total_amount
payment_currency
*
id
title
image_path
description
album_category
sort_order
is_active
created_at
updated_at
*
id
presentation_id
paper_id
authors
title
category_id
presentation_type
session_date
session_time
location
is_award_winner
display_order
*
id
type
content
display_order
*
id
first_name
last_name
email
phone
affiliation
identity
paper_id
presentation_type
paper_title
lunch_day1
lunch_day1_type
lunch_day1_special_note
lunch_day2
lunch_day2_type
lunch_day2_special_note
banquet
banquet_diet_type
banquet_special_note
extra_banquet_tickets
payment_method
payment_status
payment_amount
payment_currency
payment_date
payment_reference
payment_proof_url
payment_proof_uploaded_at
transfer_last_digits
tax_id_number
receipt_title
special_requests
agreement
registration_status
created_at
updated_at
submitted_at
registration_number
*
id
identity
deadline
fee_local
fee_oversea
currency_local
currency_oversea
note
is_active
created_at
*
assignment_id
paper_id
reviewer_id
assigned_date
deadline
status
progress
note
decision
feedback
*
id
Paper_Id
Reviewer_Id
content
decision
Is_final
created_at
*
Paper_Id
Submission_code
auther_id
abstract
Keywords
Category
FilePath
Status
SubmissionDate
LastUpdate
Note
Review_status
Review_result
Submission_date
Review_comments
PaperTitle
main_category_id
subcategory_code
final_reviewer_id
word_file_path
has_word_file
file_upload_date
total_file_size
revision_count
revision_deadline
is_resubmitted
original_review_result
*
reminder_id
assignment_id
message
created_at
*
id
title
image_path
description
is_active
sort_order
created_at
updated_at
*
id
time_slot
day_wed_title
day_wed_location
day_wed_type
day_thu_title
day_thu_location
day_thu_type
day_fri_title
day_fri_location
day_fri_type
display_order
*
login_date
total_attempts
failed_attempts
successful_logins
unique_ips
unique_emails
*
event_id
event_type
severity
source_ip
user_id
description
event_time
resolved
resolution_notes
*
id
code
title
description
display_order
*
id
type_id
name
affiliation
topic
biography
session
image_path
abstract_pdf_path
display_order
updated_at
*
id
type_name
display_order
*
id
name
logo_path
website
sort_order
is_active
created_at
updated_at
*
submission_year
main_category_id
subcategory_code
submission_count
max_serial_number
*
Notification_Id
User_Id
Title
Content
Type
Is_Read
CreatedAt
ExpiryDate
Priority
ReferenceType
Reference_id
Recipient_type
Status
Scheduled_time
Created_by
recipient_type_details
send_email
updated_at
*
setting_id
setting_name
setting_value
description
category
last_modified
modified_by
*
id
category
description
icon
*
id
name
file_path
type
display_order
*
id
topic_id
item_title
*
user_id
username
password
email
full_name
role
status
last_login
created_at
updated_at
*
activity_id
user_id
activity_type
description
ip_address
user_agent
activity_time
additional_data
*
session_id
user_id
ip_address
user_agent
login_time
last_activity
logout_time
session_status
select table
access_logs
accountmanger
banquet_summary
committee_categories
committee_members
conference_history
conference_info
conference_objectives
conference_photos
conference_subtopics
conference_topics
countries
dictionary
important_dates
login_attempts
login_log
lunch_summary
news
news_attachments
news_read_logs
news_types
paperdecision
paper_authors
password_change_log
password_history
payments
payment_summary
photo_album
presentations
presentation_guidelines
registrations
registration_fees
reviewassignments
reviewcomments
reviewcontent
reviewreminders
schedule_images
schedule_timeslots
security_dashboard
security_events
session_categories
speakers
speaker_types
sponsors
submission_statistics
systemsnotifications
system_settings
target_audience
templates
topic_items
users
user_activities
user_sessions
.
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
access_logs
accountmanger
banquet_summary
committee_categories
committee_members
conference_history
conference_info
conference_objectives
conference_photos
conference_subtopics
conference_topics
countries
dictionary
important_dates
login_attempts
login_log
lunch_summary
news
news_attachments
news_read_logs
news_types
paperdecision
paper_authors
password_change_log
password_history
payments
payment_summary
photo_album
presentations
presentation_guidelines
registrations
registration_fees
reviewassignments
reviewcomments
reviewcontent
reviewreminders
schedule_images
schedule_timeslots
security_dashboard
security_events
session_categories
speakers
speaker_types
sponsors
submission_statistics
systemsnotifications
system_settings
target_audience
templates
topic_items
users
user_activities
user_sessions
.
select column
select table
access_logs
accountmanger
banquet_summary
committee_categories
committee_members
conference_history
conference_info
conference_objectives
conference_photos
conference_subtopics
conference_topics
countries
dictionary
important_dates
login_attempts
login_log
lunch_summary
news
news_attachments
news_read_logs
news_types
paperdecision
paper_authors
password_change_log
password_history
payments
payment_summary
photo_album
presentations
presentation_guidelines
registrations
registration_fees
reviewassignments
reviewcomments
reviewcontent
reviewreminders
schedule_images
schedule_timeslots
security_dashboard
security_events
session_categories
speakers
speaker_types
sponsors
submission_statistics
systemsnotifications
system_settings
target_audience
templates
topic_items
users
user_activities
user_sessions
.
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
access_logs
accountmanger
banquet_summary
committee_categories
committee_members
conference_history
conference_info
conference_objectives
conference_photos
conference_subtopics
conference_topics
countries
dictionary
important_dates
login_attempts
login_log
lunch_summary
news
news_attachments
news_read_logs
news_types
paperdecision
paper_authors
password_change_log
password_history
payments
payment_summary
photo_album
presentations
presentation_guidelines
registrations
registration_fees
reviewassignments
reviewcomments
reviewcontent
reviewreminders
schedule_images
schedule_timeslots
security_dashboard
security_events
session_categories
speakers
speaker_types
sponsors
submission_statistics
systemsnotifications
system_settings
target_audience
templates
topic_items
users
user_activities
user_sessions
.
select column
select table
access_logs
accountmanger
banquet_summary
committee_categories
committee_members
conference_history
conference_info
conference_objectives
conference_photos
conference_subtopics
conference_topics
countries
dictionary
important_dates
login_attempts
login_log
lunch_summary
news
news_attachments
news_read_logs
news_types
paperdecision
paper_authors
password_change_log
password_history
payments
payment_summary
photo_album
presentations
presentation_guidelines
registrations
registration_fees
reviewassignments
reviewcomments
reviewcontent
reviewreminders
schedule_images
schedule_timeslots
security_dashboard
security_events
session_categories
speakers
speaker_types
sponsors
submission_statistics
systemsnotifications
system_settings
target_audience
templates
topic_items
users
user_activities
user_sessions
.
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
access_logs
accountmanger
banquet_summary
committee_categories
committee_members
conference_history
conference_info
conference_objectives
conference_photos
conference_subtopics
conference_topics
countries
dictionary
important_dates
login_attempts
login_log
lunch_summary
news
news_attachments
news_read_logs
news_types
paperdecision
paper_authors
password_change_log
password_history
payments
payment_summary
photo_album
presentations
presentation_guidelines
registrations
registration_fees
reviewassignments
reviewcomments
reviewcontent
reviewreminders
schedule_images
schedule_timeslots
security_dashboard
security_events
session_categories
speakers
speaker_types
sponsors
submission_statistics
systemsnotifications
system_settings
target_audience
templates
topic_items
users
user_activities
user_sessions
.
select column
select table
access_logs
accountmanger
banquet_summary
committee_categories
committee_members
conference_history
conference_info
conference_objectives
conference_photos
conference_subtopics
conference_topics
countries
dictionary
important_dates
login_attempts
login_log
lunch_summary
news
news_attachments
news_read_logs
news_types
paperdecision
paper_authors
password_change_log
password_history
payments
payment_summary
photo_album
presentations
presentation_guidelines
registrations
registration_fees
reviewassignments
reviewcomments
reviewcontent
reviewreminders
schedule_images
schedule_timeslots
security_dashboard
security_events
session_categories
speakers
speaker_types
sponsors
submission_statistics
systemsnotifications
system_settings
target_audience
templates
topic_items
users
user_activities
user_sessions
.
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
access_logs
accountmanger
banquet_summary
committee_categories
committee_members
conference_history
conference_info
conference_objectives
conference_photos
conference_subtopics
conference_topics
countries
dictionary
important_dates
login_attempts
login_log
lunch_summary
news
news_attachments
news_read_logs
news_types
paperdecision
paper_authors
password_change_log
password_history
payments
payment_summary
photo_album
presentations
presentation_guidelines
registrations
registration_fees
reviewassignments
reviewcomments
reviewcontent
reviewreminders
schedule_images
schedule_timeslots
security_dashboard
security_events
session_categories
speakers
speaker_types
sponsors
submission_statistics
systemsnotifications
system_settings
target_audience
templates
topic_items
users
user_activities
user_sessions
.
select column