Recent
`mybill_v2`.`btw_support_messages`
`bantiwa999_db`.`live_streams`
`mybill_v2`.`btw_bonus_rules`
`bill_db`.`products`
`mybill_v2`.`btw_finance_admin_sessions`
`mybill_v2`.`btw_game_terms_draft`
`mybill_v2`.`member_passkey_users`
`mysql`.`transaction_registry`
`bill_db`.`quotations`
`information_schema`.`INNODB_SYS_DATAFILES`
Favorites
There are no favorite tables.
New
bantiwa999_db
bill_db
information_schema
mybill
mybill
mybill_v2
mycloud_db
mysql
performance_schema
phpmyadmin
prison_db_8080
test
tiktok_ai_affiliate
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: mybill
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
event_type
customer_user_id
customer_name
customer_phone
bill_id
lottery_type
lottery_set
item_count
total_amount
title
message
target_url
created_at
is_read
*
id
user_name
user_role
endpoint
endpoint_hash
p256dh
auth
user_agent
device_label
is_active
last_seen_at
created_at
updated_at
*
id
player_id
round_no
side
amount
status
payout
created_at
settled_at
*
id
player_key
display_name
credit
created_at
updated_at
*
id
round_no
player_cards
banker_cards
player_score
banker_score
winner
created_at
*
id
round_no
phase
phase_started_at
betting_seconds
result_seconds
player_cards
banker_cards
player_score
banker_score
winner
updated_at
*
id
user_id
round_no
side
amount
status
payout
created_at
settled_at
*
id
customer
customer_user_id
customer_phone
lottery_type
lottery_set
items
total
date
time
created_by
created_at
*
id
bill_ref_id
bill_id
number
type
amount
*
id
customer_name
lottery_type
lottery_set
transaction_type
amount
transaction_date
note
created_by
created_at
*
id
customer_user_id
bank_code
bank_name
account_name
account_number
is_default
status
verified_at
verified_by
created_at
updated_at
*
id
customer_user_id
phone
event_type
ip_address
user_agent
created_at
*
id
customer_user_id
phone
purpose
provider
provider_token
provider_refno
otp_hash
expires_at
attempts
max_attempts
sent_at
verified_at
used_at
request_ip
created_at
*
id
customer_name
lottery_type
lottery_set
payment_status
updated_at
*
id
full_name
phone
profile_image
password_hash
phone_verified_at
status
last_login_at
created_at
updated_at
*
id
customer_user_id
balance_available
balance_locked
currency
status
version_no
created_at
updated_at
*
id
draw_date
lottery_type
lottery_set
win_3_top
win_2_bottom
created_by
created_at
settled_at
*
id
draw_date
lottery_type
lottery_set
rate_2_full
rate_2_half
rate_3_straight
rate_3_tod
rate_4_straight
created_by
created_at
updated_at
*
id
draw_date
lottery_type
lottery_set
number_kind
number
created_by
created_at
*
id
draw_result_id
bill_id
item_index
wallet_user_id
customer_user_id
customer_name
number
bet_type
stake
rate_used
payout
is_half_pay
created_at
*
id
bill_id
customer_user_id
wallet_user_id
payout_amount
lottery_type
lottery_set
draw_date
details_json
created_at
*
id
lottery_type
lottery_set
draw_date
raw_result
first_prize
three_top
two_bottom
source_name
source_url
fetched_at
*
id
lottery_type
lottery_set
sale_date
status
open_time
close_time
note
updated_by
created_at
updated_at
*
id
lottery_type
lottery_set
display_name
schedule_mode
days_of_month
weekdays
open_time
close_time
timezone
is_enabled
updated_by
created_at
updated_at
*
id
draw_date
lottery_type
lottery_set
snapshot_json
created_by
created_at
*
id
user_id
order_token
amount
status
bill_id
created_at
finalized_at
cancelled_at
*
id
actor
event
member_id
details
created_at
*
id
member_id
event_key
lottery_type
lottery_set
draw_date
closes_at
items_json
quote_hash
gross_cents
discount_bps
discount_cents
net_cents
status
method
confirmed_at
expires_at
bill_id
verification_json
created_at
*
event_key
member_line
payload
status
attempts
last_error
created_at
*
id
line_user_id
display_name
full_name
phone
bank_name
bank_account
ledger_name
credit_approved
credit_limit_cents
discount_bps
active
selected_type
selected_set
current_draft
version
created_at
updated_at
*
id
event_key
line_user_id
payload
retry_key
status
attempts
last_error
created_at
*
id
draft_id
trans_ref
image_sha
storage_name
created_at
*
request_id
staff_id
payload_hash
bill_id
transaction_id
total_cents
paid_cents
due_cents
payment_mode
response_json
created_at
*
id
draw_date
lottery_type
lottery_set
result_json
staff_id
staff_name
created_at
*
id
user_id
event
details
created_at
*
id
user_id
credential_hash
credential_id
public_key
sign_count
label
password_tag
created_at
last_used_at
revoked_at
*
bucket_hash
window_id
hits
*
user_id
user_handle
*
id
provider
event_id
event_type
signature_valid
processing_status
related_type
related_id
http_headers
payload
error_message
received_at
processed_at
*
id
is_enabled
enabled_at
expires_at
enabled_by
updated_at
*
id
user_id
permission_key
allowed
created_at
updated_at
*
id
username
password
name
role
created_at
user_id
status
*
id
customer_user_id
admin_user
action_type
reference_type
reference_id
old_value
new_value
ip_address
user_agent
created_at
*
id
user_id
wallet_type
balance
updated_at
*
id
user_id
from_wallet
to_wallet
amount
transaction_type
note
created_at
*
id
customer_user_id
user_key
display_name
created_at
*
id
topup_enabled
withdrawal_enabled
min_topup
max_topup
min_withdrawal
max_withdrawal
max_withdrawals_per_day
withdrawal_requires_otp
withdrawal_requires_verified_bank
updated_by
updated_at
*
id
topup_no
customer_user_id
wallet_id
amount
fee_amount
net_amount
payment_method
provider
provider_transaction_id
provider_reference
qr_payload
qr_expires_at
status
paid_at
expired_at
failed_at
request_ip
user_agent
created_at
updated_at
*
id
wallet_id
customer_user_id
transaction_no
entry_type
direction
amount
available_before
available_after
locked_before
locked_after
reference_type
reference_id
external_ref
note
created_by_type
created_by
created_at
*
id
customer_user_id
purpose
reference_id
otp_hash
expires_at
attempts
max_attempts
verified_at
used_at
request_ip
created_at
*
id
withdrawal_no
customer_user_id
wallet_id
bank_account_id
amount
fee_amount
net_amount
status
customer_note
admin_note
approved_by
approved_at
payout_provider
payout_transaction_id
payout_reference
paid_at
rejected_at
cancelled_at
failed_at
request_ip
user_agent
created_at
updated_at
select table
admin_notifications
admin_push_subscriptions
baccarat_demo_bets
baccarat_demo_players
baccarat_demo_rounds
baccarat_demo_state
baccarat_wallet_demo_bets
bills
bill_items
customer_account_transactions
customer_bank_accounts
customer_login_audit
customer_otp
customer_payment_status
customer_users
customer_wallets
lottery_draw_results_demo
lottery_draw_settings
lottery_half_numbers
lottery_prize_payouts_demo
lottery_prize_payouts_demo_v2
lottery_result_cache
lottery_sale_overrides
lottery_sale_schedules
lottery_settings_audit
lottery_wallet_demo_orders
ml_audit
ml_drafts
ml_events
ml_members
ml_outbox
ml_receipts
mybill_bill_settlements
mybill_manual_result_entries
mybill_passkey_audit
mybill_passkey_credentials
mybill_passkey_limits
mybill_passkey_users
payment_webhook_events
project_demo_mode
staff_permissions
users
wallet_audit_log
wallet_demo_accounts
wallet_demo_transactions
wallet_demo_users
wallet_settings
wallet_topup_requests
wallet_transactions
wallet_transaction_otp
wallet_withdrawal_requests
.
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
admin_notifications
admin_push_subscriptions
baccarat_demo_bets
baccarat_demo_players
baccarat_demo_rounds
baccarat_demo_state
baccarat_wallet_demo_bets
bills
bill_items
customer_account_transactions
customer_bank_accounts
customer_login_audit
customer_otp
customer_payment_status
customer_users
customer_wallets
lottery_draw_results_demo
lottery_draw_settings
lottery_half_numbers
lottery_prize_payouts_demo
lottery_prize_payouts_demo_v2
lottery_result_cache
lottery_sale_overrides
lottery_sale_schedules
lottery_settings_audit
lottery_wallet_demo_orders
ml_audit
ml_drafts
ml_events
ml_members
ml_outbox
ml_receipts
mybill_bill_settlements
mybill_manual_result_entries
mybill_passkey_audit
mybill_passkey_credentials
mybill_passkey_limits
mybill_passkey_users
payment_webhook_events
project_demo_mode
staff_permissions
users
wallet_audit_log
wallet_demo_accounts
wallet_demo_transactions
wallet_demo_users
wallet_settings
wallet_topup_requests
wallet_transactions
wallet_transaction_otp
wallet_withdrawal_requests
.
select column
select table
admin_notifications
admin_push_subscriptions
baccarat_demo_bets
baccarat_demo_players
baccarat_demo_rounds
baccarat_demo_state
baccarat_wallet_demo_bets
bills
bill_items
customer_account_transactions
customer_bank_accounts
customer_login_audit
customer_otp
customer_payment_status
customer_users
customer_wallets
lottery_draw_results_demo
lottery_draw_settings
lottery_half_numbers
lottery_prize_payouts_demo
lottery_prize_payouts_demo_v2
lottery_result_cache
lottery_sale_overrides
lottery_sale_schedules
lottery_settings_audit
lottery_wallet_demo_orders
ml_audit
ml_drafts
ml_events
ml_members
ml_outbox
ml_receipts
mybill_bill_settlements
mybill_manual_result_entries
mybill_passkey_audit
mybill_passkey_credentials
mybill_passkey_limits
mybill_passkey_users
payment_webhook_events
project_demo_mode
staff_permissions
users
wallet_audit_log
wallet_demo_accounts
wallet_demo_transactions
wallet_demo_users
wallet_settings
wallet_topup_requests
wallet_transactions
wallet_transaction_otp
wallet_withdrawal_requests
.
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
admin_notifications
admin_push_subscriptions
baccarat_demo_bets
baccarat_demo_players
baccarat_demo_rounds
baccarat_demo_state
baccarat_wallet_demo_bets
bills
bill_items
customer_account_transactions
customer_bank_accounts
customer_login_audit
customer_otp
customer_payment_status
customer_users
customer_wallets
lottery_draw_results_demo
lottery_draw_settings
lottery_half_numbers
lottery_prize_payouts_demo
lottery_prize_payouts_demo_v2
lottery_result_cache
lottery_sale_overrides
lottery_sale_schedules
lottery_settings_audit
lottery_wallet_demo_orders
ml_audit
ml_drafts
ml_events
ml_members
ml_outbox
ml_receipts
mybill_bill_settlements
mybill_manual_result_entries
mybill_passkey_audit
mybill_passkey_credentials
mybill_passkey_limits
mybill_passkey_users
payment_webhook_events
project_demo_mode
staff_permissions
users
wallet_audit_log
wallet_demo_accounts
wallet_demo_transactions
wallet_demo_users
wallet_settings
wallet_topup_requests
wallet_transactions
wallet_transaction_otp
wallet_withdrawal_requests
.
select column
select table
admin_notifications
admin_push_subscriptions
baccarat_demo_bets
baccarat_demo_players
baccarat_demo_rounds
baccarat_demo_state
baccarat_wallet_demo_bets
bills
bill_items
customer_account_transactions
customer_bank_accounts
customer_login_audit
customer_otp
customer_payment_status
customer_users
customer_wallets
lottery_draw_results_demo
lottery_draw_settings
lottery_half_numbers
lottery_prize_payouts_demo
lottery_prize_payouts_demo_v2
lottery_result_cache
lottery_sale_overrides
lottery_sale_schedules
lottery_settings_audit
lottery_wallet_demo_orders
ml_audit
ml_drafts
ml_events
ml_members
ml_outbox
ml_receipts
mybill_bill_settlements
mybill_manual_result_entries
mybill_passkey_audit
mybill_passkey_credentials
mybill_passkey_limits
mybill_passkey_users
payment_webhook_events
project_demo_mode
staff_permissions
users
wallet_audit_log
wallet_demo_accounts
wallet_demo_transactions
wallet_demo_users
wallet_settings
wallet_topup_requests
wallet_transactions
wallet_transaction_otp
wallet_withdrawal_requests
.
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
admin_notifications
admin_push_subscriptions
baccarat_demo_bets
baccarat_demo_players
baccarat_demo_rounds
baccarat_demo_state
baccarat_wallet_demo_bets
bills
bill_items
customer_account_transactions
customer_bank_accounts
customer_login_audit
customer_otp
customer_payment_status
customer_users
customer_wallets
lottery_draw_results_demo
lottery_draw_settings
lottery_half_numbers
lottery_prize_payouts_demo
lottery_prize_payouts_demo_v2
lottery_result_cache
lottery_sale_overrides
lottery_sale_schedules
lottery_settings_audit
lottery_wallet_demo_orders
ml_audit
ml_drafts
ml_events
ml_members
ml_outbox
ml_receipts
mybill_bill_settlements
mybill_manual_result_entries
mybill_passkey_audit
mybill_passkey_credentials
mybill_passkey_limits
mybill_passkey_users
payment_webhook_events
project_demo_mode
staff_permissions
users
wallet_audit_log
wallet_demo_accounts
wallet_demo_transactions
wallet_demo_users
wallet_settings
wallet_topup_requests
wallet_transactions
wallet_transaction_otp
wallet_withdrawal_requests
.
select column
select table
admin_notifications
admin_push_subscriptions
baccarat_demo_bets
baccarat_demo_players
baccarat_demo_rounds
baccarat_demo_state
baccarat_wallet_demo_bets
bills
bill_items
customer_account_transactions
customer_bank_accounts
customer_login_audit
customer_otp
customer_payment_status
customer_users
customer_wallets
lottery_draw_results_demo
lottery_draw_settings
lottery_half_numbers
lottery_prize_payouts_demo
lottery_prize_payouts_demo_v2
lottery_result_cache
lottery_sale_overrides
lottery_sale_schedules
lottery_settings_audit
lottery_wallet_demo_orders
ml_audit
ml_drafts
ml_events
ml_members
ml_outbox
ml_receipts
mybill_bill_settlements
mybill_manual_result_entries
mybill_passkey_audit
mybill_passkey_credentials
mybill_passkey_limits
mybill_passkey_users
payment_webhook_events
project_demo_mode
staff_permissions
users
wallet_audit_log
wallet_demo_accounts
wallet_demo_transactions
wallet_demo_users
wallet_settings
wallet_topup_requests
wallet_transactions
wallet_transaction_otp
wallet_withdrawal_requests
.
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
admin_notifications
admin_push_subscriptions
baccarat_demo_bets
baccarat_demo_players
baccarat_demo_rounds
baccarat_demo_state
baccarat_wallet_demo_bets
bills
bill_items
customer_account_transactions
customer_bank_accounts
customer_login_audit
customer_otp
customer_payment_status
customer_users
customer_wallets
lottery_draw_results_demo
lottery_draw_settings
lottery_half_numbers
lottery_prize_payouts_demo
lottery_prize_payouts_demo_v2
lottery_result_cache
lottery_sale_overrides
lottery_sale_schedules
lottery_settings_audit
lottery_wallet_demo_orders
ml_audit
ml_drafts
ml_events
ml_members
ml_outbox
ml_receipts
mybill_bill_settlements
mybill_manual_result_entries
mybill_passkey_audit
mybill_passkey_credentials
mybill_passkey_limits
mybill_passkey_users
payment_webhook_events
project_demo_mode
staff_permissions
users
wallet_audit_log
wallet_demo_accounts
wallet_demo_transactions
wallet_demo_users
wallet_settings
wallet_topup_requests
wallet_transactions
wallet_transaction_otp
wallet_withdrawal_requests
.
select column