Recent
`dbias_master`.`reservation_record`
`tabulation_db4`.`candidates`
`tabulation_db4`.`judges`
`debate_tabulation`.`scores`
`dbias_master`.`sharedfiles`
`tabulation_db`.`scores`
`tabulation_db4`.`scores`
`dbias_master`.`course`
`dbias_master2`.`enrolled_students`
`tabulation_db3`.`scores`
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_master2
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
student_id
id_card
id_lace
pe_uniform
school_uniform
*
id
user_id
username
role
ip_address
page_url
user_agent
login_time
last_activity
*
id
username
email
password_hash
created_at
status
role
*
id
sender_id
sender_name
receiver_id
message
is_read
created_at
*
section_id
section_name
strand_id
semester
grade_level
*
section_id
section_name
grade_level
*
strand_id
strand_name
*
id
school_year
place_birth
lrn
last_name
first_name
middle_name
grade_6_school
birthday
address
guardian_contact
guardian_name
father_name
mother_name
father_contact
mother_contact
cashier_status
account_status
tuition_fee
remaining_balance
date_enrolled
birth_certificate
form_138
good_moral
pic_1x1
pic_2x2
form_137
civil_status
sex
grade_level
section_id
student_number
student_contact
remarks
*
id
school_year
student_number
grade_10_section
section
lrn
last_name
first_name
middle_name
grade_10_school
birthday
address
student_contact
guardian_contact
guardian_name
four_ps
account_status
tuition_fee
remaining_balance
date_enrolled
referred_by
birth_certificate
form_138
good_moral
pic_1x1
pic_2x2
form_137
remarks
file_birth_certificate
file_form_138
file_good_moral
file_pic_1x1
file_pic_2x2
file_form_137
graduation_fee
remaining_graduation_balance
email_address
civil_status
sex
grade_level
semester
strand
strand_id
section_id
father_name
mother_name
referral_status
status
remark
was_transferee
total_paid
grade11_original_tuition
is_repeater
repeater_duration
curriculum_version
*
id
school_year
place_birth
lrn
last_name
first_name
middle_name
grade_6_school
birthday
address
guardian_contact
guardian_name
father_name
mother_name
father_contact
mother_contact
cashier_status
account_status
tuition_fee
remaining_balance
graduation_fee
remaining_graduation_balance
date_enrolled
birth_certificate
form_138
good_moral
pic_1x1
pic_2x2
form_137
civil_status
sex
grade_level
section_id
student_number
student_contact
*
id
school_year
student_number
grade_10_section
section
lrn
last_name
first_name
middle_name
grade_10_school
birthday
address
student_contact
guardian_contact
guardian_name
four_ps
account_status
tuition_fee
remaining_balance
date_enrolled
referred_by
birth_certificate
form_138
good_moral
pic_1x1
pic_2x2
form_137
remarks
file_birth_certificate
file_form_138
file_good_moral
file_pic_1x1
file_pic_2x2
file_form_137
graduation_fee
remaining_graduation_balance
email_address
civil_status
sex
grade_level
semester
strand
strand_id
section_id
father_name
mother_name
referral_status
status
remark
was_transferee
total_paid
grade11_original_tuition
is_repeater
repeater_duration
curriculum_version
*
id
school_year
place_birth
lrn
last_name
first_name
middle_name
grade_6_school
birthday
address
guardian_contact
guardian_name
father_name
mother_name
father_contact
mother_contact
cashier_status
account_status
tuition_fee
remaining_balance
date_enrolled
birth_certificate
form_138
good_moral
pic_1x1
pic_2x2
form_137
civil_status
sex
grade_level
section_id
student_number
student_contact
*
id
school_year
student_number
grade_10_section
section
lrn
last_name
first_name
middle_name
grade_10_school
birthday
address
student_contact
guardian_contact
guardian_name
four_ps
account_status
cashier_status
tuition_fee
remaining_balance
date_enrolled
referred_by
birth_certificate
form_138
good_moral
pic_1x1
pic_2x2
form_137
remarks
email_address
civil_status
sex
grade_level
semester
strand
strand_id
section_id
father_name
mother_name
curriculum_version
*
id
month_name
expense_date
ref_number
tin
supplier_name
particulars
address
amount
remarks
receipt_image
created_at
*
id
name
*
id
expense_id
file_name
uploaded_at
*
id
school_year
student_number
grade_10_section
section
lrn
last_name
first_name
middle_name
grade_10_school
birthday
address
student_contact
guardian_contact
guardian_name
four_ps
account_status
tuition_fee
remaining_balance
date_enrolled
referred_by
birth_certificate
form_138
good_moral
pic_1x1
pic_2x2
form_137
remarks
graduation_fee
remaining_graduation_balance
email_address
civil_status
sex
grade_level
semester
strand
strand_id
section_id
father_name
mother_name
referral_status
status
remark
was_transferee
total_paid
grade11_original_tuition
is_repeater
repeater_duration
curriculum_version
*
payment_id
student_id
or_number
amount_paid
payment_date
remarks
*
payment_id
student_id
or_number
amount_paid
payment_date
remarks
*
id
student_id
or_number
payment_date
amount
remarks
created_at
*
id
school_year
student_name
year_level
strand
semester
graduation_fee
created_at
branch
*
id
category
department
item_name
item_type
price
stock_quantity
created_at
*
id
item_id
user_id
action
quantity_changed
remarks
log_date
log_time
*
subject_id
grade_level
subject_name
*
id
user_id
username
role
ip_address
user_agent
status
attempt_time
logout_time
session_duration
failure_reason
*
id
title
school_year
target_grade_11
target_grade_12
amount
created_at
status
semester
*
id
student_misc_id
payment_date
or_number
amount_paid
remarks
created_at
*
id
school_year
student_number
grade_10_section
section
lrn
last_name
first_name
middle_name
grade_10_school
birthday
address
student_contact
guardian_contact
guardian_name
four_ps
account_status
tuition_fee
remaining_balance
date_enrolled
referred_by
birth_certificate
form_138
good_moral
pic_1x1
pic_2x2
form_137
remarks
file_birth_certificate
file_form_138
file_good_moral
file_pic_1x1
file_pic_2x2
file_form_137
graduation_fee
remaining_graduation_balance
email_address
civil_status
sex
grade_level
semester
strand
strand_id
section_id
father_name
mother_name
referral_status
status
remark
was_transferee
total_paid
grade11_original_tuition
is_repeater
repeater_duration
curriculum_version
*
id
user_id
reset_by
reset_at
*
id
referrer_name
total_referrals
total_earnings
claimed_earnings
created_at
*
id
referrer_name
student_id
amount
part
claimed_at
*
id
username
email
password_hash
created_at
status
role
*
id
or_number
invoice_date
amount
student_name
branch
created_at
*
subject_id
strand_id
grade_level
semester
subject_name
subject_type
curriculum_version
*
id
student_id
school_supplies_claimed
transportation_claimed
school_supplies_claimed_at
transportation_claimed_at
school_supplies_amount
transportation_amount
*
id
student_number
misc_fee_id
amount_due
amount_paid
status
*
payment_id
payment_date
or_number
amount_paid
remarks
student_number
school_year
grade_level
payment_for
semester
grade
*
payment_id
payment_date
or_number
amount_paid
remarks
lrn
school_year
student_number
payment_for
*
student_subject_id
enrolled_student_id
subject_name
*
id
user_id
username
user_role
log_type
module
action
record_id
ip_address
user_agent
message
details
severity
file_path
line_number
execution_time
memory_usage
timestamp
*
id
version
title
description
created_at
*
id
version
title
description
created_by
created_at
*
id
school_year
student_number
grade_10_section
section
lrn
last_name
first_name
middle_name
grade_10_school
birthday
address
student_contact
guardian_contact
guardian_name
four_ps
account_status
tuition_fee
remaining_balance
date_enrolled
referred_by
birth_certificate
form_138
good_moral
pic_1x1
pic_2x2
form_137
remarks
file_birth_certificate
file_form_138
file_good_moral
file_pic_1x1
file_pic_2x2
file_form_137
graduation_fee
remaining_graduation_balance
email_address
civil_status
sex
grade_level
semester
strand
strand_id
section_id
father_name
mother_name
referral_status
status
remark
was_transferee
total_paid
grade11_original_tuition
is_repeater
repeater_duration
curriculum_version
*
id
username
full_name
email
password_hash
created_at
last_login
status
role
department
last_active
google_auth_secret
*
id
original_id
student_id
or_number
amount
payment_date
original_remarks
void_reason
voided_by
date_voided
select table
accessories_senior
active_sessions
cashier
chat_messages
dbias_sections
dbias_sections_junior
dbias_strands
dropped_junior
dropped_students
enrolled_junior
enrolled_students
enrolling_junior
enrolling_students
expenses_audit
expense_particulars
expense_photos
graduate_senior
graduation_junior
graduation_payments
graduation_payments2
graduation_students2
inventory_items
inventory_logs
junior_subjects
login_history
miscellaneous_fees
miscellaneous_payment_history
not_graduate_senior
password_reset_logs
referrals
referral_claims
registrar
service_invoice_audit
strand_subjects
student_allowances
student_miscellaneous
student_payments
student_payments_junior
student_subjects
system_logs
system_updates
system_update_logs
transferred_out
users
voided_payments
.
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
accessories_senior
active_sessions
cashier
chat_messages
dbias_sections
dbias_sections_junior
dbias_strands
dropped_junior
dropped_students
enrolled_junior
enrolled_students
enrolling_junior
enrolling_students
expenses_audit
expense_particulars
expense_photos
graduate_senior
graduation_junior
graduation_payments
graduation_payments2
graduation_students2
inventory_items
inventory_logs
junior_subjects
login_history
miscellaneous_fees
miscellaneous_payment_history
not_graduate_senior
password_reset_logs
referrals
referral_claims
registrar
service_invoice_audit
strand_subjects
student_allowances
student_miscellaneous
student_payments
student_payments_junior
student_subjects
system_logs
system_updates
system_update_logs
transferred_out
users
voided_payments
.
select column
select table
accessories_senior
active_sessions
cashier
chat_messages
dbias_sections
dbias_sections_junior
dbias_strands
dropped_junior
dropped_students
enrolled_junior
enrolled_students
enrolling_junior
enrolling_students
expenses_audit
expense_particulars
expense_photos
graduate_senior
graduation_junior
graduation_payments
graduation_payments2
graduation_students2
inventory_items
inventory_logs
junior_subjects
login_history
miscellaneous_fees
miscellaneous_payment_history
not_graduate_senior
password_reset_logs
referrals
referral_claims
registrar
service_invoice_audit
strand_subjects
student_allowances
student_miscellaneous
student_payments
student_payments_junior
student_subjects
system_logs
system_updates
system_update_logs
transferred_out
users
voided_payments
.
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
accessories_senior
active_sessions
cashier
chat_messages
dbias_sections
dbias_sections_junior
dbias_strands
dropped_junior
dropped_students
enrolled_junior
enrolled_students
enrolling_junior
enrolling_students
expenses_audit
expense_particulars
expense_photos
graduate_senior
graduation_junior
graduation_payments
graduation_payments2
graduation_students2
inventory_items
inventory_logs
junior_subjects
login_history
miscellaneous_fees
miscellaneous_payment_history
not_graduate_senior
password_reset_logs
referrals
referral_claims
registrar
service_invoice_audit
strand_subjects
student_allowances
student_miscellaneous
student_payments
student_payments_junior
student_subjects
system_logs
system_updates
system_update_logs
transferred_out
users
voided_payments
.
select column
select table
accessories_senior
active_sessions
cashier
chat_messages
dbias_sections
dbias_sections_junior
dbias_strands
dropped_junior
dropped_students
enrolled_junior
enrolled_students
enrolling_junior
enrolling_students
expenses_audit
expense_particulars
expense_photos
graduate_senior
graduation_junior
graduation_payments
graduation_payments2
graduation_students2
inventory_items
inventory_logs
junior_subjects
login_history
miscellaneous_fees
miscellaneous_payment_history
not_graduate_senior
password_reset_logs
referrals
referral_claims
registrar
service_invoice_audit
strand_subjects
student_allowances
student_miscellaneous
student_payments
student_payments_junior
student_subjects
system_logs
system_updates
system_update_logs
transferred_out
users
voided_payments
.
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
accessories_senior
active_sessions
cashier
chat_messages
dbias_sections
dbias_sections_junior
dbias_strands
dropped_junior
dropped_students
enrolled_junior
enrolled_students
enrolling_junior
enrolling_students
expenses_audit
expense_particulars
expense_photos
graduate_senior
graduation_junior
graduation_payments
graduation_payments2
graduation_students2
inventory_items
inventory_logs
junior_subjects
login_history
miscellaneous_fees
miscellaneous_payment_history
not_graduate_senior
password_reset_logs
referrals
referral_claims
registrar
service_invoice_audit
strand_subjects
student_allowances
student_miscellaneous
student_payments
student_payments_junior
student_subjects
system_logs
system_updates
system_update_logs
transferred_out
users
voided_payments
.
select column
select table
accessories_senior
active_sessions
cashier
chat_messages
dbias_sections
dbias_sections_junior
dbias_strands
dropped_junior
dropped_students
enrolled_junior
enrolled_students
enrolling_junior
enrolling_students
expenses_audit
expense_particulars
expense_photos
graduate_senior
graduation_junior
graduation_payments
graduation_payments2
graduation_students2
inventory_items
inventory_logs
junior_subjects
login_history
miscellaneous_fees
miscellaneous_payment_history
not_graduate_senior
password_reset_logs
referrals
referral_claims
registrar
service_invoice_audit
strand_subjects
student_allowances
student_miscellaneous
student_payments
student_payments_junior
student_subjects
system_logs
system_updates
system_update_logs
transferred_out
users
voided_payments
.
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
accessories_senior
active_sessions
cashier
chat_messages
dbias_sections
dbias_sections_junior
dbias_strands
dropped_junior
dropped_students
enrolled_junior
enrolled_students
enrolling_junior
enrolling_students
expenses_audit
expense_particulars
expense_photos
graduate_senior
graduation_junior
graduation_payments
graduation_payments2
graduation_students2
inventory_items
inventory_logs
junior_subjects
login_history
miscellaneous_fees
miscellaneous_payment_history
not_graduate_senior
password_reset_logs
referrals
referral_claims
registrar
service_invoice_audit
strand_subjects
student_allowances
student_miscellaneous
student_payments
student_payments_junior
student_subjects
system_logs
system_updates
system_update_logs
transferred_out
users
voided_payments
.
select column