Drop files here

SQL upload ( 0 ) x -

Page-related settings Click on the bar to scroll to top of page
Press Ctrl+Enter to execute query Press Enter to execute query
ascending
descending
Order:
Debug SQL
Count
Execution order
Time taken
Order by:
Group queries
Ungroup queries
Collapse Expand Show trace Hide trace Count: Time taken:
Bookmarks
Refresh
Add
No bookmarks
Add bookmark
Options
Set default
Collapse Expand Requery Edit Explain Profiling Bookmark Query failed Database: Queried time:
Browse mode
Customise browse mode.
Browse mode
Documentation Use only icons, only text or both. Restore default value
Documentation Use only icons, only text or both. Restore default value
Documentation Whether a user should be displayed a "show all (rows)" button. Restore default value
Documentation Number of rows displayed when browsing a result set. If the result set contains more rows, "Previous" and "Next" links will be shown. Restore default value
Documentation SMART - i.e. descending order for columns of type TIME, DATE, DATETIME and TIMESTAMP, ascending order otherwise. Restore default value
Documentation Highlight row pointed by the mouse cursor. Restore default value
Documentation Highlight selected rows. Restore default value
Documentation Restore default value
Documentation Restore default value
Documentation Repeat the headers every X cells, 0 deactivates this feature. Restore default value
Documentation Maximum number of characters shown in any non-numeric column on browse view. Restore default value
Documentation These are Edit, Copy and Delete links. Restore default value
Documentation Whether to show row links even in the absence of a unique key. Restore default value
Documentation Default sort order for tables with a primary key. Restore default value
Documentation When browsing tables, the sorting of each table is remembered. Restore default value
Documentation For display Options Restore default value
SELECT * FROM `help_topic`
Edit inline ] [ Edit ] [ Explain SQL ] [ Create PHP code ] [ Refresh ]
Full texts help_topic_id name help_category_id description example url
Edit Edit Copy Copy Delete Delete
DELETE FROM help_topic WHERE `help_topic`.`help_topic_id` = 0
0 MIN 16 Syntax:
MIN([DISTINCT] expr)

Returns the minimum ...
MariaDB> SELECT student_name, MIN(test_score), MAX...
https://mariadb.com/kb/en/min/
Edit Edit Copy Copy Delete Delete
DELETE FROM help_topic WHERE `help_topic`.`help_topic_id` = 1
1 JOIN 27 MySQL supports the following JOIN syntaxes for the...
SELECT left_tbl.*
  FROM left_tbl LEFT JOIN right_...
https://mariadb.com/kb/en/join-syntax/
Edit Edit Copy Copy Delete Delete
DELETE FROM help_topic WHERE `help_topic`.`help_topic_id` = 2
2 HEX 37 Syntax:
HEX(str), HEX(N)

