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/problems-connecting.html
If you change the grant tables directly (for example, by using INSERT, UPDATE, or DELETE statements) and your changes seem to be ignored, remember that you must execute a FLUSH PRIVILEGES statement or a mysqladmin flush-privileges command to cause ...If the server was started with the bind_address system variable set to 127.0.0.1, it listens for TCP/IP connections only locally on the loopback interface and does not accept remote ...
https://dev.mysql.com/doc/refman/8.0/en/where-optimization.html
The examples use SELECT statements, but the same optimizations apply for WHERE clauses in DELETE and UPDATE statements. Because MySQL does similar optimizations automatically, you can often avoid this work, and leave the query in a more ... This ...
https://dev.mysql.com/doc/refman/8.0/en/innodb-locking.html
For example, SELECT c1 FROM t WHERE c1 BETWEEN 10 and 20 FOR UPDATE; prevents other transactions from inserting a value of 15 into column t.c1, whether or not there was already any such value in the column, because the gaps between all existing ...A ...
https://dev.mysql.com/doc/refman/8.0/en/join.html
MySQL supports the following JOIN syntax for the table_references part of SELECT statements and multiple-table DELETE and UPDATE statements: table_references: escaped_table_reference [, escaped_table_reference] ... This option follows the name of ...index_hint: { USE {INDEX|KEY} [FOR {JOIN|ORDER BY|GROUP BY}] ([index_list]) | {IGNORE|FORCE} {INDEX|KEY} [FOR {JOIN|ORDER BY|GROUP BY}] (index_list) } index_list: index_name [, index_name] ...
https://dev.mysql.com/doc/refman/8.0/en/spatial-operator-functions.html
See that section for descriptions of these functions: ST_Envelope(g) ST_StartPoint(ls) ST_EndPoint(ls) ST_PointN(ls, N) ST_ExteriorRing(poly) ST_InteriorRingN(poly, N) ST_GeometryN(gc, N) Unless otherwise specified, functions in this section handle ... OpenGIS proposes a number of functions that can produce ...
https://dev.mysql.com/doc/refman/8.0/en/switchable-optimizations.html
This variable has global and session values and can be changed at runtime. (Depending on the nullability of the derived table, this can sometimes be simplified further to an inner join.) This can be done for a subquery which meets the following ...
https://dev.mysql.com/doc/refman/8.0/en/creating-ssl-rsa-files-using-mysql.html
They can be enabled at startup and inspected but not set at runtime. MySQL provides these ways to create the SSL certificate and key files and RSA key-pair files required to support encrypted connections using SSL and secure password exchange using ...Users can invoke the mysql_ssl_rsa_setup utility manually (deprecated as of MySQL ...
https://dev.mysql.com/doc/refman/8.0/en/faqs-stored-procs.html
What limitations exist for replicating stored procedure and function actions? Nondeterministic (random) or time-based actions embedded in stored procedures may not replicate properly. A workaround is for a function's DML actions to be carried out ...
https://dev.mysql.com/doc/refman/8.0/en/data-masking-component-functions.html
mask_canada_sin(str [, mask_char]) Masks a Canada Social Insurance Number (SIN) and returns the number with all meaningful digits replaced by 'X' characters. mask_iban(str [, mask_char]) Masks an International Bank Account Number (IBAN) and returns ...Nine digits grouped in pattern: xxx-xxx-xxx ('-' is any separator ...
https://dev.mysql.com/doc/refman/8.0/en/mysql-cluster-ndbinfo-memory-per-fragment.html
Each variable-sized page is reorganized as needed to fit the changing size of variable-sized row parts as they are inserted, updated, and deleted; if a given row part grows too large for the page it is in, it can be moved to a different page. This ... memory_per_fragment Table: Notes memory_per_fragment Table: Examples The memory_per_fragment table provides information about the usage of memory by individual ...