将文件拖动至此

SQL 上传 ( 0 ) x -

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





崩溃 扩展 重新查询 编辑 解析 性能分析 书签 查询失败 数据库 : 查询时间 :
浏览模式
自定义浏览模式。
浏览模式
文档 仅使用图标、文字或都使用。 还原为默认值
文档 仅使用图标、文字或都使用。 还原为默认值
文档 设置是否给用户显示一个 "显示所有 (记录)" 的按钮。 还原为默认值
文档 浏览结果集时显示的行数。若结果集总行数超过该值,将会显示 "上一页" 和 "下一页" 的链接。 还原为默认值
文档 SMART - 即对 TIME、DATE、DATETIME 和 TIMESTAMP 类型的字段递减排序,其它字段递增。 还原为默认值
文档 高亮鼠标指针所在的行。 还原为默认值
文档 高亮选中的行。 还原为默认值
文档 还原为默认值
文档 还原为默认值
文档 每 X 单元格重复表头,要禁止此功能请设为 0 还原为默认值
文档 浏览非数字字段时最多显示的字数。 还原为默认值
文档 这些是编辑、复制和删除链接。 还原为默认值
文档 缺少唯一键时是否显示行链接。 还原为默认值
文档 默认用主键为表排序。 还原为默认值
文档 当浏览表时使用上次的排序方式。 还原为默认值
文档 显示选项 还原为默认值
SELECT * FROM `help_topic` ORDER BY `url` DESC 
编辑内嵌 ] [ 编辑 ] [ 解析 SQL ] [ 创建 PHP 代码 ] [ 刷新 ]
完整内容 help_topic_id name help_category_id description example url 递减 递增 1
编辑 编辑 复制 复制 删除 删除
DELETE FROM help_topic WHERE `help_topic`.`help_topic_id` = 204
204 YEARWEEK 31 Syntax:
YEARWEEK(date), YEARWEEK(date,mode)

Retur...
MariaDB> SELECT YEARWEEK('1987-01-01');
        ->...
https://mariadb.com/kb/en/yearweek/
编辑 编辑 复制 复制 删除 删除
DELETE FROM help_topic WHERE `help_topic`.`help_topic_id` = 364
364 YEAR 31 Syntax:
YEAR(date)

Returns the year for date, in ...
MariaDB> SELECT YEAR('1987-01-01');
        -> 198...
https://mariadb.com/kb/en/year/
编辑 编辑 复制 复制 删除 删除
DELETE FROM help_topic WHERE `help_topic`.`help_topic_id` = 287
287 YEAR DATA TYPE 22 YEAR[(2|4)]

A year in two-digit or four-digit for...
https://mariadb.com/kb/en/year-data-type/
编辑 编辑 复制 复制 删除 删除
DELETE FROM help_topic WHERE `help_topic`.`help_topic_id` = 400
400 Y 11 Y(p)

Returns the Y-coordinate value for the Point...
MariaDB> SELECT Y(POINT(56.7, 53.34));
+----------...
https://mariadb.com/kb/en/y/
编辑 编辑 复制 复制 删除 删除
DELETE FROM help_topic WHERE `help_topic`.`help_topic_id` = 197
197 XOR 15 Syntax:
XOR

Logical XOR. Returns NULL if either o...
MariaDB> SELECT 1 XOR 1;
        -> 0
MariaDB> SEL...
https://mariadb.com/kb/en/xor/
编辑 编辑 复制 复制 删除 删除
DELETE FROM help_topic WHERE `help_topic`.`help_topic_id` = 317
317 X 11 X(p)

Returns the X-coordinate value for the Point...
MariaDB> SELECT X(POINT(56.7, 53.34));
+----------...
https://mariadb.com/kb/en/x/
编辑 编辑 复制 复制 删除 删除
DELETE FROM help_topic WHERE `help_topic`.`help_topic_id` = 247
247 WKT DEFINITION 3 The Well-Known Text (WKT) representation of Geomet... https://mariadb.com/kb/en/wkt-definition/
编辑 编辑 复制 复制 删除 删除
DELETE FROM help_topic WHERE `help_topic`.`help_topic_id` = 31
31 WITHIN 30 Within(g1,g2)

Returns 1 or 0 to indicate whether ...
https://mariadb.com/kb/en/within/
编辑 编辑 复制 复制 删除 删除
DELETE FROM help_topic WHERE `help_topic`.`help_topic_id` = 496
496 WHILE 23 Syntax:
[begin_label:] WHILE search_condition DO
...
CREATE PROCEDURE dowhile()
BEGIN
  DECLARE v1 INT ...
https://mariadb.com/kb/en/while/
编辑 编辑 复制 复制 删除 删除
DELETE FROM help_topic WHERE `help_topic`.`help_topic_id` = 267
267 WEEKOFYEAR 31 Syntax:
WEEKOFYEAR(date)

Returns the calendar wee...
MariaDB> SELECT WEEKOFYEAR('2008-02-20');
        ...
https://mariadb.com/kb/en/weekofyear/
编辑 编辑 复制 复制 删除 删除
DELETE FROM help_topic WHERE `help_topic`.`help_topic_id` = 371
371 WEEKDAY 31 Syntax:
WEEKDAY(date)

