将文件拖动至此

SQL 上传 ( 0 ) x -

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





崩溃 扩展 重新查询 编辑 解析 性能分析 书签 查询失败 数据库 : 查询时间 :
自定义浏览模式。
浏览模式
文档 仅使用图标、文字或都使用。 还原为默认值
文档 仅使用图标、文字或都使用。 还原为默认值
文档 设置是否给用户显示一个 "显示所有 (记录)" 的按钮。 还原为默认值
文档 浏览结果集时显示的行数。若结果集总行数超过该值，将会显示 "上一页" 和 "下一页" 的链接。 还原为默认值
文档 SMART - 即对 TIME、DATE、DATETIME 和 TIMESTAMP 类型的字段递减排序，其它字段递增。 还原为默认值
文档 高亮鼠标指针所在的行。 还原为默认值
文档 高亮选中的行。 还原为默认值
文档 还原为默认值
文档 还原为默认值
文档 每 X 单元格重复表头，要禁止此功能请设为 0。 还原为默认值
文档 浏览非数字字段时最多显示的字数。 还原为默认值
文档 这些是编辑、复制和删除链接。 还原为默认值
文档 缺少唯一键时是否显示行链接。 还原为默认值
文档 默认用主键为表排序。 还原为默认值
文档 当浏览表时使用上次的排序方式。 还原为默认值
文档 显示选项 还原为默认值 
SELECT * FROM `relationships`
[ 编辑内嵌 ] [ 编辑 ] [ 解析 SQL ] [ 创建 PHP 代码 ] [ 刷新 ]
|
|
|
|
过滤行:
按索引排序：
完整内容 id relationship_name lhs_module lhs_table lhs_key rhs_module rhs_table rhs_key join_table join_key_lhs join_key_rhs relationship_type relationship_role_column relationship_role_column_value reverse deleted
编辑 编辑 复制 复制 删除 删除
DELETE FROM relationships WHERE `relationships`.`id` = '00ab1f17-984f-4440-ba30-d96f02952c2d'
 		00ab1f17-984f-4440-ba30-d96f02952c2d aos_contracts_calls AOS_Contracts aos_contracts id Calls calls parent_id NULL NULL NULL one-to-many parent_type AOS_Contracts 0 0
编辑 编辑 复制 复制 删除 删除
DELETE FROM relationships WHERE `relationships`.`id` = '01349291-be47-4240-b970-579998c562a3'
 		01349291-be47-4240-b970-579998c562a3 campaigns_created_by Users users id Campaigns campaigns created_by NULL NULL NULL one-to-many NULL NULL 0 0
编辑 编辑 复制 复制 删除 删除
DELETE FROM relationships WHERE `relationships`.`id` = '01b50c63-0a5e-4ca7-a7c6-11c27479bce1'
 		01b50c63-0a5e-4ca7-a7c6-11c27479bce1 emailtemplates_assigned_user Users users id EmailTemplates email_templates assigned_user_id NULL NULL NULL one-to-many NULL NULL 0 0
编辑 编辑 复制 复制 删除 删除
DELETE FROM relationships WHERE `relationships`.`id` = '02090d28-f9aa-4a30-861e-d59b39d4aeed'
 		02090d28-f9aa-4a30-861e-d59b39d4aeed contact_aos_quotes Contacts contacts id AOS_Quotes aos_quotes billing_contact_id NULL NULL NULL one-to-many NULL NULL 0 0
编辑 编辑 复制 复制 删除 删除
DELETE FROM relationships WHERE `relationships`.`id` = '0224a6ef-237f-447d-83d8-908f4089aab9'
 		0224a6ef-237f-447d-83d8-908f4089aab9 account_meetings Accounts accounts id Meetings meetings parent_id NULL NULL NULL one-to-many parent_type Accounts 0 0
编辑 编辑 复制 复制 删除 删除
DELETE FROM relationships WHERE `relationships`.`id` = '03213979-4000-434d-8f5b-ae437844dd58'
 		03213979-4000-434d-8f5b-ae437844dd58 securitygroups_acl_roles SecurityGroups securitygroups id ACLRoles acl_roles id securitygroups_acl_roles securitygroup_id role_id many-to-many NULL NULL 0 0
