将文件拖动至此

SQL 上传 ( 0 ) x -

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





崩溃 扩展 重新查询 编辑 解析 性能分析 书签 查询失败 数据库 : 查询时间 :
浏览模式
自定义浏览模式。
浏览模式
文档 仅使用图标、文字或都使用。 还原为默认值
文档 仅使用图标、文字或都使用。 还原为默认值
文档 设置是否给用户显示一个 "显示所有 (记录)" 的按钮。 还原为默认值
文档 浏览结果集时显示的行数。若结果集总行数超过该值,将会显示 "上一页" 和 "下一页" 的链接。 还原为默认值
文档 SMART - 即对 TIME、DATE、DATETIME 和 TIMESTAMP 类型的字段递减排序,其它字段递增。 还原为默认值
文档 高亮鼠标指针所在的行。 还原为默认值
文档 高亮选中的行。 还原为默认值
文档 还原为默认值
文档 还原为默认值
文档 每 X 单元格重复表头,要禁止此功能请设为 0 还原为默认值
文档 浏览非数字字段时最多显示的字数。 还原为默认值
文档 这些是编辑、复制和删除链接。 还原为默认值
文档 缺少唯一键时是否显示行链接。 还原为默认值
文档 默认用主键为表排序。 还原为默认值
文档 当浏览表时使用上次的排序方式。 还原为默认值
文档 显示选项 还原为默认值
SELECT * FROM `help_topic` ORDER BY `help_category_id` DESC 
编辑内嵌 ] [ 编辑 ] [ 解析 SQL ] [ 创建 PHP 代码 ] [ 刷新 ]
完整内容 help_topic_id name help_category_id 递减 递增 1 description example url
编辑 编辑 复制 复制 删除 删除
DELETE FROM help_topic WHERE `help_topic`.`help_topic_id` = 752
752 Full-Text Index Overview 48 MariaDB has support for full-text indexing and sea... https://mariadb.com/kb/en/full-text-index-overview/
编辑 编辑 复制 复制 删除 删除
DELETE FROM help_topic WHERE `help_topic`.`help_topic_id` = 751
751 Instant ADD COLUMN for InnoDB 46 Instant ALTER TABLE ... ADD COLUMN for InnoDB was ... https://mariadb.com/kb/en/instant-add-column-for-innodb/
编辑 编辑 复制 复制 删除 删除
DELETE FROM help_topic WHERE `help_topic`.`help_topic_id` = 744
744 COLUMN_CHECK 44 The COLUMN_CHECK function was added in MariaDB 10.... https://mariadb.com/kb/en/column_check/
编辑 编辑 复制 复制 删除 删除
DELETE FROM help_topic WHERE `help_topic`.`help_topic_id` = 746
746 COLUMN_DELETE 44 The Dynamic columns feature was introduced in Mari... https://mariadb.com/kb/en/column_delete/
编辑 编辑 复制 复制 删除 删除
DELETE FROM help_topic WHERE `help_topic`.`help_topic_id` = 747
747 COLUMN_EXISTS 44 The Dynamic columns feature was introduced in Mari... https://mariadb.com/kb/en/column_exists/
编辑 编辑 复制 复制 删除 删除
DELETE FROM help_topic WHERE `help_topic`.`help_topic_id` = 750
750 COLUMN_LIST 44 The Dynamic columns feature was introduced in Mari... https://mariadb.com/kb/en/column_list/
编辑 编辑 复制 复制 删除 删除
DELETE FROM help_topic WHERE `help_topic`.`help_topic_id` = 743
743 COLUMN_ADD 44 The Dynamic columns feature was introduced in Mari... https://mariadb.com/kb/en/column_add/
编辑 编辑 复制 复制 删除 删除
DELETE FROM help_topic WHERE `help_topic`.`help_topic_id` = 745
745 COLUMN_CREATE 44 The Dynamic columns feature was introduced in Mari... https://mariadb.com/kb/en/column_create/
编辑 编辑 复制 复制 删除 删除
DELETE FROM help_topic WHERE `help_topic`.`help_topic_id` = 748
748 COLUMN_GET 44 The Dynamic columns feature was introduced in Mari... https://mariadb.com/kb/en/column_get/
编辑 编辑 复制 复制 删除 删除
DELETE FROM help_topic WHERE `help_topic`.`help_topic_id` = 749
749 COLUMN_JSON 44 COLUMN_JSON was introduced in MariaDB 10.0.1

