PDF (US Ltr)
- 35.1Mb
PDF (A4)
- 35.2Mb
Man Pages (TGZ)
- 256.4Kb
Man Pages (Zip)
- 361.2Kb
Info (Gzip)
- 3.4Mb
Info (Zip)
- 3.4Mb
Search Results
https://dev.mysql.com/doc/refman/5.7/en/gis-linestring-property-functions.html
mysql> SET @ls = 'LineString(1 1,2 2,3 3)'; mysql> SELECT ST_AsText(ST_EndPoint(ST_GeomFromText(@ls))); +----------------------------------------------+ | ST_AsText(ST_EndPoint(ST_GeomFromText(@ls))) | ...You can extract particular points of a ...
https://dev.mysql.com/doc/refman/5.7/en/insert-on-duplicate.html
If column b is also unique, the INSERT is equivalent to this UPDATE statement instead: UPDATE t1 SET c=c+1 WHERE a=1 OR b=2 LIMIT 1; If a=1 OR b=2 matches several rows, only one row is updated. With ON DUPLICATE KEY UPDATE, the affected-rows value ... If you specify an ON DUPLICATE KEY UPDATE clause and a row to be inserted would cause a duplicate value in a UNIQUE index or PRIMARY KEY, an UPDATE of the old row ...
https://dev.mysql.com/doc/refman/5.7/en/myisamchk-repair-options.html
--set-collation=name Command-Line Format --set-collation=name Type String Specify the collation to use for sorting table indexes. --tmpdir can be set to a list of directory paths that are used successively in round-robin fashion for creating ...See ...
https://dev.mysql.com/doc/refman/5.7/en/spatial-convenience-functions.html
If any geometry argument is not a syntactically well-formed geometry byte string, an ER_GIS_INVALID_DATA error occurs. The only valid empty geometry is represented in the form of an empty geometry collection value. ST_IsValid() works only for the ...
https://dev.mysql.com/doc/refman/5.7/en/windows-upgrading.html
For example, before upgrading from MySQL 5.6 to 5.7, use mysqladmin from MySQL 5.6 as follows: C:\> "C:\Program Files\MySQL\MySQL Server 5.6\bin\mysqladmin" -u root shutdown Note If the MySQL root user account has a password, invoke mysqladmin with ... There are two approaches for upgrading MySQL on Windows: Using MySQL Installer Using the Windows ZIP archive distribution The approach you select depends on how the existing installation was ...
https://dev.mysql.com/doc/refman/5.7/en/creating-tables.html
Storing birth date rather than age has other advantages, too: You can use the database for tasks such as generating reminders for upcoming pet birthdays. For example, if you store death date in the database, you can easily calculate how old a pet ...
https://dev.mysql.com/doc/refman/5.7/en/charset-collation-information-schema.html
However, for values that correspond to objects that are represented in the file system, such as databases and tables, searches in INFORMATION_SCHEMA string columns can be case-sensitive or case-insensitive, depending on the characteristics of the ...
https://dev.mysql.com/doc/refman/5.7/en/mysql-cluster-importing-data.html
Within a mysql client session, you can perform the import using the following SQL statements: SET ndb_use_transactions=0; SET foreign_key_checks=0; source path/to/dumpfile; SET ndb_use_transactions=1; SET foreign_key_checks=1; When performing the ...
https://dev.mysql.com/doc/refman/5.7/en/performance-schema-events-stages-current-table.html
The table stores one row per thread showing the current status of the thread's most recent monitored stage event, so there is no system variable for configuring the table size. For example, the events_stages_history and events_stages_history_long ...
https://dev.mysql.com/doc/refman/5.7/en/replication-features-triggers.html
For each table that has multiple triggers per combination of trigger event and action time, convert each such set of triggers to a single trigger as follows: For each trigger, create a stored routine that contains all the code in the trigger. It is ... With statement-based replication, triggers executed on the source also execute on the ...