Drop files here

SQL upload ( 0 ) x-

Server: 127.0.0.1 »Database: mysql »Table: help_topic“help topics”
Page-related settingsClick 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

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 (529 total, Query took 0.0013 seconds.)
SELECT * FROM `help_topic`
Full textshelp_topic_idnamehelp_category_iddescriptionexampleurl
0 JOIN 28 MySQL supports the following JOIN syntaxes for the...
SELECT left_tbl.*
  FROM left_tbl LEFT JOIN right_...
http://dev.mysql.com/doc/refman/5.6/en/join.html
1 HEX 38 Syntax:
HEX(str), HEX(N)

For a string argument st...
mysql> SELECT 0x616263, HEX('abc'), UNHEX(HEX('abc...
http://dev.mysql.com/doc/refman/5.6/en/string-functions.html
2 CONTAINS 31 Contains(g1,g2)

Returns 1 or 0 to indicate whethe...
http://dev.mysql.com/doc/refman/5.6/en/functions-for-testing-spatial-relations-between-geometric-objects.html
3 SRID 37 SRID(g)

Returns an integer indicating the Spatial...
mysql> SELECT SRID(GeomFromText('LineString(1 1,2 ...
http://dev.mysql.com/doc/refman/5.6/en/geometry-property-functions.html
4 SHOW CONTRIBUTORS 27 Syntax:
SHOW CONTRIBUTORS

The SHOW CONTRIBUTORS s...
http://dev.mysql.com/doc/refman/5.6/en/show-contributors.html
5 VARIANCE 16 Syntax:
VARIANCE(expr)

Returns the population sta...
http://dev.mysql.com/doc/refman/5.6/en/group-by-functions.html
6 DROP SERVER 40 Syntax:
DROP SERVER [ IF EXISTS ] server_name

Dro...
http://dev.mysql.com/doc/refman/5.6/en/drop-server.html
7 SHOW AUTHORS 27 Syntax:
SHOW AUTHORS

The SHOW AUTHORS statement d...
http://dev.mysql.com/doc/refman/5.6/en/show-authors.html
8 CONCAT 38 Syntax:
CONCAT(str1,str2,...)

Returns the string ...
mysql> SELECT CONCAT('My', 'S', 'QL');
        -> ...
http://dev.mysql.com/doc/refman/5.6/en/string-functions.html
9 GEOMETRY HIERARCHY 35 Geometry is the base class. It is an abstract clas... http://dev.mysql.com/doc/refman/5.6/en/gis-geometry-class-hierarchy.html
10 CHAR FUNCTION 38 Syntax:
CHAR(N,... [USING charset_name])

CHAR() i...
mysql> SELECT CHAR(77,121,83,81,'76');
        -> ...
http://dev.mysql.com/doc/refman/5.6/en/string-functions.html
11 SHOW CREATE TRIGGER 27 Syntax:
SHOW CREATE TRIGGER trigger_name

This sta...
http://dev.mysql.com/doc/refman/5.6/en/show-create-trigger.html
12 SHOW CREATE PROCEDURE 27 Syntax:
SHOW CREATE PROCEDURE proc_name

This stat...
mysql> SHOW CREATE PROCEDURE test.simpleproc\G
***...
http://dev.mysql.com/doc/refman/5.6/en/show-create-procedure.html
13 OPEN 24 Syntax:
OPEN cursor_name

This statement opens a p...
http://dev.mysql.com/doc/refman/5.6/en/open.html
14 ST_INTERSECTS 31 ST_Intersects(g1,g2)

Returns 1 or 0 to indicate w...
http://dev.mysql.com/doc/refman/5.6/en/functions-for-testing-spatial-relations-between-geometric-objects.html
15 LOWER 38 Syntax:
LOWER(str)

Returns the string str with al...
http://dev.mysql.com/doc/refman/5.6/en/string-functions.html
16 CREATE TRIGGER 40 Syntax:
CREATE
   [DEFINER = { user | CURRENT_USE...
http://dev.mysql.com/doc/refman/5.6/en/create-trigger.html
17 MONTH 32 Syntax:
MONTH(date)

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

http://dev.mysql.com/doc/refman/5.6/en/date-and-time-functions.html
18 SHOW TRIGGERS 27 Syntax:
SHOW TRIGGERS [{FROM | IN} db_name]
   [L...
http://dev.mysql.com/doc/refman/5.6/en/show-triggers.html
19 REGEXP 38 Syntax:
expr REGEXP pat, expr RLIKE pat

Performs ...
mysql> SELECT 'Monty!' REGEXP '.*';
        -> 1
m...
http://dev.mysql.com/doc/refman/5.6/en/regexp.html
20 IF STATEMENT 24 Syntax:
IF search_condition THEN statement_list
 ...
http://dev.mysql.com/doc/refman/5.6/en/if.html
21 VALIDATE_PASSWORD_STRENGTH 12 Syntax:
VALIDATE_PASSWORD_STRENGTH(str)

Given an ...
http://dev.mysql.com/doc/refman/5.6/en/encryption-functions.html
22 WITHIN 31 Within(g1,g2)

Returns 1 or 0 to indicate whether ...
http://dev.mysql.com/doc/refman/5.6/en/functions-for-testing-spatial-relations-between-geometric-objects.html
23 SHOW PLUGINS 27 Syntax:
SHOW PLUGINS

SHOW PLUGINS displays inform...
http://dev.mysql.com/doc/refman/5.6/en/show-plugins.html
24 PREPARE 8 Syntax:
PREPARE stmt_name FROM preparable_stmt

Th...
http://dev.mysql.com/doc/refman/5.6/en/prepare.html