将文件拖动至此

SQL 上传 ( 0 ) x -

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





崩溃 扩展 重新查询 编辑 解析 性能分析 书签 查询失败 数据库 : 查询时间 :
自定义浏览模式。
浏览模式
文档 仅使用图标、文字或都使用。 还原为默认值
文档 仅使用图标、文字或都使用。 还原为默认值
文档 设置是否给用户显示一个 "显示所有 (记录)" 的按钮。 还原为默认值
文档 浏览结果集时显示的行数。若结果集总行数超过该值，将会显示 "上一页" 和 "下一页" 的链接。 还原为默认值
文档 SMART - 即对 TIME、DATE、DATETIME 和 TIMESTAMP 类型的字段递减排序，其它字段递增。 还原为默认值
文档 高亮鼠标指针所在的行。 还原为默认值
文档 高亮选中的行。 还原为默认值
文档 还原为默认值
文档 还原为默认值
文档 每 X 单元格重复表头，要禁止此功能请设为 0。 还原为默认值
文档 浏览非数字字段时最多显示的字数。 还原为默认值
文档 这些是编辑、复制和删除链接。 还原为默认值
文档 缺少唯一键时是否显示行链接。 还原为默认值
文档 默认用主键为表排序。 还原为默认值
文档 当浏览表时使用上次的排序方式。 还原为默认值
文档 显示选项 还原为默认值 
SELECT * FROM `user_preferences` ORDER BY `assigned_user_id` DESC
[ 编辑内嵌 ] [ 编辑 ] [ 解析 SQL ] [ 创建 PHP 代码 ] [ 刷新 ]
|
|
|
|
过滤行:
按索引排序：
完整内容 id category deleted date_entered date_modified assigned_user_id 递减 递增 1 contents
编辑 编辑 复制 复制 删除 删除
DELETE FROM user_preferences WHERE `user_preferences`.`id` = '69666f5b-a576-4e64-b883-4b0fcacdabe9'
 		69666f5b-a576-4e64-b883-4b0fcacdabe9 global 0 2026-07-09 09:34:20 2026-07-09 09:42:08 c820f052-94d0-4059-9dbc-7ed601d34e93 YToxOntzOjExOiJlZGl0b3JfdHlwZSI7czo3OiJ0aW55bWNlIj...
编辑 编辑 复制 复制 删除 删除
DELETE FROM user_preferences WHERE `user_preferences`.`id` = '07ddd2ef-d3c2-466a-885d-a90c2e479c2d'
 		07ddd2ef-d3c2-466a-885d-a90c2e479c2d Calls:其他 0 2026-07-02 08:02:40 2026-07-02 08:02:40 809d1dd6-706d-41f2-b44f-f0565e8a15fb YTowOnt9
编辑 编辑 复制 复制 删除 删除
DELETE FROM user_preferences WHERE `user_preferences`.`id` = '0acdc38d-fd11-4de3-a387-264c9a5eca8a'
 		0acdc38d-fd11-4de3-a387-264c9a5eca8a Opportunities:Sales 0 2026-07-27 09:44:17 2026-07-27 09:44:19 809d1dd6-706d-41f2-b44f-f0565e8a15fb YTowOnt9
编辑 编辑 复制 复制 删除 删除
DELETE FROM user_preferences WHERE `user_preferences`.`id` = '0b42348f-3c98-4606-aaa3-546088f615c0'
 		0b42348f-3c98-4606-aaa3-546088f615c0 Opportunities:Other 0 2026-07-27 09:44:17 2026-07-27 09:44:19 809d1dd6-706d-41f2-b44f-f0565e8a15fb YTowOnt9
编辑 编辑 复制 复制 删除 删除
DELETE FROM user_preferences WHERE `user_preferences`.`id` = '18227cc7-d3a5-4d06-a983-b8d30537c645'
 		18227cc7-d3a5-4d06-a983-b8d30537c645 Emails 0 2026-07-02 08:02:40 2026-07-27 09:44:19 809d1dd6-706d-41f2-b44f-f0565e8a15fb YTowOnt9
编辑 编辑 复制 复制 删除 删除
DELETE FROM user_preferences WHERE `user_preferences`.`id` = '1c78716b-1015-43ab-a810-bce2a317fc07'
 		1c78716b-1015-43ab-a810-bce2a317fc07 Accounts 0 2026-07-08 02:28:06 2026-07-13 03:08:47 809d1dd6-706d-41f2-b44f-f0565e8a15fb YToxOntzOjIyOiJMaXN0Vmlld0Rpc3BsYXlDb2x1bW5zIjthOj...
编辑 编辑 复制 复制 删除 删除
DELETE FROM user_preferences WHERE `user_preferences`.`id` = '1cacf455-f1fe-4ea5-8be6-9fb0685a8f50'
 		1cacf455-f1fe-4ea5-8be6-9fb0685a8f50 Accounts:Collaboration 0 2026-07-13 03:08:45 2026-07-13 03:08:47 809d1dd6-706d-41f2-b44f-f0565e8a15fb YTowOnt9
