Recent
`saqrsoftwaredata`.`shared_expenses`
`phpmyadmin`.`pma__relation`
`schema`.`blogs`
`schema`.`users`
`truckingbusiness`.`client_share_accounts`
`sacretheartschool`.`salaries`
`truckingbusiness`.`city_exchange_salary`
`saqrsoftwaredata`.`time_entries`
`ums_garage`.`income_categories`
`ums_garage`.`job_card_assignments`
Favorites
There are no favorite tables.
New
918carcare
alnakeel
dailyplanet
fitness_studio
garagesoftware
gym_db
information_schema
invoicepro
majestic_pump
mysql
performance_schema
phpmyadmin
revline_garage
sacretheartschool
saqrsoftwaredata
saqr_watcher
schema
test
truckingbusiness
ums_garage
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: fitness_studio
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
member_id
member_name
coach_id
coach_name
class_id
class_instance_id
class_name
batch_id
batch_name
plan_id
plan_name
timestamp
checked_in_by
manual_override_reason
*
id
name
timing
time_slot
start_time
end_time
capacity
plan_id
plan_name
class_ids
*
id
batch_id
member_id
added_at
*
id
class_id
batch_id
day_of_week
created_at
*
id
rule_id
class_date
start_time
end_time
name
type
location
batch_id
batch_name
coach_id
coach_name
capacity
enrolled_members
attendance_records
current_attendance
status
locked_at
created_at
*
id
member_id
reason
outcome_achieved
referral_potential
follow_up_date
created_at
*
id
member_id
trainer_id
milestone_type
achieved_at
metadata
*
id
member_id
program_id
assigned_at
*
id
member_id
recorded_at
bodyweight_kg
measurements
photo_urls
energy_recovery_notes
subjective_feedback
created_at
*
coach_id
coach_name
coach_teaches
coach_phone
coach_emergency_contact
total_checkins
today_checkins
last_7_days
last_30_days
last_checkin
*
id
member_id
coach_id
note
type
created_at
*
id
member_id
accepted_at
ip_or_device
*
id
credit_note_number
invoice_id
refund_id
member_id
member_name
amount
created_at
*
id
member_id
type
amount_or_sessions
reason
created_by
created_at
*
id
amount
date
category
description
created_at
studio_id
trainer_id
*
id
amount
date
category
description
payment_id
created_at
studio_id
trainer_id
*
id
invoice_number
invoice_date
member_id
member_name
plan_name
plan_duration
total_amount
amount_paid
tax_amount
gst_split
payment_mode
payment_reference_id
status
delivery_status
sent_at
payment_id
studio_name
studio_address
gstin
created_at
*
invoice_id
invoice_number
invoice_date
member_id
member_name
plan_name
plan_duration
total_amount
invoice_amount_paid
balance_due
default_payment_mode
invoice_status
delivery_status
sent_at
created_at
payment_status
payment_count
total_payments_recorded
*
id
name
mobile
source
training_type
interest_type
preferred_frequency
preferred_batch_timing
trial_interest
notes
pipeline_status
lost_reason
follow_up_at
created_at
updated_at
member_id
trainer_id
studio_id
*
id
full_name
phone
email
membership_type
batch_timing
start_date
expiry_date
status
attendance_count
total_sessions
plan_id
plan_name
plan_duration
batch_id
backup_batch_id
goals
risk_flags
notes
injuries
is_corporate_gst
created_at
lead_id
studio_id
trainer_id
*
id
name
duration
duration_days
sessions_per_week
sessions_per_month
freeze_rules
transfer_rules
upgrade_downgrade_logic
sessions_total
no_show_penalty_sessions
no_show_penalty_notes
*
member_id
medical_history
injuries
training_experience
goals
availability
emergency_contact
consent_signed
signed_at
signature
*
member_id
full_name
member_status
expiry_date
days_until_expiry
attendance_count
total_sessions
completion_percentage
total_plans
active_plans
expired_plans
*
id
member_id
plan_id
plan_name
sessions_total
sessions_attended
status
start_date
expiry_date
created_at
updated_at
*
member_plan_id
member_id
member_name
plan_id
plan_name
sessions_total
sessions_attended
sessions_remaining
plan_status
start_date
expiry_date
calculated_status
*
id
member_id
member_name
class_id
class_name
batch_id
plan_id
date
recorded_at
sessions_penalty_applied
*
member_id
intake_reviewed
membership_assigned
batch_assigned
first_class_attended
coach_intro_completed
completed_at
*
id
member_id
member_name
amount
payment_date
payment_mode
invoice_number
invoice_id
due_date
notes
status
*
id
member_id
member_name
amount
payment_date
payment_mode
invoice_number
invoice_id
status
notes
pending_amount
linked_invoice_number
delivery_status
*
id
type
source_id
amount
entry_date
category
description
created_at
*
id
trainer_id
name
phase
created_at
updated_at
*
id
program_id
name
sets_reps
sort_order
created_at
*
id
payment_id
member_id
member_name
amount
reason
credit_note_id
created_at
*
name
value
*
id
client_id
trainer_id
session_date
session_time
status
session_type
coach_notes
cancel_reason
created_at
updated_at
*
id
name
slug
address
created_at
updated_at
*
id
name
type
day_of_week
time_slot
coach_id
coach_name
capacity
current_attendance
batch_id
plan_id
*
id
type
title
member_id
member_name
class_id
class_name
batch_name
deadline
severity
status
metadata
created_at
resolved_at
*
id
lead_id
lead_name
trial_date
class_id
class_name
coach_id
coach_name
attended
outcome
follow_up_deadline
conversion_owner
created_at
*
id
email
password_hash
name
role
phone
member_id
coach_teaches
coach_phone
coach_emergency_contact
coach_sessions
created_at
studio_id
select table
attendance
batches
batch_members
class_batches
class_instances
client_exit_log
client_milestones
client_programs
client_progress
coach_attendance_summary
coach_notes
consent_records
credit_notes
discounts
expenses
incomes
invoices
invoice_payment_summary
leads
members
membership_plans
member_intakes
member_overall_status_view
member_plans
member_plan_status_view
no_shows
onboarding_checklists
payments
payment_with_pending
pnl_entries
programs
program_exercises
refunds
sequences
session_log
studios
studio_classes
studio_tasks
trials
users
.
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
attendance
batches
batch_members
class_batches
class_instances
client_exit_log
client_milestones
client_programs
client_progress
coach_attendance_summary
coach_notes
consent_records
credit_notes
discounts
expenses
incomes
invoices
invoice_payment_summary
leads
members
membership_plans
member_intakes
member_overall_status_view
member_plans
member_plan_status_view
no_shows
onboarding_checklists
payments
payment_with_pending
pnl_entries
programs
program_exercises
refunds
sequences
session_log
studios
studio_classes
studio_tasks
trials
users
.
select column
select table
attendance
batches
batch_members
class_batches
class_instances
client_exit_log
client_milestones
client_programs
client_progress
coach_attendance_summary
coach_notes
consent_records
credit_notes
discounts
expenses
incomes
invoices
invoice_payment_summary
leads
members
membership_plans
member_intakes
member_overall_status_view
member_plans
member_plan_status_view
no_shows
onboarding_checklists
payments
payment_with_pending
pnl_entries
programs
program_exercises
refunds
sequences
session_log
studios
studio_classes
studio_tasks
trials
users
.
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
attendance
batches
batch_members
class_batches
class_instances
client_exit_log
client_milestones
client_programs
client_progress
coach_attendance_summary
coach_notes
consent_records
credit_notes
discounts
expenses
incomes
invoices
invoice_payment_summary
leads
members
membership_plans
member_intakes
member_overall_status_view
member_plans
member_plan_status_view
no_shows
onboarding_checklists
payments
payment_with_pending
pnl_entries
programs
program_exercises
refunds
sequences
session_log
studios
studio_classes
studio_tasks
trials
users
.
select column
select table
attendance
batches
batch_members
class_batches
class_instances
client_exit_log
client_milestones
client_programs
client_progress
coach_attendance_summary
coach_notes
consent_records
credit_notes
discounts
expenses
incomes
invoices
invoice_payment_summary
leads
members
membership_plans
member_intakes
member_overall_status_view
member_plans
member_plan_status_view
no_shows
onboarding_checklists
payments
payment_with_pending
pnl_entries
programs
program_exercises
refunds
sequences
session_log
studios
studio_classes
studio_tasks
trials
users
.
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
attendance
batches
batch_members
class_batches
class_instances
client_exit_log
client_milestones
client_programs
client_progress
coach_attendance_summary
coach_notes
consent_records
credit_notes
discounts
expenses
incomes
invoices
invoice_payment_summary
leads
members
membership_plans
member_intakes
member_overall_status_view
member_plans
member_plan_status_view
no_shows
onboarding_checklists
payments
payment_with_pending
pnl_entries
programs
program_exercises
refunds
sequences
session_log
studios
studio_classes
studio_tasks
trials
users
.
select column
select table
attendance
batches
batch_members
class_batches
class_instances
client_exit_log
client_milestones
client_programs
client_progress
coach_attendance_summary
coach_notes
consent_records
credit_notes
discounts
expenses
incomes
invoices
invoice_payment_summary
leads
members
membership_plans
member_intakes
member_overall_status_view
member_plans
member_plan_status_view
no_shows
onboarding_checklists
payments
payment_with_pending
pnl_entries
programs
program_exercises
refunds
sequences
session_log
studios
studio_classes
studio_tasks
trials
users
.
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
attendance
batches
batch_members
class_batches
class_instances
client_exit_log
client_milestones
client_programs
client_progress
coach_attendance_summary
coach_notes
consent_records
credit_notes
discounts
expenses
incomes
invoices
invoice_payment_summary
leads
members
membership_plans
member_intakes
member_overall_status_view
member_plans
member_plan_status_view
no_shows
onboarding_checklists
payments
payment_with_pending
pnl_entries
programs
program_exercises
refunds
sequences
session_log
studios
studio_classes
studio_tasks
trials
users
.
select column