近期访问
`information_schema`.`TABLESPACES`
`performance_schema`.`accounts`
`information_schema`.`TABLE_PRIVILEGES`
`information_schema`.`PARAMETERS`
`information_schema`.`INNODB_BUFFER_POOL_STATS`
`performance_schema`.`file_summary_by_instance`
`mybill_v2`.`member_passkey_users`
`information_schema`.`INNODB_CMPMEM`
`information_schema`.`KEY_CACHES`
`information_schema`.`SCHEMA_PRIVILEGES`
表收藏夹
表收藏夹为空。
新建
bantiwa999_db
bill_db
information_schema
mybill
mybill
mybill_v2
mycloud_db
mysql
performance_schema
phpmyadmin
prison_db_8080
test
tiktok_ai_affiliate
导航面板
导航树
服务器
数据库
表
导航面板
自定义导航面板。
导航面板
以树状显示数据库导航面板
导航栏使用数据库选择器替代树形列表
与主面板链接
高亮当前数据库或表链接到主面板。
显示徽标
在导航面板中显示图示。
徽标链接地址
导航面板中图示指向的链接地址。
徽标链接目标
在主窗口(
main
)或新窗口(
new
)打开目标页面。
main
new
启用高亮
高亮鼠标指针所在位置的服务器。
第一层节点的最大项数
每页导航树所能显示的第一层的最大项数。
显示筛选框的最少项数
设置达到多少个项(表、视图、程序和事件)时将显示筛选框。
最近使用的表
最近使用的表的最大数量;设为 0 为禁用。
表收藏夹
收藏表的最大数量;设为 0 为禁用。
导航面板宽度
设置为0以折叠导航面板。
导航树
自定义导航树。
导航树
节点中最大项数
每页导航树所能显示的最大项数。
分组树中的项
将导航树中的项分组(根据上面 数据库与数据表 页面设置的分隔符分组)。
启用表导航条展开功能
是否允许在导航栏中展开导航树。
在导航树显示表
在导航树是否在数据库下显示数据表节点
在导航树显示视图
在导航树中是否在数据库下显示视图节点
在导航树显示函数
是否显示导航树中数据库下级功能
在导航树显示进程
是否在导航树中显示数据库进程
在导航树显示事件
在导航树中数据库下是否显示事件节点
展开单个数据库
是否自动在导航树中展开单个数据库。
服务器
服务器显示选项。
服务器
显示服务器选择
在导航面板顶部显示可选的服务器。
列表显示服务器
直接显示服务器列表而不使用下拉框。
数据库
数据库显示选项。
数据库
设置达到多少个数据库时将显示数据库筛选框
数据库树分隔符
将数据库分为不同层级的字符串。
表
表显示选项。
表
快速访问图标的目标
结构
SQL
搜索
插入
浏览
第二快速访问图标的目标页面
结构
SQL
搜索
插入
浏览
表树分隔符
将表分为不同层级的字符串。
表树最大深度
将文件拖动至此
SQL 上传 (
0
)
x
-
显示隐藏的导航树节点。
新建视图
该处必须启用 Javascript!
服务器: 127.0.0.1
数据库: mybill
结构
SQL
搜索
查询
(当前的)
导出
导入
操作
权限
程序
事件
触发器
追踪
设计器
文本框列
控制台
清除
历史
选项
书签
调试 SQL
按 Ctrl+Enter 键执行查询
按 Enter 执行查询
崩溃
扩展
重新查询
编辑
解析
性能分析
书签
查询失败
数据库 :
information_schema
查询时间 :
在当前会话期间
SELECT * FROM `SCHEMA_PRIVILEGES`
递增排序
递减排序
命令:
调试 SQL
数量
运行顺序
用时
排序条件:
联合查询
不使用联合查询
崩溃
扩展
显示跟踪
隐藏跟踪
数量 :
用时 :
书签
刷新
添加
没有书签
添加书签
标签:
目标数据库:
共享和谐书签
确定
选项
恢复默认
总是扩展查询消息
在开始时显示查询历史
显示当前浏览查询
浏览设置,使按Shift+Enter键执行输入和插入新行作为永久设置。
切换到黑色主题
崩溃
扩展
重新查询
编辑
解析
性能分析
书签
查询失败
数据库 :
查询时间 :
正在加载
ENUM/SET 编辑器
新建视图
多表查询
通过示例查询
查询窗口
*
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
选择表
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
.
选择字段
显示
条件
排序
递增
递减
添加为
AND
OR
Op
=
>
>=
<
<=
!=
LIKE
LIKE %...%
NOT LIKE
NOT LIKE %...%
IN (...)
NOT IN (...)
BETWEEN
NOT BETWEEN
IS NULL
IS NOT NULL
REGEXP
REGEXP ^...$
NOT REGEXP
文字
另一个字段
选择表
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
.
选择字段
选择表
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
.
选择字段
显示
条件
排序
递增
递减
添加为
AND
OR
Op
=
>
>=
<
<=
!=
LIKE
LIKE %...%
NOT LIKE
NOT LIKE %...%
IN (...)
NOT IN (...)
BETWEEN
NOT BETWEEN
IS NULL
IS NOT NULL
REGEXP
REGEXP ^...$
NOT REGEXP
文字
另一个字段
选择表
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
.
选择字段
选择表
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
.
选择字段
显示
条件
排序
递增
递减
添加为
AND
OR
Op
=
>
>=
<
<=
!=
LIKE
LIKE %...%
NOT LIKE
NOT LIKE %...%
IN (...)
NOT IN (...)
BETWEEN
NOT BETWEEN
IS NULL
IS NOT NULL
REGEXP
REGEXP ^...$
NOT REGEXP
文字
另一个字段
选择表
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
.
选择字段
选择表
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
.
选择字段
显示
条件
排序
递增
递减
添加为
AND
OR
Op
=
>
>=
<
<=
!=
LIKE
LIKE %...%
NOT LIKE
NOT LIKE %...%
IN (...)
NOT IN (...)
BETWEEN
NOT BETWEEN
IS NULL
IS NOT NULL
REGEXP
REGEXP ^...$
NOT REGEXP
文字
另一个字段
选择表
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
.
选择字段