编辑 编辑 复制 复制 删除 删除
DELETE FROM user_preferences WHERE `user_preferences`.`id` = '1e5a8ec2-df9d-478c-bca3-133c5b0a84ff'
 		1e5a8ec2-df9d-478c-bca3-133c5b0a84ff Calls:支持 0 2026-07-02 08:02:40 2026-07-02 08:02:40 809d1dd6-706d-41f2-b44f-f0565e8a15fb YTowOnt9
编辑 编辑 复制 复制 删除 删除
DELETE FROM user_preferences WHERE `user_preferences`.`id` = '1e69c9d4-d117-469e-a99c-4ff12046d2d0'
 		1e69c9d4-d117-469e-a99c-4ff12046d2d0 AOS_Contracts 0 2026-07-27 09:44:17 2026-07-27 09:44:19 809d1dd6-706d-41f2-b44f-f0565e8a15fb YTowOnt9
编辑 编辑 复制 复制 删除 删除
DELETE FROM user_preferences WHERE `user_preferences`.`id` = '23ecb7f9-a7c3-41fa-aaae-3e496d6f41ea'
 		23ecb7f9-a7c3-41fa-aaae-3e496d6f41ea AOK_KnowledgeBase2_AOK_KNOWLEDGEBASE 0 2026-07-02 08:40:05 2026-07-02 08:40:05 809d1dd6-706d-41f2-b44f-f0565e8a15fb YToxOntzOjEzOiJsaXN0dmlld09yZGVyIjthOjI6e3M6Nzoib3...
编辑 编辑 复制 复制 删除 删除
DELETE FROM user_preferences WHERE `user_preferences`.`id` = '3382a16a-22ab-4d6b-af04-ab57cea935ab'
 		3382a16a-22ab-4d6b-af04-ab57cea935ab Users2_USER 0 2026-07-13 03:09:17 2026-07-13 03:09:17 809d1dd6-706d-41f2-b44f-f0565e8a15fb YToxOntzOjEzOiJsaXN0dmlld09yZGVyIjthOjI6e3M6Nzoib3...
编辑 编辑 复制 复制 删除 删除
DELETE FROM user_preferences WHERE `user_preferences`.`id` = '37e4932c-06c2-46d0-a5ef-e9809335e66c'
 		37e4932c-06c2-46d0-a5ef-e9809335e66c Calls:销售 0 2026-07-02 08:02:40 2026-07-02 08:02:40 809d1dd6-706d-41f2-b44f-f0565e8a15fb YTowOnt9
编辑 编辑 复制 复制 删除 删除
DELETE FROM user_preferences WHERE `user_preferences`.`id` = '3e8f4564-06b4-4662-8b54-655a597f7064'
 		3e8f4564-06b4-4662-8b54-655a597f7064 AOS_Invoices2_AOS_INVOICES 0 2026-07-02 08:05:38 2026-07-02 08:05:38 809d1dd6-706d-41f2-b44f-f0565e8a15fb YToxOntzOjEzOiJsaXN0dmlld09yZGVyIjthOjI6e3M6Nzoib3...
编辑 编辑 复制 复制 删除 删除
DELETE FROM user_preferences WHERE `user_preferences`.`id` = '4469841b-ba80-46e3-b9a3-fb3d49b62df5'
 		4469841b-ba80-46e3-b9a3-fb3d49b62df5 Opportunities2_OPPORTUNITY 0 2026-07-03 09:41:59 2026-07-27 09:44:19 809d1dd6-706d-41f2-b44f-f0565e8a15fb YToxOntzOjEzOiJsaXN0dmlld09yZGVyIjthOjI6e3M6Nzoib3...
编辑 编辑 复制 复制 删除 删除
DELETE FROM user_preferences WHERE `user_preferences`.`id` = '4f8e1ccc-5aa8-4b3f-9e4c-4f71052c18c9'
 		4f8e1ccc-5aa8-4b3f-9e4c-4f71052c18c9 Payments2_PAYMENTS 0 2026-07-06 06:28:40 2026-08-26 09:57:14 809d1dd6-706d-41f2-b44f-f0565e8a15fb YToxOntzOjEzOiJsaXN0dmlld09yZGVyIjthOjI6e3M6Nzoib3...
编辑 编辑 复制 复制 删除 删除
DELETE FROM user_preferences WHERE `user_preferences`.`id` = '560fd230-e0c9-4968-adfe-5e15428da400'
 		560fd230-e0c9-4968-adfe-5e15428da400 Home2_LEAD_e617f920-4590-46c7-b72a-3713a23dd016 0 2026-07-02 08:02:05 2026-07-02 08:02:40 809d1dd6-706d-41f2-b44f-f0565e8a15fb YToxOntzOjEzOiJsaXN0dmlld09yZGVyIjthOjI6e3M6Nzoib3...
