将文件拖动至此

SQL 上传 ( 0 ) x -

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





崩溃 扩展 重新查询 编辑 解析 性能分析 书签 查询失败 数据库 : 查询时间 :
自定义浏览模式。
浏览模式
文档 仅使用图标、文字或都使用。 还原为默认值
文档 仅使用图标、文字或都使用。 还原为默认值
文档 设置是否给用户显示一个 "显示所有 (记录)" 的按钮。 还原为默认值
文档 浏览结果集时显示的行数。若结果集总行数超过该值，将会显示 "上一页" 和 "下一页" 的链接。 还原为默认值
文档 SMART - 即对 TIME、DATE、DATETIME 和 TIMESTAMP 类型的字段递减排序，其它字段递增。 还原为默认值
文档 高亮鼠标指针所在的行。 还原为默认值
文档 高亮选中的行。 还原为默认值
文档 还原为默认值
文档 还原为默认值
文档 每 X 单元格重复表头，要禁止此功能请设为 0。 还原为默认值
文档 浏览非数字字段时最多显示的字数。 还原为默认值
文档 这些是编辑、复制和删除链接。 还原为默认值
文档 缺少唯一键时是否显示行链接。 还原为默认值
文档 默认用主键为表排序。 还原为默认值
文档 当浏览表时使用上次的排序方式。 还原为默认值
文档 显示选项 还原为默认值 
SELECT * FROM `payments` ORDER BY `assigned_user_id` ASC
[ 编辑内嵌 ] [ 编辑 ] [ 解析 SQL ] [ 创建 PHP 代码 ] [ 刷新 ]
|
|
|
过滤行:
按索引排序：
完整内容 id name date_entered date_modified modified_user_id created_by description deleted assigned_user_id 递增 递减 1 collection_number contract_id payment_direction payment_method currency_id receivable_amount actual_amount overdue_time received_time collection_status
编辑 编辑 复制 复制 删除 删除
DELETE FROM payments WHERE `payments`.`id` = '053bb649-b0d7-479a-b678-cb83c9a4da3b'
 		053bb649-b0d7-479a-b678-cb83c9a4da3b 采购-30%预付款-电磁阀（7321GBN99N00） 2026-08-13 02:42:30 2026-08-14 08:17:06 809d1dd6-706d-41f2-b44f-f0565e8a15fb 809d1dd6-706d-41f2-b44f-f0565e8a15fb 供应商-上海海费 0 6edbf996-dc5c-429c-803d-8db0d770a37c NULL 6508a31d-4f8b-4f99-938d-e1e0c47600fd payable bank_transfer -99 1176.900000 1176.900000 2026-08-14 16:00:00 2026-08-13 16:00:00 completed
编辑 编辑 复制 复制 删除 删除
DELETE FROM payments WHERE `payments`.`id` = '7f8adcfb-e545-4234-9a66-96cecffb0b06'
 		7f8adcfb-e545-4234-9a66-96cecffb0b06 测试付款-123 2026-07-06 10:45:59 2026-07-07 10:29:07 809d1dd6-706d-41f2-b44f-f0565e8a15fb 809d1dd6-706d-41f2-b44f-f0565e8a15fb 1 6edbf996-dc5c-429c-803d-8db0d770a37c NULL 2245382f-8cf0-43f1-9a98-e1b8f58e815b receivable cash -99 100000000.000000 NULL 2026-07-08 16:00:00 NULL not_completed
编辑 编辑 复制 复制 删除 删除
DELETE FROM payments WHERE `payments`.`id` = '22f67dab-77a5-4371-8d3b-3669724acd8c'
 		22f67dab-77a5-4371-8d3b-3669724acd8c 70%货款-QM-20270727-01-上海瀚仕威 2026-07-28 02:10:30 2026-07-28 02:10:30 809d1dd6-706d-41f2-b44f-f0565e8a15fb 809d1dd6-706d-41f2-b44f-f0565e8a15fb 0 809d1dd6-706d-41f2-b44f-f0565e8a15fb NULL 5225a2e0-01a5-4eaa-a5c7-39451e66e5ce receivable bank_transfer -99 10360.000000 NULL 2026-08-31 16:00:00 NULL not_completed
