PDF (US Ltr)
- 43.2Mb
PDF (A4)
- 43.3Mb
Man Pages (TGZ)
- 295.3Kb
Man Pages (Zip)
- 400.4Kb
Info (Gzip)
- 4.3Mb
Info (Zip)
- 4.3Mb
Search Results
https://dev.mysql.com/doc/refman/8.0/en/show-create-table.html
row *************************** Table: t Create Table: CREATE TABLE `t` ( `id` int NOT NULL AUTO_INCREMENT, `s` char(60) DEFAULT NULL, PRIMARY KEY (`id`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci As of MySQL 8.0.16, MySQL ...
https://dev.mysql.com/doc/refman/8.0/en/spatial-relation-functions-object-shapes.html
mysql> SET @g1 = ST_GeomFromText('Polygon((0 0,0 3,3 3,3 0,0 0))'), -> @p1 = ST_GeomFromText('Point(1 1)'), -> @p2 = ST_GeomFromText('Point(3 3)'), -> @p3 = ST_GeomFromText('Point(5 5)'); Query OK, 0 rows affected (0.00 sec) mysql> SELECT -> ... The ...
https://dev.mysql.com/doc/refman/8.0/en/myisam-maintenance-schedule.html
If you are performing many updates to MyISAM tables with dynamic-sized rows (tables with VARCHAR, BLOB, or TEXT columns) or have tables with many deleted rows you may want to defragment/reclaim space from the tables from time to time. Alternatively, ... It is a good idea to perform table checks on a regular basis rather than waiting for problems to ...
https://dev.mysql.com/doc/refman/8.0/en/select-optimization.html
Depending on how the query is structured, a function could be called once for every row in the result set, or even once for every row in the table, greatly magnifying any inefficiency. (When you reach a certain level of expertise, reading the ...
https://dev.mysql.com/doc/refman/8.0/en/sys-innodb-buffer-stats-by-schema.html
These views summarize the information in the INFORMATION_SCHEMA INNODB_BUFFER_PAGE table, grouped by schema. Warning Querying views that access the INNODB_BUFFER_PAGE table can affect performance. Do not query these views on a production system ...
https://dev.mysql.com/doc/refman/8.0/en/sys-innodb-buffer-stats-by-table.html
These views summarize the information in the INFORMATION_SCHEMA INNODB_BUFFER_PAGE table, grouped by schema and table. Warning Querying views that access the INNODB_BUFFER_PAGE table can affect performance. Do not query these views on a production ...
https://dev.mysql.com/doc/refman/8.0/en/binary-log-formats.html
In row-based logging (the default), the source writes events to the binary log that indicate how individual table rows are affected. You can cause the server to use row-based logging by starting it with --binlog-format=ROW. With mixed logging, ...
https://dev.mysql.com/doc/refman/8.0/en/data-type-defaults.html
When binlog_format is set to MIXED or ROW, the statement is executed as normal. For nontransactional tables, an error occurs, but if this happens for the second or subsequent row of a multiple-row statement, the preceding rows are inserted. Suppose ... Data type specifications can have explicit or implicit default ...
https://dev.mysql.com/doc/refman/8.0/en/declare-handler.html
If no more rows are available, a No Data condition occurs with SQLSTATE value '02000'. statement handler_action: { CONTINUE | EXIT | UNDO } condition_value: { mysql_error_code | SQLSTATE [VALUE] sqlstate_value | condition_name | SQLWARNING | NOT ...
https://dev.mysql.com/doc/refman/8.0/en/events-privileges.html
However, e_insert continues to execute, inserting a new row into mytable each seven seconds. For a schema-level EVENT privilege, GRANT creates a row in mysql.db and sets that row's Db column to the name of the schema, the User column to the name of ... To enable or disable the execution of scheduled events, it is necessary to set the value of the global event_scheduler system ...