PDF (US Ltr)
- 43.3Mb
PDF (A4)
- 43.4Mb
Man Pages (TGZ)
- 297.2Kb
Man Pages (Zip)
- 402.4Kb
Info (Gzip)
- 4.3Mb
Info (Zip)
- 4.3Mb
Search Results
https://dev.mysql.com/doc/refman/8.0/en/cast-functions.html
If the spatial type combination is permitted but the expression to cast is not a syntactically well-formed geometry, an ER_GIS_INVALID_DATA error occurs. If the ring is not in the correct order (the exterior ring must be counter-clockwise), an ...A ...This operation may also be expressed as CONVERT(expr, type), which is ...
https://dev.mysql.com/doc/refman/8.0/en/alter-logfile-group.html
For example, you cannot have a tablespace and an undo log file with the same name, or an undo log file and a data file with the same name. This includes any default value implied for this option by the setting of the InitialLogFileGroup data node ...
https://dev.mysql.com/doc/refman/8.0/en/using-date.html
You should use this format in UPDATE expressions and in the WHERE clause of SELECT statements. For example: SELECT * FROM t1 WHERE date >= '2003-05-05'; As a convenience, MySQL automatically converts a date to a number if the date is used in numeric ...MySQL also permits a “relaxed” string format when updating and in a WHERE clause that compares a date to a DATE, DATETIME, or TIMESTAMP ...
https://dev.mysql.com/doc/refman/8.0/en/mysql-cluster-programs-ndb-select-all.html
Usage ndb_select_all -c connection_string tbl_name -d db_name [> file_name] Options that can be used with ndb_select_all are shown in the following table. --core-file Command-Line Format --core-file Removed 8.0.31 Write core file on error; used in ...This option can be used only in conjunction with the -o (--order) ...
https://dev.mysql.com/doc/refman/8.0/en/resetting-permissions.html
For example: C:\> mysqld --defaults-file="C:\\ProgramData\\MySQL\\MySQL Server 8.0\\my.ini" --init-file=C:\\mysql-init.txt The appropriate --defaults-file setting can be found using the Services Manager: From the Start menu, select Control Panel, ...
https://dev.mysql.com/doc/refman/8.0/en/create-table-foreign-keys.html
The CONSTRAINT symbol value, if defined, must be unique in the database. Corresponding columns in the foreign key and the referenced key must have similar data types. row *************************** ID: test/child_ibfk_1 FOR_COL_NAME: parent_id ...A ...(Bug #30512043) Table and column identifiers in a FOREIGN KEY ...
https://dev.mysql.com/doc/refman/8.0/en/macos-installation-launchd.html
The md5 checksum of a file containing the above snippet is d925f05f6d1b6ee5ce5451b596d6baed. Figure 2.18 MySQL Preference Pane: Location The Instances page includes an option to start or stop MySQL, and Initialize Database recreates the data/ ...To ... macOS uses launch daemons to automatically start, stop, and manage processes and applications such as ...
https://dev.mysql.com/doc/refman/8.0/en/myisamchk-repair-options.html
--data-file-length=len, -D len Command-Line Format --data-file-length=len Type Numeric The maximum length of the data file (when re-creating data file when it is “full”). --extend-check, -e Command-Line Format --extend-check Do a repair that ...
https://dev.mysql.com/doc/refman/8.0/en/mysql-cluster-replication-issues.html
Examples of incidents are server failures, database resynchronization, some software updates, and some hardware changes.) When the replica encounters a gap in the replication log, it stops with an error message. For replication from NDB to a ...A ...
https://dev.mysql.com/doc/refman/8.0/en/replication-sbr-rbr.html
Log files contain all statements that made any changes, so they can be used to audit the database. For most users, the mixed replication format should provide the best combination of data integrity and performance. Examples of such Data Modification ...If, however, you want to take advantage of the features specific to the statement-based or row-based replication format when performing certain tasks, you can use the information in this section, which provides a summary of their relative advantages and disadvantages, to determine which is best for your ...