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/mysqldump.html
--default-auth=plugin Command-Line Format --default-auth=plugin Type String A hint about which client-side authentication plugin to use. --login-path=name Command-Line Format --login-path=name Type String Read options from the named login path in ...
https://dev.mysql.com/doc/refman/5.7/en/system-schema.html
Object Information System Tables These system tables contain information about stored programs, loadable functions, and server-side plugins: event: The registry for Event Scheduler events installed using CREATE EVENT. During the normal startup ...It ...
https://dev.mysql.com/doc/refman/5.7/en/macos-installation-launchd.html
macOS uses launch daemons to automatically start, stop, and manage processes and applications such as MySQL. The md5 checksum of a file containing the above snippet is 24710a27dc7a28fb7ee6d825129cd3cf. To enable the launchd service, you can either: ...
https://dev.mysql.com/doc/refman/5.7/en/create-event.html
CREATE [DEFINER = user] EVENT [IF NOT EXISTS] event_name ON SCHEDULE schedule [ON COMPLETION [NOT] PRESERVE] [ENABLE | DISABLE | DISABLE ON SLAVE] [COMMENT 'string'] DO event_body; schedule: { AT timestamp [+ INTERVAL interval] ... Within an event ...The event does not run unless the Event Scheduler is ...
https://dev.mysql.com/doc/refman/5.7/en/type-conversion.html
mysql> SELECT 1+'1'; -> 2 mysql> SELECT CONCAT(2,' test'); -> '2 test' It is also possible to convert a number to a string explicitly using the CAST() function. Conversion occurs implicitly with the CONCAT() function because it expects string ...For ... When an operator is used with operands of different types, type conversion occurs to make the operands ...
https://dev.mysql.com/doc/refman/5.7/en/mysql-cluster-programs-ndb-config.html
--connect-string Command-Line Format --connect-string=connection_string Type String Default Value [none] Same as --ndb-connectstring. --defaults-extra-file Command-Line Format --defaults-extra-file=path Type String Default Value [none] Read given ...
https://dev.mysql.com/doc/refman/5.7/en/mysql-commands.html
If you provide an argument to the help command, mysql uses it as a search string to access server-side help from the contents of the MySQL Reference Manual. delimiter str, \d str Change the string that mysql interprets as the separator between SQL ... mysql sends each SQL statement that you issue to the server to be ...
https://dev.mysql.com/doc/refman/5.7/en/bnl-bka-optimization.html
After submission of the keys, the MRR engine functions perform lookups in the index in an optimal way, fetching the rows of the joined table found by these keys, and starts feeding the BKA join algorithm with matching rows. The following setting ...
https://dev.mysql.com/doc/refman/5.7/en/gis-data-formats.html
(Internal format is like WKB but with an initial 4 bytes to indicate the SRID.) There are functions available to convert between different data formats; see Section 12.16.6, “Geometry Format Conversion Functions”. This differs from the syntax ...
https://dev.mysql.com/doc/refman/5.7/en/implicit-commit.html
ALTER FUNCTION, CREATE FUNCTION and DROP FUNCTION also cause an implicit commit when used with stored functions, but not with loadable functions. (ALTER FUNCTION can only be used with stored functions.) CREATE TABLE and DROP TABLE statements do not ... The statements listed in this section (and any synonyms for them) implicitly end any transaction active in the current session, as if you had done a COMMIT before executing the ...