|
Edit
|
Copy
|
Delete
DELETE FROM `mysql`.`help_topic` WHERE `help_topic`.`help_topic_id` = 0 | 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 |
|
Edit
|
Copy
|
Delete
DELETE FROM `mysql`.`help_topic` WHERE `help_topic`.`help_topic_id` = 1 | 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-func... |
|
Edit
|
Copy
|
Delete
DELETE FROM `mysql`.`help_topic` WHERE `help_topic`.`help_topic_id` = 2 | 2 |
CONTAINS |
31 |
Contains(g1,g2)
Returns 1 or 0 to indicate whethe... | | http://dev.mysql.com/doc/refman/5.6/en/functions-f... |
|
Edit
|
Copy
|
Delete
DELETE FROM `mysql`.`help_topic` WHERE `help_topic`.`help_topic_id` = 3 | 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-pr... |
|
Edit
|
Copy
|
Delete
DELETE FROM `mysql`.`help_topic` WHERE `help_topic`.`help_topic_id` = 4 | 4 |
SHOW CONTRIBUTORS |
27 |
Syntax: SHOW CONTRIBUTORS
The SHOW CONTRIBUTORS s... | | http://dev.mysql.com/doc/refman/5.6/en/show-contri... |
|
Edit
|
Copy
|
Delete
DELETE FROM `mysql`.`help_topic` WHERE `help_topic`.`help_topic_id` = 5 | 5 |
VARIANCE |
16 |
Syntax: VARIANCE(expr)
Returns the population sta... | | http://dev.mysql.com/doc/refman/5.6/en/group-by-fu... |
|
Edit
|
Copy
|
Delete
DELETE FROM `mysql`.`help_topic` WHERE `help_topic`.`help_topic_id` = 6 | 6 |
DROP SERVER |
40 |
Syntax: DROP SERVER [ IF EXISTS ] server_name
Dro... | | http://dev.mysql.com/doc/refman/5.6/en/drop-server... |
|
Edit
|
Copy
|
Delete
DELETE FROM `mysql`.`help_topic` WHERE `help_topic`.`help_topic_id` = 7 | 7 |
SHOW AUTHORS |
27 |
Syntax: SHOW AUTHORS
The SHOW AUTHORS statement d... | | http://dev.mysql.com/doc/refman/5.6/en/show-author... |
|
Edit
|
Copy
|
Delete
DELETE FROM `mysql`.`help_topic` WHERE `help_topic`.`help_topic_id` = 8 | 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-func... |
|
Edit
|
Copy
|
Delete
DELETE FROM `mysql`.`help_topic` WHERE `help_topic`.`help_topic_id` = 9 | 9 |
GEOMETRY HIERARCHY |
35 |
Geometry is the base class. It is an abstract clas... | | http://dev.mysql.com/doc/refman/5.6/en/gis-geometr... |
|
Edit
|
Copy
|
Delete
DELETE FROM `mysql`.`help_topic` WHERE `help_topic`.`help_topic_id` = 10 | 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-func... |
|
Edit
|
Copy
|
Delete
DELETE FROM `mysql`.`help_topic` WHERE `help_topic`.`help_topic_id` = 11 | 11 |
SHOW CREATE TRIGGER |
27 |
Syntax: SHOW CREATE TRIGGER trigger_name
This sta... | | http://dev.mysql.com/doc/refman/5.6/en/show-create... |
|
Edit
|
Copy
|
Delete
DELETE FROM `mysql`.`help_topic` WHERE `help_topic`.`help_topic_id` = 12 | 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... |
|
Edit
|
Copy
|
Delete
DELETE FROM `mysql`.`help_topic` WHERE `help_topic`.`help_topic_id` = 13 | 13 |
OPEN |
24 |
Syntax: OPEN cursor_name
This statement opens a p... | | http://dev.mysql.com/doc/refman/5.6/en/open.html |
|
Edit
|
Copy
|
Delete
DELETE FROM `mysql`.`help_topic` WHERE `help_topic`.`help_topic_id` = 14 | 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-f... |
|
Edit
|
Copy
|
Delete
DELETE FROM `mysql`.`help_topic` WHERE `help_topic`.`help_topic_id` = 15 | 15 |
LOWER |
38 |
Syntax: LOWER(str)
Returns the string str with al... | | http://dev.mysql.com/doc/refman/5.6/en/string-func... |
|
Edit
|
Copy
|
Delete
DELETE FROM `mysql`.`help_topic` WHERE `help_topic`.`help_topic_id` = 16 | 16 |
CREATE TRIGGER |
40 |
Syntax: CREATE [DEFINER = { user | CURRENT_USE... | | http://dev.mysql.com/doc/refman/5.6/en/create-trig... |
|
Edit
|
Copy
|
Delete
DELETE FROM `mysql`.`help_topic` WHERE `help_topic`.`help_topic_id` = 17 | 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-ti... |
|
Edit
|
Copy
|
Delete
DELETE FROM `mysql`.`help_topic` WHERE `help_topic`.`help_topic_id` = 18 | 18 |
SHOW TRIGGERS |
27 |
Syntax: SHOW TRIGGERS [{FROM | IN} db_name] [L... | | http://dev.mysql.com/doc/refman/5.6/en/show-trigge... |
|
Edit
|
Copy
|
Delete
DELETE FROM `mysql`.`help_topic` WHERE `help_topic`.`help_topic_id` = 19 | 19 |
ISCLOSED |
13 |
IsClosed(ls)
Returns 1 if the LineString value ls... | mysql> SET @ls1 = 'LineString(1 1,2 2,3 3,2 2)'; Q... | http://dev.mysql.com/doc/refman/5.6/en/geometry-pr... |
|
Edit
|
Copy
|
Delete
DELETE FROM `mysql`.`help_topic` WHERE `help_topic`.`help_topic_id` = 20 | 20 |
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 |
|
Edit
|
Copy
|
Delete
DELETE FROM `mysql`.`help_topic` WHERE `help_topic`.`help_topic_id` = 21 | 21 |
IF STATEMENT |
24 |
Syntax: IF search_condition THEN statement_list ... | | http://dev.mysql.com/doc/refman/5.6/en/if.html |
|
Edit
|
Copy
|
Delete
DELETE FROM `mysql`.`help_topic` WHERE `help_topic`.`help_topic_id` = 22 | 22 |
VALIDATE_PASSWORD_STRENGTH |
12 |
Syntax: VALIDATE_PASSWORD_STRENGTH(str)
Given an ... | | http://dev.mysql.com/doc/refman/5.6/en/encryption-... |
|
Edit
|
Copy
|
Delete
DELETE FROM `mysql`.`help_topic` WHERE `help_topic`.`help_topic_id` = 23 | 23 |
WITHIN |
31 |
Within(g1,g2)
Returns 1 or 0 to indicate whether ... | | http://dev.mysql.com/doc/refman/5.6/en/functions-f... |
|
Edit
|
Copy
|
Delete
DELETE FROM `mysql`.`help_topic` WHERE `help_topic`.`help_topic_id` = 24 | 24 |
SHOW PLUGINS |
27 |
Syntax: SHOW PLUGINS
SHOW PLUGINS displays inform... | | http://dev.mysql.com/doc/refman/5.6/en/show-plugin... |