Recent
`dbias_master`.`cometchat_games`
`mysql`.`slow_log`
`dbias_master2`.`enrolling_junior`
`information_schema`.`KEY_COLUMN_USAGE`
`phpmyadmin`.`pma__favorite`
`phpmyadmin`.`pma__savedsearches`
`dbias_master2`.`expense_particulars`
`dbias_master2`.`accessories_senior`
`phpmyadmin`.`pma__designer_settings`
`teacher_scheduler_db`.`teacher_subjects`
Favorites
There are no favorite tables.
New
campushub_docs
cashier_activity_logs
cgc_mailer
citi_global_inventory
dbias
dbias_master
dbias_master2
debate_tabulation
hr_portal_db
information_schema
kanta1
kanta2
laptop_borrowing_system
mis_bsais
mysql
performance_schema
phpmyadmin
sayaw
shspayment
shs_activity_logs
tabulation
tabulation_db
tabulation_db2
tabulation_db3
tabulation_db4
teacher_scheduler_db
test
tradition
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: dbias_master
Table: cometchat_games
Browse
Structure
(current)
SQL
Search
Insert
Export
Import
Privileges
Operations
Tracking
Triggers
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
Table structure
Relation view
Foreign key constraints
Actions
Constraint properties
Column
Creating a foreign key over a non-indexed column would automatically create an index on it. Alternatively, you can define an index below, before creating the foreign key.
Foreign key constraint (INNODB)
Database
Table
Column
ON DELETE
CASCADE
SET NULL
NO ACTION
RESTRICT
ON UPDATE
CASCADE
SET NULL
NO ACTION
RESTRICT
games
highscorelist
recentlist
score
userid
+ Add column
campushub_docs
cashier_activity_logs
cgc_mailer
citi_global_inventory
dbias_master
dbias_master2
debate_tabulation
hr_portal_db
information_schema
kanta1
kanta2
laptop_borrowing_system
mis_bsais
mysql
performance_schema
phpmyadmin
sayaw
shspayment
shs_activity_logs
tabulation_db
tabulation_db2
tabulation_db3
tabulation_db4
teacher_scheduler_db
test
tradition
acccapayment
acccashadvance
accempprofile
accemprate
accempsavings
accempsavingshistory
accpayroll
accsssloan
accsssloanpayment
activitylogs
calendarschool
cashiernote
chattech
chattechmsg
cometchat
cometchat_announcements
cometchat_apehistory
cometchat_block
cometchat_chatroommessages
cometchat_chatrooms
cometchat_chatrooms_users
cometchat_comethistory
cometchat_games
cometchat_guests
cometchat_messages_old
cometchat_status
cometchat_videochatsessions
course
curriculum
curriculum(copy)
dashboard_rules
discounts
earnerassessment
empprofile
enrolled
enrolled(copy)
enrolled_delete
enrolled_drop
file_name
gradcurriculum
gradcurriculum(copy)
gradenlistment
gradenlistment(copy)
grade_checker
grade_delete
grade_segregation
grade_segregation(copy)
grade_segregation_test
gradsection_subject
grad_grade_segregation
guidancelogin
high_curri
high_enrolled
high_section
hs_grade
jhs_curri
jsothers
js_section
junior_enrolled
libaccession
libinout
librecords
login_personel
logs
mytheme
otherscollege
page_news
payment
payment_enrolled
permit_receives
requirements
reservationhistory
reservation_record
reservation_req
rules_table
school_act
section
sectiongrad
section_subject
section_subject(copy)
sharedfiles
students_shs
student_attachments
student_case
student_record
student_record(copy)
student_violations
studen_remove
systemversion
tblched
tblhenrolled
tblshenrolledlist
tbltesda
test
timeinandout
upaid_cash
violation_types
wifi_vouchers
+ Add constraint
Internal relationships
Internal relationships
Column
Internal relation
An internal relation is not necessary when a corresponding FOREIGN KEY relation exists.
userid
campushub_docs
cashier_activity_logs
cgc_mailer
citi_global_inventory
dbias_master
dbias_master2
debate_tabulation
hr_portal_db
information_schema
kanta1
kanta2
laptop_borrowing_system
mis_bsais
mysql
performance_schema
phpmyadmin
sayaw
shspayment
shs_activity_logs
tabulation_db
tabulation_db2
tabulation_db3
tabulation_db4
teacher_scheduler_db
test
tradition
acccapayment
acccashadvance
accempprofile
accemprate
accempsavings
accempsavingshistory
accpayroll
accsssloan
accsssloanpayment
activitylogs
calendarschool
cashiernote
chattech
chattechmsg
cometchat
cometchat_announcements
cometchat_apehistory
cometchat_block
cometchat_chatroommessages
cometchat_chatrooms
cometchat_chatrooms_users
cometchat_comethistory
cometchat_games
cometchat_guests
cometchat_messages_old
cometchat_status
cometchat_videochatsessions
course
curriculum
curriculum(copy)
dashboard_rules
discounts
earnerassessment
empprofile
enrolled
enrolled(copy)
enrolled_delete
enrolled_drop
file_name
gradcurriculum
gradcurriculum(copy)
gradenlistment
gradenlistment(copy)
grade_checker
grade_delete
grade_segregation
grade_segregation(copy)
grade_segregation_test
gradsection_subject
grad_grade_segregation
guidancelogin
high_curri
high_enrolled
high_section
hs_grade
jhs_curri
jsothers
js_section
junior_enrolled
libaccession
libinout
librecords
login_personel
logs
mytheme
otherscollege
page_news
payment
payment_enrolled
permit_receives
requirements
reservationhistory
reservation_record
reservation_req
rules_table
school_act
section
sectiongrad
section_subject
section_subject(copy)
sharedfiles
students_shs
student_attachments
student_case
student_record
student_record(copy)
student_violations
studen_remove
systemversion
tblched
tblhenrolled
tblshenrolledlist
tbltesda
test
timeinandout
upaid_cash
violation_types
wifi_vouchers
score
campushub_docs
cashier_activity_logs
cgc_mailer
citi_global_inventory
dbias_master
dbias_master2
debate_tabulation
hr_portal_db
information_schema
kanta1
kanta2
laptop_borrowing_system
mis_bsais
mysql
performance_schema
phpmyadmin
sayaw
shspayment
shs_activity_logs
tabulation_db
tabulation_db2
tabulation_db3
tabulation_db4
teacher_scheduler_db
test
tradition
acccapayment
acccashadvance
accempprofile
accemprate
accempsavings
accempsavingshistory
accpayroll
accsssloan
accsssloanpayment
activitylogs
calendarschool
cashiernote
chattech
chattechmsg
cometchat
cometchat_announcements
cometchat_apehistory
cometchat_block
cometchat_chatroommessages
cometchat_chatrooms
cometchat_chatrooms_users
cometchat_comethistory
cometchat_games
cometchat_guests
cometchat_messages_old
cometchat_status
cometchat_videochatsessions
course
curriculum
curriculum(copy)
dashboard_rules
discounts
earnerassessment
empprofile
enrolled
enrolled(copy)
enrolled_delete
enrolled_drop
file_name
gradcurriculum
gradcurriculum(copy)
gradenlistment
gradenlistment(copy)
grade_checker
grade_delete
grade_segregation
grade_segregation(copy)
grade_segregation_test
gradsection_subject
grad_grade_segregation
guidancelogin
high_curri
high_enrolled
high_section
hs_grade
jhs_curri
jsothers
js_section
junior_enrolled
libaccession
libinout
librecords
login_personel
logs
mytheme
otherscollege
page_news
payment
payment_enrolled
permit_receives
requirements
reservationhistory
reservation_record
reservation_req
rules_table
school_act
section
sectiongrad
section_subject
section_subject(copy)
sharedfiles
students_shs
student_attachments
student_case
student_record
student_record(copy)
student_violations
studen_remove
systemversion
tblched
tblhenrolled
tblshenrolledlist
tbltesda
test
timeinandout
upaid_cash
violation_types
wifi_vouchers
games
campushub_docs
cashier_activity_logs
cgc_mailer
citi_global_inventory
dbias_master
dbias_master2
debate_tabulation
hr_portal_db
information_schema
kanta1
kanta2
laptop_borrowing_system
mis_bsais
mysql
performance_schema
phpmyadmin
sayaw
shspayment
shs_activity_logs
tabulation_db
tabulation_db2
tabulation_db3
tabulation_db4
teacher_scheduler_db
test
tradition
acccapayment
acccashadvance
accempprofile
accemprate
accempsavings
accempsavingshistory
accpayroll
accsssloan
accsssloanpayment
activitylogs
calendarschool
cashiernote
chattech
chattechmsg
cometchat
cometchat_announcements
cometchat_apehistory
cometchat_block
cometchat_chatroommessages
cometchat_chatrooms
cometchat_chatrooms_users
cometchat_comethistory
cometchat_games
cometchat_guests
cometchat_messages_old
cometchat_status
cometchat_videochatsessions
course
curriculum
curriculum(copy)
dashboard_rules
discounts
earnerassessment
empprofile
enrolled
enrolled(copy)
enrolled_delete
enrolled_drop
file_name
gradcurriculum
gradcurriculum(copy)
gradenlistment
gradenlistment(copy)
grade_checker
grade_delete
grade_segregation
grade_segregation(copy)
grade_segregation_test
gradsection_subject
grad_grade_segregation
guidancelogin
high_curri
high_enrolled
high_section
hs_grade
jhs_curri
jsothers
js_section
junior_enrolled
libaccession
libinout
librecords
login_personel
logs
mytheme
otherscollege
page_news
payment
payment_enrolled
permit_receives
requirements
reservationhistory
reservation_record
reservation_req
rules_table
school_act
section
sectiongrad
section_subject
section_subject(copy)
sharedfiles
students_shs
student_attachments
student_case
student_record
student_record(copy)
student_violations
studen_remove
systemversion
tblched
tblhenrolled
tblshenrolledlist
tbltesda
test
timeinandout
upaid_cash
violation_types
wifi_vouchers
recentlist
campushub_docs
cashier_activity_logs
cgc_mailer
citi_global_inventory
dbias_master
dbias_master2
debate_tabulation
hr_portal_db
information_schema
kanta1
kanta2
laptop_borrowing_system
mis_bsais
mysql
performance_schema
phpmyadmin
sayaw
shspayment
shs_activity_logs
tabulation_db
tabulation_db2
tabulation_db3
tabulation_db4
teacher_scheduler_db
test
tradition
acccapayment
acccashadvance
accempprofile
accemprate
accempsavings
accempsavingshistory
accpayroll
accsssloan
accsssloanpayment
activitylogs
calendarschool
cashiernote
chattech
chattechmsg
cometchat
cometchat_announcements
cometchat_apehistory
cometchat_block
cometchat_chatroommessages
cometchat_chatrooms
cometchat_chatrooms_users
cometchat_comethistory
cometchat_games
cometchat_guests
cometchat_messages_old
cometchat_status
cometchat_videochatsessions
course
curriculum
curriculum(copy)
dashboard_rules
discounts
earnerassessment
empprofile
enrolled
enrolled(copy)
enrolled_delete
enrolled_drop
file_name
gradcurriculum
gradcurriculum(copy)
gradenlistment
gradenlistment(copy)
grade_checker
grade_delete
grade_segregation
grade_segregation(copy)
grade_segregation_test
gradsection_subject
grad_grade_segregation
guidancelogin
high_curri
high_enrolled
high_section
hs_grade
jhs_curri
jsothers
js_section
junior_enrolled
libaccession
libinout
librecords
login_personel
logs
mytheme
otherscollege
page_news
payment
payment_enrolled
permit_receives
requirements
reservationhistory
reservation_record
reservation_req
rules_table
school_act
section
sectiongrad
section_subject
section_subject(copy)
sharedfiles
students_shs
student_attachments
student_case
student_record
student_record(copy)
student_violations
studen_remove
systemversion
tblched
tblhenrolled
tblshenrolledlist
tbltesda
test
timeinandout
upaid_cash
violation_types
wifi_vouchers
highscorelist
campushub_docs
cashier_activity_logs
cgc_mailer
citi_global_inventory
dbias_master
dbias_master2
debate_tabulation
hr_portal_db
information_schema
kanta1
kanta2
laptop_borrowing_system
mis_bsais
mysql
performance_schema
phpmyadmin
sayaw
shspayment
shs_activity_logs
tabulation_db
tabulation_db2
tabulation_db3
tabulation_db4
teacher_scheduler_db
test
tradition
acccapayment
acccashadvance
accempprofile
accemprate
accempsavings
accempsavingshistory
accpayroll
accsssloan
accsssloanpayment
activitylogs
calendarschool
cashiernote
chattech
chattechmsg
cometchat
cometchat_announcements
cometchat_apehistory
cometchat_block
cometchat_chatroommessages
cometchat_chatrooms
cometchat_chatrooms_users
cometchat_comethistory
cometchat_games
cometchat_guests
cometchat_messages_old
cometchat_status
cometchat_videochatsessions
course
curriculum
curriculum(copy)
dashboard_rules
discounts
earnerassessment
empprofile
enrolled
enrolled(copy)
enrolled_delete
enrolled_drop
file_name
gradcurriculum
gradcurriculum(copy)
gradenlistment
gradenlistment(copy)
grade_checker
grade_delete
grade_segregation
grade_segregation(copy)
grade_segregation_test
gradsection_subject
grad_grade_segregation
guidancelogin
high_curri
high_enrolled
high_section
hs_grade
jhs_curri
jsothers
js_section
junior_enrolled
libaccession
libinout
librecords
login_personel
logs
mytheme
otherscollege
page_news
payment
payment_enrolled
permit_receives
requirements
reservationhistory
reservation_record
reservation_req
rules_table
school_act
section
sectiongrad
section_subject
section_subject(copy)
sharedfiles
students_shs
student_attachments
student_case
student_record
student_record(copy)
student_violations
studen_remove
systemversion
tblched
tblhenrolled
tblshenrolledlist
tbltesda
test
timeinandout
upaid_cash
violation_types
wifi_vouchers
Choose column to display:
---
userid
score
games
recentlist
highscorelist
Loading