Returns the weekday index f...
MariaDB> SELECT WEEKDAY('2008-02-03 22:23:00');
  ...
https://mariadb.com/kb/en/weekday/
编辑 编辑 复制 复制 删除 删除
DELETE FROM help_topic WHERE `help_topic`.`help_topic_id` = 32
32 WEEK 31 Syntax:
WEEK(date[,mode])

This function returns t...
MariaDB> SELECT WEEK('2008-02-20');
        -> 7
M...
https://mariadb.com/kb/en/week/
编辑 编辑 复制 复制 删除 删除
DELETE FROM help_topic WHERE `help_topic`.`help_topic_id` = 505
505 VERSION 17 Syntax:
VERSION()

Returns a string that indicates...
MariaDB> SELECT VERSION();
        -> '5.5.29-stan...
https://mariadb.com/kb/en/version/
编辑 编辑 复制 复制 删除 删除
DELETE FROM help_topic WHERE `help_topic`.`help_topic_id` = 11
11 VAR_SAMP 16 Syntax:
VAR_SAMP(expr)

Returns the sample varianc...
https://mariadb.com/kb/en/var_samp/
编辑 编辑 复制 复制 删除 删除
DELETE FROM help_topic WHERE `help_topic`.`help_topic_id` = 157
157 VAR_POP 16 Syntax:
VAR_POP(expr)

Returns the population stan...
https://mariadb.com/kb/en/var_pop/
编辑 编辑 复制 复制 删除 删除
DELETE FROM help_topic WHERE `help_topic`.`help_topic_id` = 8
8 VARIANCE 16 Syntax:
VARIANCE(expr)

Returns the population sta...
https://mariadb.com/kb/en/variance/
编辑 编辑 复制 复制 删除 删除
DELETE FROM help_topic WHERE `help_topic`.`help_topic_id` = 257
257 VARCHAR 22 [NATIONAL] VARCHAR(M) [CHARACTER SET charset_name]... https://mariadb.com/kb/en/varchar/
编辑 编辑 复制 复制 删除 删除
DELETE FROM help_topic WHERE `help_topic`.`help_topic_id` = 303
303 VARBINARY 22 VARBINARY(M)

The VARBINARY type is similar to the...
https://mariadb.com/kb/en/varbinary/
编辑 编辑 复制 复制 删除 删除
DELETE FROM help_topic WHERE `help_topic`.`help_topic_id` = 341
341 VALUES 14 Syntax:
VALUES(col_name)

In an INSERT ... ON DUPL...
MariaDB> INSERT INTO table (a,b,c) VALUES (1,2,3),...
https://mariadb.com/kb/en/values/
编辑 编辑 复制 复制 删除 删除
DELETE FROM help_topic WHERE `help_topic`.`help_topic_id` = 412
412 UUID_SHORT 14 Syntax:
UUID_SHORT()

Returns a "short" universal ...
MariaDB> SELECT UUID_SHORT();
        -> 923957838...
https://mariadb.com/kb/en/uuid_short/
编辑 编辑 复制 复制 删除 删除
DELETE FROM help_topic WHERE `help_topic`.`help_topic_id` = 44
44 UUID 14 Syntax:
UUID()

Returns a Universal Unique Identif...
MariaDB> SELECT UUID();
        -> '6ccd780c-baba-...
https://mariadb.com/kb/en/uuid/
编辑 编辑 复制 复制 删除 删除
DELETE FROM help_topic WHERE `help_topic`.`help_topic_id` = 442
442 UTC_TIMESTAMP 31 Syntax:
UTC_TIMESTAMP, UTC_TIMESTAMP()

Returns th...
MariaDB> SELECT UTC_TIMESTAMP(), UTC_TIMESTAMP() +...
https://mariadb.com/kb/en/utc_timestamp/
编辑 编辑 复制 复制 删除 删除
DELETE FROM help_topic WHERE `help_topic`.`help_topic_id` = 404
404 UTC_TIME 31 Syntax:
UTC_TIME, UTC_TIME()

Returns the current ...
MariaDB> SELECT UTC_TIME(), UTC_TIME() + 0;
      ...
https://mariadb.com/kb/en/utc_time/
编辑 编辑 复制 复制 删除 删除
DELETE FROM help_topic WHERE `help_topic`.`help_topic_id` = 431
431 UTC_DATE 31 Syntax:
UTC_DATE, UTC_DATE()

Returns the current ...
MariaDB> SELECT UTC_DATE(), UTC_DATE() + 0;
      ...
https://mariadb.com/kb/en/utc_date/
编辑 编辑 复制 复制 删除 删除
DELETE FROM help_topic WHERE `help_topic`.`help_topic_id` = 461
461 USER 17 Syntax:
USER()

Returns the current MySQL user nam...
MariaDB> SELECT USER();
        -> 'davida@localho...
https://mariadb.com/kb/en/user/
选中项: 选中项:
查询结果操作 复制到剪贴板 复制到剪贴板 导出 导出 显示图表 显示图表 新建视图 新建视图
将此 SQL 查询加为书签 将此 SQL 查询加为书签