Syn...
https://mariadb.com/kb/en/column_json/
编辑 编辑 复制 复制 删除 删除
DELETE FROM help_topic WHERE `help_topic`.`help_topic_id` = 742
742 SPIDER_FLUSH_TABLE_MON_CACHE 43 Syntax
------
SPIDER_FLUSH_TABLE_MON_CACHE()

De...
https://mariadb.com/kb/en/spider_flush_table_mon_cache/
编辑 编辑 复制 复制 删除 删除
DELETE FROM help_topic WHERE `help_topic`.`help_topic_id` = 739
739 SPIDER_BG_DIRECT_SQL 43 Syntax
------
SPIDER_BG_DIRECT_SQL('sql', 'tmp_ta...
https://mariadb.com/kb/en/spider_bg_direct_sql/
编辑 编辑 复制 复制 删除 删除
DELETE FROM help_topic WHERE `help_topic`.`help_topic_id` = 740
740 SPIDER_COPY_TABLES 43 Syntax
------
SPIDER_COPY_TABLES(spider_table_nam...
https://mariadb.com/kb/en/spider_copy_tables/
编辑 编辑 复制 复制 删除 删除
DELETE FROM help_topic WHERE `help_topic`.`help_topic_id` = 741
741 SPIDER_DIRECT_SQL 43 Syntax
------
SPIDER_DIRECT_SQL('sql', 'tmp_table...
https://mariadb.com/kb/en/spider_direct_sql/
编辑 编辑 复制 复制 删除 删除
DELETE FROM help_topic WHERE `help_topic`.`help_topic_id` = 724
724 Aggregate Functions as Window Functions 42 Window functions were first introduced in MariaDB ... https://mariadb.com/kb/en/library/aggregate-functions-as-window-functions/
编辑 编辑 复制 复制 删除 删除
DELETE FROM help_topic WHERE `help_topic`.`help_topic_id` = 726
726 CUME_DIST 42 The CUME_DIST() function was first introduced with... https://mariadb.com/kb/en/cume_dist/
编辑 编辑 复制 复制 删除 删除
DELETE FROM help_topic WHERE `help_topic`.`help_topic_id` = 732
732 NTH_VALUE 42 The NTH_VALUE() function was first introduced with... https://mariadb.com/kb/en/nth_value/
编辑 编辑 复制 复制 删除 删除
DELETE FROM help_topic WHERE `help_topic`.`help_topic_id` = 727
727 DENSE_RANK 42 The DENSE_RANK() function was first introduced wit... https://mariadb.com/kb/en/dense_rank/
编辑 编辑 复制 复制 删除 删除
DELETE FROM help_topic WHERE `help_topic`.`help_topic_id` = 723
723 Window Functions Overview 42 Window functions were introduced in MariaDB 10.2.
...
https://mariadb.com/kb/en/library/window-functions-overview/
编辑 编辑 复制 复制 删除 删除
DELETE FROM help_topic WHERE `help_topic`.`help_topic_id` = 725
725 Window Frames 42 Window functions were first introduced in MariaDB ... https://mariadb.com/kb/en/library/window-frames/
编辑 编辑 复制 复制 删除 删除
DELETE FROM help_topic WHERE `help_topic`.`help_topic_id` = 728
728 FIRST_VALUE 42 The FIRST_VALUE() function was first introduced wi... https://mariadb.com/kb/en/first_value/
编辑 编辑 复制 复制 删除 删除
DELETE FROM help_topic WHERE `help_topic`.`help_topic_id` = 729
729 LAG 42 The LAG() function was first introduced with other... https://mariadb.com/kb/en/lag/
编辑 编辑 复制 复制 删除 删除
DELETE FROM help_topic WHERE `help_topic`.`help_topic_id` = 730
730 LEAD 42 The LEAD() function was first introduced with othe... https://mariadb.com/kb/en/lead/
编辑 编辑 复制 复制 删除 删除
DELETE FROM help_topic WHERE `help_topic`.`help_topic_id` = 731
731 Median Window Function 42 The MEDIAN() window function was first introduced ... https://mariadb.com/kb/en/median/
编辑 编辑 复制 复制 删除 删除
DELETE FROM help_topic WHERE `help_topic`.`help_topic_id` = 733
733 NTILE 42 The NTILE() function was first introduced with win... https://mariadb.com/kb/en/ntile/
选中项: 选中项:
查询结果操作 复制到剪贴板 复制到剪贴板 导出 导出 显示图表 显示图表 新建视图 新建视图
将此 SQL 查询加为书签 将此 SQL 查询加为书签