将文件拖动至此

SQL 上传 ( 0 ) x -

页面相关设置 点击以滚动到页面顶部
按 Ctrl+Enter 键执行查询 按 Enter 执行查询
递增排序
递减排序
命令：
调试 SQL
数量
运行顺序
用时
排序条件：
联合查询
不使用联合查询
崩溃 扩展 显示跟踪 隐藏跟踪 数量 : 用时 :
书签
刷新
添加
没有书签
添加书签
选项
恢复默认





崩溃 扩展 重新查询 编辑 解析 性能分析 书签 查询失败 数据库 : 查询时间 :
自定义浏览模式。
浏览模式
文档 仅使用图标、文字或都使用。 还原为默认值
文档 仅使用图标、文字或都使用。 还原为默认值
文档 设置是否给用户显示一个 "显示所有 (记录)" 的按钮。 还原为默认值
文档 浏览结果集时显示的行数。若结果集总行数超过该值，将会显示 "上一页" 和 "下一页" 的链接。 还原为默认值
文档 SMART - 即对 TIME、DATE、DATETIME 和 TIMESTAMP 类型的字段递减排序，其它字段递增。 还原为默认值
文档 高亮鼠标指针所在的行。 还原为默认值
文档 高亮选中的行。 还原为默认值
文档 还原为默认值
文档 还原为默认值
文档 每 X 单元格重复表头，要禁止此功能请设为 0。 还原为默认值
文档 浏览非数字字段时最多显示的字数。 还原为默认值
文档 这些是编辑、复制和删除链接。 还原为默认值
文档 缺少唯一键时是否显示行链接。 还原为默认值
文档 默认用主键为表排序。 还原为默认值
文档 当浏览表时使用上次的排序方式。 还原为默认值
文档 显示选项 还原为默认值 
SELECT * FROM `payments_audit` ORDER BY `id` DESC
[ 编辑内嵌 ] [ 编辑 ] [ 解析 SQL ] [ 创建 PHP 代码 ] [ 刷新 ]
|
|
|
过滤行:
按索引排序：
完整内容 id 递减 递增 1 parent_id date_created created_by field_name data_type before_value_string after_value_string before_value_text after_value_text
编辑 编辑 复制 复制 删除 删除
DELETE FROM payments_audit WHERE `payments_audit`.`id` = 'feb30074-a92c-42aa-b95c-93e5218867a9'
 		feb30074-a92c-42aa-b95c-93e5218867a9 ccf8956e-db10-4345-a5b8-de95e350791d 2026-07-27 01:29:10 809d1dd6-706d-41f2-b44f-f0565e8a15fb received_time datetimecombo 2026-07-23 16:00:00 NULL NULL
编辑 编辑 复制 复制 删除 删除
DELETE FROM payments_audit WHERE `payments_audit`.`id` = 'fd5445b0-065c-4f77-abd8-745f0ede68c2'
 		fd5445b0-065c-4f77-abd8-745f0ede68c2 053bb649-b0d7-479a-b678-cb83c9a4da3b 2026-08-14 08:17:06 809d1dd6-706d-41f2-b44f-f0565e8a15fb receivable_amount currency 1177.000000 1176.9 NULL NULL
编辑 编辑 复制 复制 删除 删除
DELETE FROM payments_audit WHERE `payments_audit`.`id` = 'fc2976e9-b2a4-48b2-a95b-1dd7fc3458a8'
 		fc2976e9-b2a4-48b2-a95b-1dd7fc3458a8 f4a7e9f0-c2e9-4b5d-b00e-bb5ab5b9b078 2026-07-06 10:19:49 809d1dd6-706d-41f2-b44f-f0565e8a15fb collection_status enum completed not_completed NULL NULL
编辑 编辑 复制 复制 删除 删除
DELETE FROM payments_audit WHERE `payments_audit`.`id` = 'ed1f144d-7d0c-4f67-9609-c4464dbcfb21'
 		ed1f144d-7d0c-4f67-9609-c4464dbcfb21 f4a7e9f0-c2e9-4b5d-b00e-bb5ab5b9b078 2026-07-06 10:19:04 809d1dd6-706d-41f2-b44f-f0565e8a15fb collection_status enum not_completed completed NULL NULL
编辑 编辑 复制 复制 删除 删除
DELETE FROM payments_audit WHERE `payments_audit`.`id` = 'daa2d2be-cba9-43fd-85bb-1531dad012b0'
 		daa2d2be-cba9-43fd-85bb-1531dad012b0 f4a7e9f0-c2e9-4b5d-b00e-bb5ab5b9b078 2026-07-03 08:26:39 1 payment_method enum cash bank_transfer NULL NULL
