PDF (US Ltr)
- 35.1Mb
PDF (A4)
- 35.2Mb
Man Pages (TGZ)
- 256.4Kb
Man Pages (Zip)
- 361.3Kb
Info (Gzip)
- 3.4Mb
Info (Zip)
- 3.4Mb
Search Results
https://dev.mysql.com/doc/refman/5.7/en/error-message-elements.html
This section discusses how error messages originate within MySQL and the elements they contain. Error Message Sources Error Message Elements Error Message Sources Error messages can originate on the server side or the client side: On the server ...
https://dev.mysql.com/doc/refman/5.7/en/events-metadata.html
If you select information from mysql.event, the times just mentioned are retrieved as UTC values. These times can also be obtained by selecting from the Information Schema EVENTS table or from SHOW EVENTS, but they are reported as ETZ values. To ...
https://dev.mysql.com/doc/refman/5.7/en/example-user-variables.html
You can employ MySQL user variables to remember results without having to store them in temporary variables in the client.
https://dev.mysql.com/doc/refman/5.7/en/examples.html
Here are examples of how to solve some common problems with MySQL. Some of the examples use the table shop to hold the price of each article (item number) for certain traders (dealers). Supposing that each trader has a single fixed price per ...
https://dev.mysql.com/doc/refman/5.7/en/expired-password-handling.html
mysql> SELECT 1; ERROR 1820 (HY000): You must reset your password using ALTER USER statement before executing this statement. MySQL provides password-expiration capability, which enables database administrators to require that users reset their ...
https://dev.mysql.com/doc/refman/5.7/en/features.html
Statements and Functions Full operator and function support in the SELECT list and WHERE clause of queries. For example: mysql> SELECT CONCAT(first_name, ' ', last_name) -> FROM citizen -> WHERE income/dependents > 10000 AND age > 30; Full support ... This section describes some of the important characteristics of the MySQL Database ...
https://dev.mysql.com/doc/refman/5.7/en/fulltext-query-expansion.html
The following example shows this difference: mysql> SELECT * FROM articles WHERE MATCH (title,body) AGAINST ('database' IN NATURAL LANGUAGE MODE); +----+-------------------+------------------------------------------+ | id | title | body | ...
https://dev.mysql.com/doc/refman/5.7/en/fulltext-stopwords.html
The stopword list is loaded and searched for full-text queries using the server character set and collation (the values of the character_set_server and collation_server system variables). False hits or misses might occur for stopword lookups if the ...
https://dev.mysql.com/doc/refman/5.7/en/gis-geometrycollection-property-functions.html
mysql> SET @gc = 'GeometryCollection(Point(1 1),LineString(2 2, 3 3))'; mysql> SELECT ST_AsText(ST_GeometryN(ST_GeomFromText(@gc),1)); +-------------------------------------------------+ | ST_AsText(ST_GeometryN(ST_GeomFromText(@gc),1)) | ...
https://dev.mysql.com/doc/refman/5.7/en/gis-point-property-functions.html
mysql> SELECT ST_X(Point(56.7, 53.34)); +--------------------------+ | ST_X(Point(56.7, 53.34)) | +--------------------------+ | 56.7 | +--------------------------+ ST_X() and X() are synonyms. mysql> SELECT ST_Y(Point(56.7, 53.34)); ... A Point ...