将文件拖动至此

SQL 上传 ( 0 ) x -

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





崩溃 扩展 重新查询 编辑 解析 性能分析 书签 查询失败 数据库 : 查询时间 :
v 显示/隐藏表格列表 全屏查看 从其他数据库中添加表 折角连接 / 直接连接 对齐网格 v 全部收缩/展开 反向收缩/展开 显示/隐藏关系线 生成查询 > 移动菜单 > 固定文字
v v
数据表数量： 0
v peopleteam_HESK hesk_attachments
* att_id : mediumint(8) unsigned
* ticket_id : varchar(13)
* saved_name : varchar(255)
* real_name : varchar(255)
* size : int(10) unsigned
* type : enum('0','1')
v peopleteam_HESK hesk_auth_tokens
* id : int(11) unsigned
* selector : char(12)
* token : char(64)
* user_id : smallint(5) unsigned
* created : timestamp
* expires : timestamp
v peopleteam_HESK hesk_banned_emails
* id : smallint(5) unsigned
* email : varchar(255)
* banned_by : smallint(5) unsigned
* dt : timestamp
v peopleteam_HESK hesk_banned_ips
* id : smallint(5) unsigned
* ip_from : int(10) unsigned
* ip_to : int(10) unsigned
* ip_display : varchar(100)
* banned_by : smallint(5) unsigned
* dt : timestamp
v peopleteam_HESK hesk_categories
* id : smallint(5) unsigned
* name : varchar(255)
* cat_order : smallint(5) unsigned
* autoassign : enum('0','1')
* autoassign_config : varchar(1000)
* type : enum('0','1')
* priority : enum('0','1','2','3')
* default_due_date_amount : int(11)
* default_due_date_unit : varchar(10)
v peopleteam_HESK hesk_custom_fields
* id : tinyint(3) unsigned
* use : enum('0','1','2')
* place : enum('0','1')
* type : varchar(20)
* req : enum('0','1','2')
* category : text
* name : text
* value : text
* order : smallint(5) unsigned
v peopleteam_HESK hesk_custom_statuses
* id : tinyint(3) unsigned
* name : text
* color : varchar(6)
* can_customers_change : enum('0','1')
* order : smallint(5) unsigned
v peopleteam_HESK hesk_kb_articles
* id : smallint(5) unsigned
* catid : smallint(5) unsigned
* dt : timestamp
* author : smallint(5) unsigned
* subject : varchar(255)
* content : mediumtext
* keywords : mediumtext
* rating : float
* votes : mediumint(8) unsigned
* views : mediumint(8) unsigned
* type : enum('0','1','2')
* html : enum('0','1')
* sticky : enum('0','1')
* art_order : smallint(5) unsigned
* history : mediumtext
* attachments : mediumtext
v peopleteam_HESK hesk_kb_attachments
* att_id : mediumint(8) unsigned
* saved_name : varchar(255)
* real_name : varchar(255)
* size : int(10) unsigned
v peopleteam_HESK hesk_kb_categories
* id : smallint(5) unsigned
* name : varchar(255)
* parent : smallint(5) unsigned
* articles : smallint(5) unsigned
* articles_private : smallint(5) unsigned
* articles_draft : smallint(5) unsigned
* cat_order : smallint(5) unsigned
* type : enum('0','1')
v peopleteam_HESK hesk_logins
* id : int(10) unsigned
* ip : varchar(45)
* number : tinyint(3) unsigned
* last_attempt : timestamp
v peopleteam_HESK hesk_log_overdue
* id : int(10) unsigned
* dt : timestamp
* ticket : mediumint(8) unsigned
* category : smallint(5) unsigned
* priority : enum('0','1','2','3')
* status : tinyint(3) unsigned
* owner : smallint(5) unsigned
* due_date : timestamp
* comments : varchar(255)
v peopleteam_HESK hesk_mail
* id : int(10) unsigned
* from : smallint(5) unsigned
* to : smallint(5) unsigned
* subject : varchar(255)
* message : mediumtext
* dt : timestamp
* read : enum('0','1')
* deletedby : smallint(5) unsigned
v peopleteam_HESK hesk_mfa_backup_codes
* id : int(10) unsigned
* dt : timestamp
* user_id : smallint(5) unsigned
* code : varchar(255)
v peopleteam_HESK hesk_mfa_verification_tokens
* id : int(10) unsigned
* user_id : smallint(5) unsigned
* verification_token : varchar(255)
* expires_at : timestamp
v peopleteam_HESK hesk_notes
* id : mediumint(8) unsigned
* ticket : mediumint(8) unsigned
* who : smallint(5) unsigned
* dt : timestamp
* message : mediumtext
* attachments : mediumtext
v peopleteam_HESK hesk_oauth_providers
* id : int(11) unsigned
* name : varchar(255)
* authorization_url : text
* token_url : text
* client_id : text
* client_secret : text
* scope : text
* no_val_ssl : tinyint(4)
* verified : smallint(6)
v peopleteam_HESK hesk_oauth_tokens
* id : int(11) unsigned
* provider_id : int(11)
* token_value : text
* token_type : varchar(32)
* created : timestamp
* expires : timestamp
v peopleteam_HESK hesk_online
* id : int(10) unsigned
* user_id : smallint(5) unsigned
* dt : timestamp
* tmp : int(11) unsigned
v peopleteam_HESK hesk_pipe_loops
* id : int(10) unsigned
* email : varchar(255)
* hits : smallint(1) unsigned
* message_hash : char(32)
* dt : timestamp
v peopleteam_HESK hesk_replies
* id : mediumint(8) unsigned
* replyto : mediumint(8) unsigned
* name : varchar(255)
* message : mediumtext
* message_html : mediumtext
* dt : timestamp
* attachments : mediumtext
* staffid : smallint(5) unsigned
* rating : enum('1','5')
* read : enum('0','1')
v peopleteam_HESK hesk_reply_drafts
* id : int(10) unsigned
* owner : smallint(5) unsigned
* ticket : mediumint(8) unsigned
* message : mediumtext
* message_html : mediumtext
* dt : timestamp
v peopleteam_HESK hesk_reset_password
* id : mediumint(8) unsigned
* user : smallint(5) unsigned
* hash : char(40)
* ip : varchar(45)
* dt : timestamp
v peopleteam_HESK hesk_service_messages
* id : smallint(5) unsigned
* dt : timestamp
* author : smallint(5) unsigned
* title : varchar(255)
* message : mediumtext
* language : varchar(50)
* style : enum('0','1','2','3','4')
* type : enum('0','1')
* order : smallint(5) unsigned
v peopleteam_HESK hesk_std_replies
* id : smallint(5) unsigned
* title : varchar(100)
* message : mediumtext
* message_html : mediumtext
* reply_order : smallint(5) unsigned
v peopleteam_HESK hesk_temp_attachments
* att_id : mediumint(8) unsigned
* unique_id : varchar(255)
* saved_name : varchar(255)
* real_name : varchar(255)
* size : int(10) unsigned
* expires_at : timestamp
v peopleteam_HESK hesk_temp_attachments_limits
* ip : varchar(45)
* upload_count : int(10) unsigned
* last_upload_at : timestamp
v peopleteam_HESK hesk_tickets
* id : mediumint(8) unsigned
* trackid : varchar(13)
* name : varchar(255)
* email : varchar(1000)
* category : smallint(5) unsigned
* priority : enum('0','1','2','3')
* subject : varchar(255)
* message : mediumtext
* message_html : mediumtext
* dt : timestamp
* lastchange : timestamp
* firstreply : timestamp
* closedat : timestamp
* articles : varchar(255)
* ip : varchar(45)
* language : varchar(50)
* status : tinyint(3) unsigned
* openedby : mediumint(8)
* firstreplyby : smallint(5) unsigned
* closedby : mediumint(8)
* replies : smallint(5) unsigned
* staffreplies : smallint(5) unsigned
* owner : smallint(5) unsigned
* assignedby : mediumint(8)
* time_worked : time
* lastreplier : enum('0','1')
* replierid : smallint(5) unsigned
* archive : enum('0','1')
* locked : enum('0','1')
* attachments : mediumtext
* merged : mediumtext
* history : mediumtext
* custom1 : mediumtext
* custom2 : mediumtext
* custom3 : mediumtext
* custom4 : mediumtext
* custom5 : mediumtext
* custom6 : mediumtext
* custom7 : mediumtext
* custom8 : mediumtext
* custom9 : mediumtext
* custom10 : mediumtext
* custom11 : mediumtext
* custom12 : mediumtext
* custom13 : mediumtext
* custom14 : mediumtext
* custom15 : mediumtext
* custom16 : mediumtext
* custom17 : mediumtext
* custom18 : mediumtext
* custom19 : mediumtext
* custom20 : mediumtext
* custom21 : mediumtext
* custom22 : mediumtext
* custom23 : mediumtext
* custom24 : mediumtext
* custom25 : mediumtext
* custom26 : mediumtext
* custom27 : mediumtext
* custom28 : mediumtext
* custom29 : mediumtext
* custom30 : mediumtext
* custom31 : mediumtext
* custom32 : mediumtext
* custom33 : mediumtext
* custom34 : mediumtext
* custom35 : mediumtext
* custom36 : mediumtext
* custom37 : mediumtext
* custom38 : mediumtext
* custom39 : mediumtext
* custom40 : mediumtext
* custom41 : mediumtext
* custom42 : mediumtext
* custom43 : mediumtext
* custom44 : mediumtext
* custom45 : mediumtext
* custom46 : mediumtext
* custom47 : mediumtext
* custom48 : mediumtext
* custom49 : mediumtext
* custom50 : mediumtext
* due_date : timestamp
* overdue_email_sent : tinyint(1)
* satisfaction_email_sent : tinyint(1)
* satisfaction_email_dt : timestamp
v peopleteam_HESK hesk_ticket_templates
* id : smallint(5) unsigned
* title : varchar(100)
* message : mediumtext
* message_html : mediumtext
* tpl_order : smallint(5) unsigned
v peopleteam_HESK hesk_users
* id : smallint(5) unsigned
* user : varchar(255)
* pass : varchar(255)
* isadmin : enum('0','1')
* name : varchar(255)
* email : varchar(255)
* signature : varchar(1000)
* language : varchar(50)
* categories : varchar(500)
* afterreply : enum('0','1','2')
* autostart : enum('0','1')
* autoreload : smallint(5) unsigned
* notify_customer_new : enum('0','1')
* notify_customer_reply : enum('0','1')
* show_suggested : enum('0','1')
* notify_new_unassigned : enum('0','1')
* notify_new_my : enum('0','1')
* notify_reply_unassigned : enum('0','1')
* notify_reply_my : enum('0','1')
* notify_assigned : enum('0','1')
* notify_pm : enum('0','1')
* notify_note : enum('0','1')
* notify_overdue_unassigned : enum('0','1')
* notify_overdue_my : enum('0','1')
* default_list : varchar(255)
* autoassign : enum('0','1')
* heskprivileges : varchar(1000)
* ratingneg : mediumint(8) unsigned
* ratingpos : mediumint(8) unsigned
* rating : float
* replies : mediumint(8) unsigned
* mfa_enrollment : smallint(5) unsigned
* mfa_secret : varchar(255)
创建关系
FOREIGN KEY
on delete
on update
删除关系
WHERE
关系运算符
值
子查询
改名为
新名称
聚合
运算符
GROUP BY
ORDER BY
HAVING
运算符
关系运算符
值
子查询
改名为
新名称
HAVING
运算符
运算符
值
子查询
聚合
运算符
WHERE
运算符
值
子查询
当前选项