编辑 编辑 复制 复制 删除 删除
DELETE FROM payments_audit WHERE `payments_audit`.`id` = 'd5cd3594-b105-4eea-8223-51ff4b9ad515'
 		d5cd3594-b105-4eea-8223-51ff4b9ad515 f4a7e9f0-c2e9-4b5d-b00e-bb5ab5b9b078 2026-07-03 08:26:17 1 overdue_time datetimecombo 2026-07-04 03:00:00 2026-07-10 03:00:00 NULL NULL
编辑 编辑 复制 复制 删除 删除
DELETE FROM payments_audit WHERE `payments_audit`.`id` = 'd2e400c1-b1bc-40a2-9a60-b9c0e60058af'
 		d2e400c1-b1bc-40a2-9a60-b9c0e60058af cefb696b-e4ed-41df-be64-ee4c28d756db 2026-08-26 09:56:36 809d1dd6-706d-41f2-b44f-f0565e8a15fb collection_status enum not_completed completed NULL NULL
编辑 编辑 复制 复制 删除 删除
DELETE FROM payments_audit WHERE `payments_audit`.`id` = 'd18c5db5-da8f-4efc-b98a-b6a2e1d4d68d'
 		d18c5db5-da8f-4efc-b98a-b6a2e1d4d68d abf7ac71-b1e8-4803-9f7e-c25c23a3781a 2026-07-28 08:14:27 809d1dd6-706d-41f2-b44f-f0565e8a15fb received_time datetimecombo 2026-11-04 16:00:00 NULL NULL
编辑 编辑 复制 复制 删除 删除
DELETE FROM payments_audit WHERE `payments_audit`.`id` = 'bf7d32a5-6241-4717-a764-07ee7399138f'
 		bf7d32a5-6241-4717-a764-07ee7399138f adb9104b-db59-4d1e-ac98-3d1a5a5631ae 2026-07-27 01:30:11 809d1dd6-706d-41f2-b44f-f0565e8a15fb actual_amount currency 1980 NULL NULL
编辑 编辑 复制 复制 删除 删除
DELETE FROM payments_audit WHERE `payments_audit`.`id` = 'ba800d0d-c8be-449d-982a-cf604ee28b50'
 		ba800d0d-c8be-449d-982a-cf604ee28b50 36ba2e77-9479-4100-9eae-36ce0b82c52a 2026-07-27 01:29:34 809d1dd6-706d-41f2-b44f-f0565e8a15fb actual_amount currency 15080 NULL NULL
编辑 编辑 复制 复制 删除 删除
DELETE FROM payments_audit WHERE `payments_audit`.`id` = '97936787-11c1-4ddc-b5c1-fcc9f76f4c3d'
 		97936787-11c1-4ddc-b5c1-fcc9f76f4c3d cefb696b-e4ed-41df-be64-ee4c28d756db 2026-08-26 07:46:56 809d1dd6-706d-41f2-b44f-f0565e8a15fb assigned_user_id relate 6edbf996-dc5c-429c-803d-8db0d770a37c 809d1dd6-706d-41f2-b44f-f0565e8a15fb NULL NULL
编辑 编辑 复制 复制 删除 删除
DELETE FROM payments_audit WHERE `payments_audit`.`id` = '9346f53a-7a6b-4ba1-ad4f-34807096492d'
 		9346f53a-7a6b-4ba1-ad4f-34807096492d ccf8956e-db10-4345-a5b8-de95e350791d 2026-07-27 01:28:59 809d1dd6-706d-41f2-b44f-f0565e8a15fb collection_status enum not_completed completed NULL NULL
编辑 编辑 复制 复制 删除 删除
DELETE FROM payments_audit WHERE `payments_audit`.`id` = '7d2e6bdf-a2e9-4dc5-9bf1-caa8a1ebc0d7'
 		7d2e6bdf-a2e9-4dc5-9bf1-caa8a1ebc0d7 adb9104b-db59-4d1e-ac98-3d1a5a5631ae 2026-07-10 04:56:32 809d1dd6-706d-41f2-b44f-f0565e8a15fb collection_status enum not_completed completed NULL NULL
编辑 编辑 复制 复制 删除 删除
DELETE FROM payments_audit WHERE `payments_audit`.`id` = '79794557-de8e-45c5-8ba2-2cfe9ba46b1e'
 		79794557-de8e-45c5-8ba2-2cfe9ba46b1e da31f28d-a74f-4583-a28a-94a5c3f7aa6b 2026-07-23 02:01:31 809d1dd6-706d-41f2-b44f-f0565e8a15fb collection_status enum not_completed completed NULL NULL
编辑 编辑 复制 复制 删除 删除
DELETE FROM payments_audit WHERE `payments_audit`.`id` = '7232265f-b757-4370-8e67-c29ceafa1931'
 		7232265f-b757-4370-8e67-c29ceafa1931 adb9104b-db59-4d1e-ac98-3d1a5a5631ae 2026-07-10 04:56:47 809d1dd6-706d-41f2-b44f-f0565e8a15fb received_time datetimecombo 2026-07-10 02:30:00 NULL NULL