编辑 编辑 复制 复制 删除 删除
DELETE FROM relationships WHERE `relationships`.`id` = '034599f5-9c6c-40d6-abb2-1b61f585ae81'
 		034599f5-9c6c-40d6-abb2-1b61f585ae81 aok_knowledgebase_assigned_user Users users id AOK_KnowledgeBase aok_knowledgebase assigned_user_id NULL NULL NULL one-to-many NULL NULL 0 0
编辑 编辑 复制 复制 删除 删除
DELETE FROM relationships WHERE `relationships`.`id` = '035469c3-be72-41b1-b14f-5a22ab97bd76'
 		035469c3-be72-41b1-b14f-5a22ab97bd76 securitygroups_calendaraccount SecurityGroups securitygroups id CalendarAccount calendar_accounts id securitygroups_records securitygroup_id record_id many-to-many module CalendarAccount 0 0
编辑 编辑 复制 复制 删除 删除
DELETE FROM relationships WHERE `relationships`.`id` = '03edaad8-c60e-4003-ada7-0a59c7a99892'
 		03edaad8-c60e-4003-ada7-0a59c7a99892 emails_modified_user Users users id Emails emails modified_user_id NULL NULL NULL one-to-many NULL NULL 0 0
编辑 编辑 复制 复制 删除 删除
DELETE FROM relationships WHERE `relationships`.`id` = '046832ea-6795-4b4e-9de6-987803dd01e2'
 		046832ea-6795-4b4e-9de6-987803dd01e2 templatesectionline_created_by Users users id TemplateSectionLine templatesectionline created_by NULL NULL NULL one-to-many NULL NULL 0 0
编辑 编辑 复制 复制 删除 删除
DELETE FROM relationships WHERE `relationships`.`id` = '0480593e-c02e-4c59-b902-7237436fe7e8'
 		0480593e-c02e-4c59-b902-7237436fe7e8 aow_workflow_aow_processed AOW_WorkFlow aow_workflow id AOW_Processed aow_processed aow_workflow_id NULL NULL NULL one-to-many NULL NULL 0 0
编辑 编辑 复制 复制 删除 删除
DELETE FROM relationships WHERE `relationships`.`id` = '04f2dcc7-1021-4c37-b75e-6aa456f0f439'
 		04f2dcc7-1021-4c37-b75e-6aa456f0f439 jjwg_areas_created_by Users users id jjwg_Areas jjwg_areas created_by NULL NULL NULL one-to-many NULL NULL 0 0
编辑 编辑 复制 复制 删除 删除
DELETE FROM relationships WHERE `relationships`.`id` = '05058efa-a364-494e-af7b-b37774f968f9'
 		05058efa-a364-494e-af7b-b37774f968f9 prospect_calls Prospects prospects id Calls calls parent_id NULL NULL NULL one-to-many parent_type Prospects 0 0
编辑 编辑 复制 复制 删除 删除
DELETE FROM relationships WHERE `relationships`.`id` = '0541b07f-0a55-49b9-a700-1a5266bb14a3'
 		0541b07f-0a55-49b9-a700-1a5266bb14a3 aop_case_updates_created_by Users users id AOP_Case_Updates aop_case_updates created_by NULL NULL NULL one-to-many NULL NULL 0 0
编辑 编辑 复制 复制 删除 删除
DELETE FROM relationships WHERE `relationships`.`id` = '05e3f1b2-4341-466c-823c-60267d173a6f'
 		05e3f1b2-4341-466c-823c-60267d173a6f account_cases Accounts accounts id Cases cases account_id NULL NULL NULL one-to-many NULL NULL 0 0
编辑 编辑 复制 复制 删除 删除
DELETE FROM relationships WHERE `relationships`.`id` = '063010b6-07a8-4870-9010-851c251f135c'
 		063010b6-07a8-4870-9010-851c251f135c bug_meetings Bugs bugs id Meetings meetings parent_id NULL NULL NULL one-to-many parent_type Bugs 0 0
