Recent
`information_schema`.`TABLE_CONSTRAINTS`
`mysql`.`help_topic`
`mysql`.`plugin`
`information_schema`.`PARTITIONS`
`maen-1`.`bank_accounts`
`tidaporn`.`timesheets`
`demoshop`.`categories`
`tidaporn`.`garena_redeems`
`tidaporn`.`transactions`
`numaenshop`.`timesheets`
Favorites
There are no favorite tables.
New
demoshop
game_topup
garenasql
information_schema
job_tth
maen-1
mysql
numaenshop
performance_schema
phpmyadmin
test
tidaporn
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: numaenshop
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
title
content
image_url
link
status
start_date
end_date
created_at
updated_at
*
id
user_id
name
api_key
callback_url
allowed_ips
description
is_active
last_used_at
request_count
rate_limit_per_minute
rate_limit_per_hour
rate_limit_per_day
created_at
updated_at
deleted_at
*
id
code
amount
status
start_at
expired_at
limit
max_usage_per_user
created_at
updated_at
*
id
uuid
connection
queue
payload
exception
failed_at
*
id
username
password
setup_key
status
balance
uid
created_at
updated_at
*
id
card_password
result
reference_id
account
status
trace_id
friend_username
created_at
updated_at
*
id
queue
payload
attempts
reserved_at
available_at
created_at
*
id
user_id
leave_type
start_date
end_date
total_days
reason
attachments
remarks
status
approved_by
approved_at
approval_remarks
created_at
updated_at
*
id
migration
batch
*
id
user_id
message
label
status
metadata
redirect_url
created_at
updated_at
*
id
user_id
reference
status
remarks
product_variant_id
quantity
snapshot_data
metadata
success_count
failed_count
dynasty_cost
moogold_cost
product_snapshot
variant_snapshot
order_source
api_key_id
external_reference
previous_balance
after_balance
created_at
updated_at
*
id
order_id
product_variant_id
quantity
unit_price
total_price
variant_snapshot
status
remarks
created_at
updated_at
*
id
user_id
pass_code
ref_code
metadata
created_at
updated_at
*
id
shelve_id
product_variant_id
sequence
created_at
updated_at
*
id
user_id
payment_channel_id
reference
amount
status
metadata
remarks
paid_at
expired_at
cancelled_at
created_at
updated_at
*
id
name
status
fee_percentage
custom_fee
description
config
guide_image_url
image_url
code
created_at
updated_at
*
id
tokenable_type
tokenable_id
name
token
abilities
last_used_at
expires_at
created_at
updated_at
*
id
name
description
created_at
updated_at
can_approve_overtime
can_approve_leave
approval_permissions
*
id
name
description
status
image
product_code
sequence
guide_image
discount_percentage
provider
required_server
servers
metadata
exchange_rate
created_at
updated_at
*
id
product_id
name
description
status
image
sku
price
custom_price
discounted_price
cost
custom_discount_percentage
sequence
unit
regular_rate
reseller_rate
provider_code
stock_status
created_at
updated_at
custom_reseller_price
*
id
email
password
setup_key
country_code
remaining_balance
remaining_balance_silver
status
cost
remarks
reserved_queue_id
created_worker
credentials
created_at
updated_at
*
id
user_id
order_id
razer_account_snapshot
order_response_snapshot
status
remarks
link
game
created_at
updated_at
*
id
raw_html
service
recipient
created_at
updated_at
*
id
razer_account_id
game_id
product_id
total_count
limit
status
region_id
created_at
updated_at
*
id
user_id
approved_by
requested_amount
approved_amount
status
remarks
image_url
original_filename
mime_type
file_size
qr_code
trans_ref
submitted_at
reviewed_at
metadata
created_at
updated_at
*
id
product_id
name
sequence
status
allow_select_all_to_checkout
created_at
updated_at
*
id
user_id
ref_code
otp_code
phone_number
type
is_verified
expires_at
verified_at
metadata
created_at
updated_at
*
id
provider
name
balance
exchange_rate
updated_by
created_at
updated_at
*
id
user_id
type
check_in_time
check_out_time
check_in_lat
check_in_lng
check_out_lat
check_out_lng
ot_start_time
ot_end_time
ot_status
ot_approved_by
ot_approved_at
ot_remarks
remarks
total_hours
ot_hours
status
created_at
updated_at
over_time_status
over_time_approver_id
over_time_approved_at
start_over_time
end_over_time
leave_type
leave_start_date
leave_end_date
leave_reason
leave_approver_id
leave_status
leave_approved_at
leave_rejection_reason
metadata
image_attachments
*
id
user_id
amount
type
status
reference
metadata
remarks
created_at
updated_at
*
id
name
username
password
profile_image
balance
role
status
mobile_number
sms_otp_phone
line_id
remember_token
permissions
position_id
two_factor_secret
two_factor_recovery_codes
two_factor_confirmed_at
created_at
updated_at
select table
announces
api_keys
codes
failed_jobs
garena_accounts
garena_redeems
jobs
leave_requests
migrations
notifications
orders
order_items
otps
package_shelves
payments
payment_channels
personal_access_tokens
positions
products
product_variants
razer_accounts
razer_link_orders
razer_receipt_logs
razer_task_accounts
recharge_slips
shelves
sms_otp_sessions
supply_balances
timesheets
transactions
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
announces
api_keys
codes
failed_jobs
garena_accounts
garena_redeems
jobs
leave_requests
migrations
notifications
orders
order_items
otps
package_shelves
payments
payment_channels
personal_access_tokens
positions
products
product_variants
razer_accounts
razer_link_orders
razer_receipt_logs
razer_task_accounts
recharge_slips
shelves
sms_otp_sessions
supply_balances
timesheets
transactions
users
.
select column
select table
announces
api_keys
codes
failed_jobs
garena_accounts
garena_redeems
jobs
leave_requests
migrations
notifications
orders
order_items
otps
package_shelves
payments
payment_channels
personal_access_tokens
positions
products
product_variants
razer_accounts
razer_link_orders
razer_receipt_logs
razer_task_accounts
recharge_slips
shelves
sms_otp_sessions
supply_balances
timesheets
transactions
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
announces
api_keys
codes
failed_jobs
garena_accounts
garena_redeems
jobs
leave_requests
migrations
notifications
orders
order_items
otps
package_shelves
payments
payment_channels
personal_access_tokens
positions
products
product_variants
razer_accounts
razer_link_orders
razer_receipt_logs
razer_task_accounts
recharge_slips
shelves
sms_otp_sessions
supply_balances
timesheets
transactions
users
.
select column
select table
announces
api_keys
codes
failed_jobs
garena_accounts
garena_redeems
jobs
leave_requests
migrations
notifications
orders
order_items
otps
package_shelves
payments
payment_channels
personal_access_tokens
positions
products
product_variants
razer_accounts
razer_link_orders
razer_receipt_logs
razer_task_accounts
recharge_slips
shelves
sms_otp_sessions
supply_balances
timesheets
transactions
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
announces
api_keys
codes
failed_jobs
garena_accounts
garena_redeems
jobs
leave_requests
migrations
notifications
orders
order_items
otps
package_shelves
payments
payment_channels
personal_access_tokens
positions
products
product_variants
razer_accounts
razer_link_orders
razer_receipt_logs
razer_task_accounts
recharge_slips
shelves
sms_otp_sessions
supply_balances
timesheets
transactions
users
.
select column
select table
announces
api_keys
codes
failed_jobs
garena_accounts
garena_redeems
jobs
leave_requests
migrations
notifications
orders
order_items
otps
package_shelves
payments
payment_channels
personal_access_tokens
positions
products
product_variants
razer_accounts
razer_link_orders
razer_receipt_logs
razer_task_accounts
recharge_slips
shelves
sms_otp_sessions
supply_balances
timesheets
transactions
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
announces
api_keys
codes
failed_jobs
garena_accounts
garena_redeems
jobs
leave_requests
migrations
notifications
orders
order_items
otps
package_shelves
payments
payment_channels
personal_access_tokens
positions
products
product_variants
razer_accounts
razer_link_orders
razer_receipt_logs
razer_task_accounts
recharge_slips
shelves
sms_otp_sessions
supply_balances
timesheets
transactions
users
.
select column