编辑 编辑 复制 复制 删除 删除
DELETE FROM payments_audit WHERE `payments_audit`.`id` = '680e7349-a201-401f-84b1-790970e368d2'
 		680e7349-a201-401f-84b1-790970e368d2 053bb649-b0d7-479a-b678-cb83c9a4da3b 2026-08-14 08:17:06 809d1dd6-706d-41f2-b44f-f0565e8a15fb actual_amount currency 1176.9 NULL NULL
编辑 编辑 复制 复制 删除 删除
DELETE FROM payments_audit WHERE `payments_audit`.`id` = '4bb5f65e-7936-45d2-b73e-3938870e55d1'
 		4bb5f65e-7936-45d2-b73e-3938870e55d1 36ba2e77-9479-4100-9eae-36ce0b82c52a 2026-07-23 06:20:01 809d1dd6-706d-41f2-b44f-f0565e8a15fb received_time datetimecombo 2026-07-21 16:00:00 NULL NULL
编辑 编辑 复制 复制 删除 删除
DELETE FROM payments_audit WHERE `payments_audit`.`id` = '36edbfd9-7936-4e6e-be68-6af41948a0ba'
 		36edbfd9-7936-4e6e-be68-6af41948a0ba 053bb649-b0d7-479a-b678-cb83c9a4da3b 2026-08-14 08:17:06 809d1dd6-706d-41f2-b44f-f0565e8a15fb received_time datetimecombo 2026-08-13 16:00:00 NULL NULL
编辑 编辑 复制 复制 删除 删除
DELETE FROM payments_audit WHERE `payments_audit`.`id` = '2918176a-3203-4d36-ac37-815dd5207d36'
 		2918176a-3203-4d36-ac37-815dd5207d36 bf018b4d-42a3-46ab-9681-a96f891d8c4e 2026-07-09 09:36:29 1 assigned_user_id relate 809d1dd6-706d-41f2-b44f-f0565e8a15fb c820f052-94d0-4059-9dbc-7ed601d34e93 NULL NULL
编辑 编辑 复制 复制 删除 删除
DELETE FROM payments_audit WHERE `payments_audit`.`id` = '1f4f0a76-ee47-4a1f-9ab1-137f188ee36c'
 		1f4f0a76-ee47-4a1f-9ab1-137f188ee36c 053bb649-b0d7-479a-b678-cb83c9a4da3b 2026-08-14 08:17:06 809d1dd6-706d-41f2-b44f-f0565e8a15fb collection_status enum not_completed completed NULL NULL
编辑 编辑 复制 复制 删除 删除
DELETE FROM payments_audit WHERE `payments_audit`.`id` = '15d65cc6-82b5-4366-b12f-931d4f90c885'
 		15d65cc6-82b5-4366-b12f-931d4f90c885 ccf8956e-db10-4345-a5b8-de95e350791d 2026-07-27 01:29:53 809d1dd6-706d-41f2-b44f-f0565e8a15fb actual_amount currency 6934 NULL NULL
编辑 编辑 复制 复制 删除 删除
DELETE FROM payments_audit WHERE `payments_audit`.`id` = '1314405e-dd3a-4dfc-a33a-281cc1d95f2d'
 		1314405e-dd3a-4dfc-a33a-281cc1d95f2d cefb696b-e4ed-41df-be64-ee4c28d756db 2026-08-26 09:56:36 809d1dd6-706d-41f2-b44f-f0565e8a15fb received_time datetimecombo 2026-08-25 16:00:00 NULL NULL
编辑 编辑 复制 复制 删除 删除
DELETE FROM payments_audit WHERE `payments_audit`.`id` = '10cbf8c8-418b-43dc-a7ef-0ff613a12193'
 		10cbf8c8-418b-43dc-a7ef-0ff613a12193 abf7ac71-b1e8-4803-9f7e-c25c23a3781a 2026-07-28 08:14:27 809d1dd6-706d-41f2-b44f-f0565e8a15fb overdue_time datetimecombo 2026-07-21 16:00:00 2026-08-30 16:00:00 NULL NULL
编辑 编辑 复制 复制 删除 删除
DELETE FROM payments_audit WHERE `payments_audit`.`id` = '018f7f80-58cb-4cec-b8de-6ee405dacf57'
 		018f7f80-58cb-4cec-b8de-6ee405dacf57 36ba2e77-9479-4100-9eae-36ce0b82c52a 2026-07-23 06:20:01 809d1dd6-706d-41f2-b44f-f0565e8a15fb collection_status enum not_completed completed NULL NULL
选中项： 选中项：
|
|
|
过滤行:
按索引排序：
查询结果操作 复制到剪贴板 复制到剪贴板 导出 导出 显示图表 显示图表 新建视图 新建视图
将此 SQL 查询加为书签 将此 SQL 查询加为书签