Drop files here

SQL upload ( 0 ) x-

Server: localhost »Database: mysql »Table: help_topic"help topics"
Page-related settingsClick on the bar to scroll to top of page
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
xxxxxxxxxx
 
Options
Set default





Collapse Expand Requery Edit Explain Profiling Bookmark Query failed Database: Queried time:

Browse mode

Customize browse mode.

Documentation Use only icons, only text or both.
Documentation Use only icons, only text or both.
Documentation Whether a user should be displayed a "show all (rows)" button.
Documentation Number of rows displayed when browsing a result set. If the result set contains more rows, "Previous" and "Next" links will be shown.
Documentation SMART - i.e. descending order for columns of type TIME, DATE, DATETIME and TIMESTAMP, ascending order otherwise.
Documentation Highlight row pointed by the mouse cursor.
Documentation Highlight selected rows.
Documentation
Documentation
Documentation Repeat the headers every X cells, 0 deactivates this feature.
Documentation Maximum number of characters shown in any non-numeric column on browse view.
Documentation These are Edit, Copy and Delete links.
Documentation Whether to show row links even in the absence of a unique key.
Documentation Default sort order for tables with a primary key.
Documentation When browsing tables, the sorting of each table is remembered.
Documentation For display Options
Showing rows 0 - 24 (508 total, Query took 0.0015 seconds.)
SELECT * FROM `help_topic`
SELECT * FROM `help_topic`

Full texts help_topic_id name help_category_id description example url
0 MIN 16 Syntax:
MIN([DISTINCT] expr)

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

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

Returns 1 or 0 to indicate whethe...
https://mariadb.com/kb/en/contains/
5 SRID 36 SRID(g)

Returns an integer indicating the Spatial...
MariaDB> SELECT SRID(GeomFromText('LineString(1 1,...
MariaDB> SELECT SRID(GeomFromText('LineString(1 1,...
https://mariadb.com/kb/en/srid/
6 CURRENT_TIMESTAMP 31 Syntax:
CURRENT_TIMESTAMP, CURRENT_TIMESTAMP()

CU...
https://mariadb.com/kb/en/current_timestamp/
7 SHOW CONTRIBUTORS 26 Syntax:
SHOW CONTRIBUTORS

The SHOW CONTRIBUTORS s...
https://mariadb.com/kb/en/show-contributors/
8 VARIANCE 16 Syntax:
VARIANCE(expr)

Returns the population sta...
https://mariadb.com/kb/en/variance/
9 DROP SERVER 39 Syntax:
DROP SERVER [ IF EXISTS ] server_name

Dro...
https://mariadb.com/kb/en/drop-server/
10 SHOW AUTHORS 26 Syntax:
SHOW AUTHORS

The SHOW AUTHORS statement d...
https://mariadb.com/kb/en/show-authors/
11 VAR_SAMP 16 Syntax:
VAR_SAMP(expr)

Returns the sample varianc...
https://mariadb.com/kb/en/var_samp/
12 CONCAT 37 Syntax:
CONCAT(str1,str2,...)

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

CHAR() i...
MariaDB> SELECT CHAR(77,121,83,81,'76');
        -...
MariaDB> SELECT CHAR(77,121,83,81,'76'); -...
https://mariadb.com/kb/en/char-function/
15 DATETIME 22 DATETIME

A date and time combination. The support...
https://mariadb.com/kb/en/datetime/
16 SHOW CREATE TRIGGER 26 Syntax:
SHOW CREATE TRIGGER trigger_name

This sta...
https://mariadb.com/kb/en/show-create-trigger/
17 SHOW CREATE PROCEDURE 26 Syntax:
SHOW CREATE PROCEDURE proc_name

This stat...
MariaDB> SHOW CREATE PROCEDURE test.simpleproc\G
*...
MariaDB> SHOW CREATE PROCEDURE test.simpleproc\G *...
https://mariadb.com/kb/en/show-create-procedure/
18 OPEN 23 Syntax:
OPEN cursor_name

This statement opens a p...
https://mariadb.com/kb/en/open/
19 INTEGER 22 INTEGER[(M)] [UNSIGNED] [ZEROFILL]

This type is a...
https://mariadb.com/kb/en/sql_language-data_types-int
20 LOWER 37 Syntax:
LOWER(str)

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

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

MariaDB> SELECT MONTH('2008-02-03'); -> 2
https://mariadb.com/kb/en/month/
24 TINYINT 22 TINYINT[(M)] [UNSIGNED] [ZEROFILL]

A very small i...
https://mariadb.com/kb/en/tinyint/