Server: mysql wampserver »Database: mysql »Table: help_topic"help topics"
Showing rows 0 - 24 (535 total, Query took 0.0007 sec)
SELECT * FROM `help_topic`
[ Inline ] [ Edit ] [ Explain SQL ] [ Create PHP Code ] [ Refresh ]

Sort by key:

Full texts help_topic_id name help_category_id description example url
Edit Edit Copy Copy Delete 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 Edit Copy Copy Delete 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 Edit Copy Copy Delete 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 Edit Copy Copy Delete 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 Edit Copy Copy Delete 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 Edit Copy Copy Delete 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 Edit Copy Copy Delete 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 Edit Copy Copy Delete 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 Edit Copy Copy Delete 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 Edit Copy Copy Delete 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 Edit Copy Copy Delete 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 Edit Copy Copy Delete 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 Edit Copy Copy Delete 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 Edit Copy Copy Delete 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 Edit Copy Copy Delete 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 Edit Copy Copy Delete 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 Edit Copy Copy Delete 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 Edit Copy Copy Delete 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 Edit Copy Copy Delete 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 Edit Copy Copy Delete 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 Edit Copy Copy Delete 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 Edit Copy Copy Delete 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 Edit Copy Copy Delete 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 Edit Copy Copy Delete 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 Edit Copy Copy Delete 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...
With selected: With selected:

Query results operations Print view Print view Print view (with full texts) Print view (with full texts) Export Export Display chart Display chart Create view Create view