For a string argument st...
MariaDB> SELECT 0x616263, HEX('abc'), UNHEX(HEX('a...
https://mariadb.com/kb/en/hex/
Edit Edit Copy Copy Delete Delete
DELETE FROM help_topic WHERE `help_topic`.`help_topic_id` = 3
3 REPLACE 27 Syntax:
REPLACE [LOW_PRIORITY | DELAYED]
   [INTO...
https://mariadb.com/kb/en/replace/
Edit Edit Copy Copy Delete Delete
DELETE FROM help_topic WHERE `help_topic`.`help_topic_id` = 4
4 CONTAINS 30 Contains(g1,g2)

Returns 1 or 0 to indicate whethe...
https://mariadb.com/kb/en/contains/
Edit Edit Copy Copy Delete Delete
DELETE FROM help_topic WHERE `help_topic`.`help_topic_id` = 5
5 SRID 36 SRID(g)

Returns an integer indicating the Spatial...
MariaDB> SELECT SRID(GeomFromText('LineString(1 1,...
https://mariadb.com/kb/en/srid/
Edit Edit Copy Copy Delete Delete
DELETE FROM help_topic WHERE `help_topic`.`help_topic_id` = 6
6 CURRENT_TIMESTAMP 31 Syntax:
CURRENT_TIMESTAMP, CURRENT_TIMESTAMP()

CU...
https://mariadb.com/kb/en/current_timestamp/
Edit Edit Copy Copy Delete Delete
DELETE FROM help_topic WHERE `help_topic`.`help_topic_id` = 7
7 SHOW CONTRIBUTORS 26 Syntax:
SHOW CONTRIBUTORS

The SHOW CONTRIBUTORS s...
https://mariadb.com/kb/en/show-contributors/
Edit Edit Copy Copy Delete Delete
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/
Edit Edit Copy Copy Delete Delete
DELETE FROM help_topic WHERE `help_topic`.`help_topic_id` = 9
9 DROP SERVER 39 Syntax:
DROP SERVER [ IF EXISTS ] server_name

Dro...
https://mariadb.com/kb/en/drop-server/
Edit Edit Copy Copy Delete Delete
DELETE FROM help_topic WHERE `help_topic`.`help_topic_id` = 10
10 SHOW AUTHORS 26 Syntax:
SHOW AUTHORS

The SHOW AUTHORS statement d...
https://mariadb.com/kb/en/show-authors/
Edit Edit Copy Copy Delete Delete
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/
Edit Edit Copy Copy Delete Delete
DELETE FROM help_topic WHERE `help_topic`.`help_topic_id` = 12
12 CONCAT 37 Syntax:
CONCAT(str1,str2,...)

Returns the string ...
MariaDB> SELECT CONCAT('My', 'S', 'QL');
        -...
https://mariadb.com/kb/en/concat/
Edit Edit Copy Copy Delete Delete
DELETE FROM help_topic WHERE `help_topic`.`help_topic_id` = 13
13 GEOMETRY HIERARCHY 34 Geometry is the base class. It is an abstract clas... https://mariadb.com/kb/en/geometry-hierarchy/
Edit Edit Copy Copy Delete Delete
DELETE FROM help_topic WHERE `help_topic`.`help_topic_id` = 14
14 CHAR FUNCTION 37 Syntax:
CHAR(N,... [USING charset_name])

CHAR() i...
MariaDB> SELECT CHAR(77,121,83,81,'76');
        -...
https://mariadb.com/kb/en/char-function/
Edit Edit Copy Copy Delete Delete
DELETE FROM help_topic WHERE `help_topic`.`help_topic_id` = 15
15 DATETIME 22 DATETIME

A date and time combination. The support...
https://mariadb.com/kb/en/datetime/
Edit Edit Copy Copy Delete Delete
DELETE FROM help_topic WHERE `help_topic`.`help_topic_id` = 16
16 SHOW CREATE TRIGGER 26 Syntax:
SHOW CREATE TRIGGER trigger_name

This sta...
https://mariadb.com/kb/en/show-create-trigger/
Edit Edit Copy Copy Delete Delete
DELETE FROM help_topic WHERE `help_topic`.`help_topic_id` = 17
17 SHOW CREATE PROCEDURE 26 Syntax:
SHOW CREATE PROCEDURE proc_name

This stat...
MariaDB> SHOW CREATE PROCEDURE test.simpleproc\G
*...
https://mariadb.com/kb/en/show-create-procedure/
Edit Edit Copy Copy Delete Delete
DELETE FROM help_topic WHERE `help_topic`.`help_topic_id` = 18
18 OPEN 23 Syntax:
OPEN cursor_name

This statement opens a p...
https://mariadb.com/kb/en/open/
Edit Edit Copy Copy Delete Delete
DELETE FROM help_topic WHERE `help_topic`.`help_topic_id` = 19
19 INTEGER 22 INTEGER[(M)] [UNSIGNED] [ZEROFILL]

This type is a...
https://mariadb.com/kb/en/sql_language-data_types-int
Edit Edit Copy Copy Delete Delete
DELETE FROM help_topic WHERE `help_topic`.`help_topic_id` = 20
20 LOWER 37 Syntax:
LOWER(str)

Returns the string str with al...
https://mariadb.com/kb/en/lower/
Edit Edit Copy Copy Delete Delete
DELETE FROM help_topic WHERE `help_topic`.`help_topic_id` = 21
21 SHOW COLUMNS 26 Syntax:
SHOW [FULL] COLUMNS {FROM | IN} tbl_name [...
https://mariadb.com/kb/en/show-columns/
Edit Edit Copy Copy Delete Delete
DELETE FROM help_topic WHERE `help_topic`.`help_topic_id` = 22
22 CREATE TRIGGER 39 Syntax:
CREATE
   [DEFINER = { user | CURRENT_USE...
https://mariadb.com/kb/en/create-trigger/
Edit Edit Copy Copy Delete Delete
DELETE FROM help_topic WHERE `help_topic`.`help_topic_id` = 23
23 MONTH 31 Syntax:
MONTH(date)

Returns the month for date, i...
MariaDB> SELECT MONTH('2008-02-03');
        -> 2

https://mariadb.com/kb/en/month/
Edit Edit Copy Copy Delete Delete
DELETE FROM help_topic WHERE `help_topic`.`help_topic_id` = 24
24 TINYINT 22 TINYINT[(M)] [UNSIGNED] [ZEROFILL]

A very small i...
https://mariadb.com/kb/en/tinyint/
With selected: With selected:
Query results operations
Bookmark this SQL query Bookmark this SQL query