编辑 编辑 复制 复制 删除 删除
DELETE FROM relationships WHERE `relationships`.`id` = '0637d706-2e5b-4773-9765-4e37f391e18b'
 		0637d706-2e5b-4773-9765-4e37f391e18b prospects_modified_user Users users id Prospects prospects modified_user_id NULL NULL NULL one-to-many NULL NULL 0 0
编辑 编辑 复制 复制 删除 删除
DELETE FROM relationships WHERE `relationships`.`id` = '066e96e3-7441-4ef7-9668-e6b6f7b8b658'
 		066e96e3-7441-4ef7-9668-e6b6f7b8b658 alerts_modified_user Users users id Alerts alerts modified_user_id NULL NULL NULL one-to-many NULL NULL 0 0
编辑 编辑 复制 复制 删除 删除
DELETE FROM relationships WHERE `relationships`.`id` = '06b3cc02-e8b7-489d-b893-dbd77f04e6d4'
 		06b3cc02-e8b7-489d-b893-dbd77f04e6d4 accounts_assigned_user Users users id Accounts accounts assigned_user_id NULL NULL NULL one-to-many NULL NULL 0 0
编辑 编辑 复制 复制 删除 删除
DELETE FROM relationships WHERE `relationships`.`id` = '06e7ad5b-8970-426f-9442-bf42ce2ad85b'
 		06e7ad5b-8970-426f-9442-bf42ce2ad85b aos_products_assigned_user Users users id AOS_Products aos_products assigned_user_id NULL NULL NULL one-to-many NULL NULL 0 0
编辑 编辑 复制 复制 删除 删除
DELETE FROM relationships WHERE `relationships`.`id` = '07360c87-f414-4097-bf6a-cafbe7b36816'
 		07360c87-f414-4097-bf6a-cafbe7b36816 jjwg_markers_created_by Users users id jjwg_Markers jjwg_markers created_by NULL NULL NULL one-to-many NULL NULL 0 0
编辑 编辑 复制 复制 删除 删除
DELETE FROM relationships WHERE `relationships`.`id` = '0761136b-f518-43e5-959b-4a1d17428e9a'
 		0761136b-f518-43e5-959b-4a1d17428e9a aor_reports_modified_user Users users id AOR_Reports aor_reports modified_user_id NULL NULL NULL one-to-many NULL NULL 0 0
编辑 编辑 复制 复制 删除 删除
DELETE FROM relationships WHERE `relationships`.`id` = '086e2ba5-fffe-4d9d-8615-95da7ccb3b7e'
 		086e2ba5-fffe-4d9d-8615-95da7ccb3b7e securitygroups_aos_contracts SecurityGroups securitygroups id AOS_Contracts aos_contracts id securitygroups_records securitygroup_id record_id many-to-many module AOS_Contracts 0 0
编辑 编辑 复制 复制 删除 删除
DELETE FROM relationships WHERE `relationships`.`id` = '08b6bc5a-d7fe-4602-b15e-f2f44f786b72'
 		08b6bc5a-d7fe-4602-b15e-f2f44f786b72 aos_products_quotes_created_by Users users id AOS_Products_Quotes aos_products_quotes created_by NULL NULL NULL one-to-many NULL NULL 0 0
编辑 编辑 复制 复制 删除 删除
DELETE FROM relationships WHERE `relationships`.`id` = '08bb12bf-3ee9-4d8e-a701-095798653d27'
 		08bb12bf-3ee9-4d8e-a701-095798653d27 emails_accounts_rel Emails emails id Accounts accounts id emails_beans email_id bean_id many-to-many bean_module Accounts 0 0
选中项： 选中项：
|
|
|
|
过滤行:
按索引排序：
查询结果操作 复制到剪贴板 复制到剪贴板 导出 导出 显示图表 显示图表 新建视图 新建视图
将此 SQL 查询加为书签 将此 SQL 查询加为书签