编辑 编辑 复制 复制 删除 删除
DELETE FROM payments WHERE `payments`.`id` = '30013789-f5c4-4902-9380-6c909a86feaf'
 		30013789-f5c4-4902-9380-6c909a86feaf 全款-南京保立隆 2026-08-05 02:20:37 2026-08-05 02:20:37 809d1dd6-706d-41f2-b44f-f0565e8a15fb 809d1dd6-706d-41f2-b44f-f0565e8a15fb 0 809d1dd6-706d-41f2-b44f-f0565e8a15fb NULL fa57d860-5efc-4b96-9cf1-fec5b024be67 receivable bank_transfer -99 48800.000000 NULL 2026-09-30 16:00:00 NULL not_completed
编辑 编辑 复制 复制 删除 删除
DELETE FROM payments WHERE `payments`.`id` = '36ba2e77-9479-4100-9eae-36ce0b82c52a'
 		36ba2e77-9479-4100-9eae-36ce0b82c52a 三盾科技-ZCHB/KC 滤芯 全款 2026-07-13 06:26:11 2026-07-27 01:29:34 809d1dd6-706d-41f2-b44f-f0565e8a15fb 809d1dd6-706d-41f2-b44f-f0565e8a15fb NULL 0 809d1dd6-706d-41f2-b44f-f0565e8a15fb NULL abaef5a0-f8b5-481e-bee6-3c3e65cf320d receivable bank_transfer -99 15080.000000 15080.000000 2026-08-12 16:00:00 2026-07-21 16:00:00 completed
编辑 编辑 复制 复制 删除 删除
DELETE FROM payments WHERE `payments`.`id` = '76e48f62-3e6c-4d4f-811c-1dc12ae3770b'
 		76e48f62-3e6c-4d4f-811c-1dc12ae3770b 尾款70%-采购合同-20260826-01-翊众-20个接头 2026-08-26 06:26:34 2026-08-26 06:26:34 809d1dd6-706d-41f2-b44f-f0565e8a15fb 809d1dd6-706d-41f2-b44f-f0565e8a15fb 尾款70%-采购合同-20260826-01-翊众-20个接头 0 809d1dd6-706d-41f2-b44f-f0565e8a15fb NULL 303a3422-4f75-4208-9b3a-d840a7977029 receivable bank_transfer -99 1982.400000 NULL 2026-12-30 16:00:00 NULL not_completed
编辑 编辑 复制 复制 删除 删除
DELETE FROM payments WHERE `payments`.`id` = '939ab795-3061-49ca-b582-7d778ff3172f'
 		939ab795-3061-49ca-b582-7d778ff3172f 30%预付款-QM-202607027-01 2026-07-28 02:09:10 2026-07-28 02:09:10 809d1dd6-706d-41f2-b44f-f0565e8a15fb 809d1dd6-706d-41f2-b44f-f0565e8a15fb 0 809d1dd6-706d-41f2-b44f-f0565e8a15fb NULL 5225a2e0-01a5-4eaa-a5c7-39451e66e5ce receivable bank_transfer -99 4440.000000 4440.000000 2026-07-27 16:00:00 2026-07-27 16:00:00 completed
编辑 编辑 复制 复制 删除 删除
DELETE FROM payments WHERE `payments`.`id` = 'abf7ac71-b1e8-4803-9f7e-c25c23a3781a'
 		abf7ac71-b1e8-4803-9f7e-c25c23a3781a 合同70%尾款（QM-20260722-01） 2026-07-22 08:47:58 2026-07-28 08:14:27 809d1dd6-706d-41f2-b44f-f0565e8a15fb 809d1dd6-706d-41f2-b44f-f0565e8a15fb NULL 0 809d1dd6-706d-41f2-b44f-f0565e8a15fb NULL eaac9085-3589-462e-88f6-f6305d41d8bc receivable bank_transfer -99 4473.000000 NULL 2026-08-30 16:00:00 NULL not_completed
编辑 编辑 复制 复制 删除 删除
DELETE FROM payments WHERE `payments`.`id` = 'adb9104b-db59-4d1e-ac98-3d1a5a5631ae'
 		adb9104b-db59-4d1e-ac98-3d1a5a5631ae 上海兹阳合同全款 2026-07-09 09:44:25 2026-07-27 01:30:11 809d1dd6-706d-41f2-b44f-f0565e8a15fb 1 NULL 0 809d1dd6-706d-41f2-b44f-f0565e8a15fb NULL ac155feb-90df-4107-b921-28c2e6ea45df receivable bank_transfer -99 1980.000000 1980.000000 2026-07-18 03:00:00 2026-07-10 02:30:00 completed