编辑 编辑 复制 复制 删除 删除
DELETE FROM user_preferences WHERE `user_preferences`.`id` = '579ed458-8658-4b8b-a282-36bf7995d6f9'
 		579ed458-8658-4b8b-a282-36bf7995d6f9 Home2_CALL 0 2026-07-02 08:02:04 2026-07-27 09:44:19 809d1dd6-706d-41f2-b44f-f0565e8a15fb YToxOntzOjEzOiJsaXN0dmlld09yZGVyIjthOjI6e3M6Nzoib3...
编辑 编辑 复制 复制 删除 删除
DELETE FROM user_preferences WHERE `user_preferences`.`id` = '5ebfbb48-4935-4005-b56c-6fb50b5979b9'
 		5ebfbb48-4935-4005-b56c-6fb50b5979b9 Contacts2_CONTACT 0 2026-07-08 01:26:09 2026-07-13 09:03:39 809d1dd6-706d-41f2-b44f-f0565e8a15fb YToxOntzOjEzOiJsaXN0dmlld09yZGVyIjthOjI6e3M6Nzoib3...
编辑 编辑 复制 复制 删除 删除
DELETE FROM user_preferences WHERE `user_preferences`.`id` = '5f2e8cd2-bf71-4bbf-836b-a36353b5dbe8'
 		5f2e8cd2-bf71-4bbf-836b-a36353b5dbe8 Dashboard 0 2026-07-02 08:02:40 2026-07-27 09:44:19 809d1dd6-706d-41f2-b44f-f0565e8a15fb YTowOnt9
编辑 编辑 复制 复制 删除 删除
DELETE FROM user_preferences WHERE `user_preferences`.`id` = '5f37de85-db79-432a-b89c-c10c60999fa8'
 		5f37de85-db79-432a-b89c-c10c60999fa8 Import2_ACCOUNT 0 2026-07-09 06:51:27 2026-07-09 06:51:27 809d1dd6-706d-41f2-b44f-f0565e8a15fb YToxOntzOjEzOiJsaXN0dmlld09yZGVyIjthOjI6e3M6Nzoib3...
编辑 编辑 复制 复制 删除 删除
DELETE FROM user_preferences WHERE `user_preferences`.`id` = '60e4a8d3-dd8f-4a16-a9d7-4116fc0c069c'
 		60e4a8d3-dd8f-4a16-a9d7-4116fc0c069c Import2_CONTACT 0 2026-07-09 07:28:19 2026-07-09 07:28:19 809d1dd6-706d-41f2-b44f-f0565e8a15fb YToxOntzOjEzOiJsaXN0dmlld09yZGVyIjthOjI6e3M6Nzoib3...
编辑 编辑 复制 复制 删除 删除
DELETE FROM user_preferences WHERE `user_preferences`.`id` = '673b6920-f745-40e6-8e5e-a255f367d476'
 		673b6920-f745-40e6-8e5e-a255f367d476 Home2_OPPORTUNITY 0 2026-07-02 08:02:04 2026-07-27 09:44:19 809d1dd6-706d-41f2-b44f-f0565e8a15fb YToxOntzOjEzOiJsaXN0dmlld09yZGVyIjthOjI6e3M6Nzoib3...
编辑 编辑 复制 复制 删除 删除
DELETE FROM user_preferences WHERE `user_preferences`.`id` = '678323bd-55a7-46c2-994a-dca5389d6ea9'
 		678323bd-55a7-46c2-994a-dca5389d6ea9 Accounts:Support 0 2026-07-13 03:08:45 2026-07-13 03:08:47 809d1dd6-706d-41f2-b44f-f0565e8a15fb YTowOnt9
编辑 编辑 复制 复制 删除 删除
DELETE FROM user_preferences WHERE `user_preferences`.`id` = '6a4c7a1b-04d2-44c0-9e4a-08df0a6a7942'
 		6a4c7a1b-04d2-44c0-9e4a-08df0a6a7942 Accounts:Sales 0 2026-07-13 03:08:45 2026-07-13 03:08:47 809d1dd6-706d-41f2-b44f-f0565e8a15fb YTowOnt9
编辑 编辑 复制 复制 删除 删除
DELETE FROM user_preferences WHERE `user_preferences`.`id` = '6c2a49ad-49de-42cd-a968-3139451d56f4'
 		6c2a49ad-49de-42cd-a968-3139451d56f4 AOS_Quotes:Collaboration 0 2026-07-13 03:08:45 2026-07-13 03:08:47 809d1dd6-706d-41f2-b44f-f0565e8a15fb YTowOnt9
选中项： 选中项：
|
|
|
|
过滤行:
按索引排序：
查询结果操作 复制到剪贴板 复制到剪贴板 导出 导出 显示图表 显示图表 新建视图 新建视图
将此 SQL 查询加为书签 将此 SQL 查询加为书签