编辑 编辑 复制 复制 删除 删除
DELETE FROM payments WHERE `payments`.`id` = 'ccf8956e-db10-4345-a5b8-de95e350791d'
 		ccf8956e-db10-4345-a5b8-de95e350791d 杭州炎锐过滤器采购全款 2026-07-21 08:35:03 2026-07-27 01:29:53 809d1dd6-706d-41f2-b44f-f0565e8a15fb 809d1dd6-706d-41f2-b44f-f0565e8a15fb NULL 0 809d1dd6-706d-41f2-b44f-f0565e8a15fb NULL 662219d3-a223-4d05-912b-41a1e1cf409d receivable bank_transfer -99 6934.000000 6934.000000 2026-07-30 16:00:00 2026-07-23 16:00:00 completed
编辑 编辑 复制 复制 删除 删除
DELETE FROM payments WHERE `payments`.`id` = 'cefb696b-e4ed-41df-be64-ee4c28d756db'
 		cefb696b-e4ed-41df-be64-ee4c28d756db 预付款30%-采购合同-20260826-01-翊众-20个接头 2026-08-26 06:24:51 2026-08-26 09:56:36 809d1dd6-706d-41f2-b44f-f0565e8a15fb 809d1dd6-706d-41f2-b44f-f0565e8a15fb 预付款30%-采购合同-20260826-01-翊众-20个接头 0 809d1dd6-706d-41f2-b44f-f0565e8a15fb NULL 303a3422-4f75-4208-9b3a-d840a7977029 payable bank_transfer -99 849.600000 849.600000 2026-08-30 16:00:00 2026-08-25 16:00:00 completed
编辑 编辑 复制 复制 删除 删除
DELETE FROM payments WHERE `payments`.`id` = 'da31f28d-a74f-4583-a28a-94a5c3f7aa6b'
 		da31f28d-a74f-4583-a28a-94a5c3f7aa6b 合同30%预付款（QM-20260722-01） 2026-07-22 08:45:55 2026-07-23 02:01:31 809d1dd6-706d-41f2-b44f-f0565e8a15fb 809d1dd6-706d-41f2-b44f-f0565e8a15fb NULL 0 809d1dd6-706d-41f2-b44f-f0565e8a15fb NULL eaac9085-3589-462e-88f6-f6305d41d8bc receivable bank_transfer -99 1917.000000 1917.000000 2026-07-21 16:00:00 2026-07-21 16:00:00 completed
编辑 编辑 复制 复制 删除 删除
DELETE FROM payments WHERE `payments`.`id` = 'f4a7e9f0-c2e9-4b5d-b00e-bb5ab5b9b078'
 		f4a7e9f0-c2e9-4b5d-b00e-bb5ab5b9b078 测试款项 2026-07-03 02:41:08 2026-07-09 08:19:31 809d1dd6-706d-41f2-b44f-f0565e8a15fb 1 测试款项邮件任务测试。
 1 809d1dd6-706d-41f2-b44f-f0565e8a15fb NULL 2245382f-8cf0-43f1-9a98-e1b8f58e815b receivable bank_transfer -99 300000.000000 NULL 2026-07-10 03:00:00 NULL not_completed
编辑 编辑 复制 复制 删除 删除
DELETE FROM payments WHERE `payments`.`id` = 'bf018b4d-42a3-46ab-9681-a96f891d8c4e'
 		bf018b4d-42a3-46ab-9681-a96f891d8c4e 合同全款（上海兹阳） 2026-07-08 01:37:09 2026-07-09 09:42:21 1 809d1dd6-706d-41f2-b44f-f0565e8a15fb NULL 1 c820f052-94d0-4059-9dbc-7ed601d34e93 NULL ac155feb-90df-4107-b921-28c2e6ea45df receivable bank_transfer -99 1980.000000 NULL 2026-07-10 16:00:00 NULL not_completed
选中项： 选中项：
|
|
|
过滤行:
按索引排序：
查询结果操作 复制到剪贴板 复制到剪贴板 导出 导出 显示图表 显示图表 新建视图 新建视图
将此 SQL 查询加为书签 将此 SQL 查询加为书签