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/secure-client-programming.html
Handle External Data Properly Handle MySQL Error Messages Properly Handle External Data Properly Applications that access MySQL should not trust any data entered by users, who can try to trick your code by entering special or escaped character ...
https://dev.mysql.com/doc/refman/8.0/en/security-guidelines.html
Use the SHOW GRANTS statement to check which accounts have access to what. Also do not choose any password you have seen used as an example anywhere, or a variation on it, even if it was presented as an example of a strong password. That does not ...
https://dev.mysql.com/doc/refman/8.0/en/session-state-tracking.html
Uses for Session State Trackers Available Session State Trackers C API Session State Tracker Support Test Suite Session State Tracker Support Uses for Session State Trackers Session state trackers have uses such as these: To facilitate session ...A ...
https://dev.mysql.com/doc/refman/8.0/en/slow-query-log.html
mysqld writes a statement to the slow query log after it has been executed and after all locks have been released, so log order might differ from execution order. The query must have taken at least long_query_time seconds, or ... The slow query log ...
https://dev.mysql.com/doc/refman/8.0/en/spatial-index-optimization.html
That is, the column definition must include an explicit SRID attribute, and all column values must have the same SRID. The optimizer ignores SPATIAL indexes on columns that have no SRID attribute (and thus are not SRID-restricted). Because SPATIAL ... MySQL permits creation of SPATIAL indexes on NOT NULL geometry-valued columns (see Section 13.4.10, “Creating Spatial ...
https://dev.mysql.com/doc/refman/8.0/en/starting-server-troubleshooting.html
If you have problems starting the server, here are some things to try: Check the error log to see why the server does not start. If you are going to use storage engines that support transactional tables (InnoDB, NDB), be sure that you have them ...
https://dev.mysql.com/doc/refman/8.0/en/string-functions.html
To use this function, the file must be located on the server host, you must specify the full path name to the file, and you must have the FILE privilege. MAKE_SET(bits,str1,str2,...) Returns a set value (a string containing substrings separated by , ...For functions that operate on string positions, the first position is ...
https://dev.mysql.com/doc/refman/8.0/en/table-locking.html
You might have to create some summary tables to do this. If you have problems with mixed SELECT and DELETE statements, the LIMIT option to DELETE may help. In this case, write locks and read locks would have the same priority, which might help some ... InnoDB tables use row-level locking so that multiple sessions and applications can read from and write to the same table simultaneously, without making each other wait or producing inconsistent ...
https://dev.mysql.com/doc/refman/8.0/en/tracing-example.html
(Observe that it could have a match, were the operator a null-safe equals <=>). Now we can examine the trace, whose first column (QUERY), containing the original statement to be traced, is shown here: SELECT * FROM ...
https://dev.mysql.com/doc/refman/8.0/en/upgrade-prerequisites.html
Triggers must not have a missing or empty definer or an invalid creation context (indicated by the character_set_client, collation_connection, Database Collation attributes displayed by SHOW TRIGGERS or the INFORMATION_SCHEMA TRIGGERS table). There ... Before upgrading to the latest MySQL 8.0 release, ensure the upgrade readiness of your current MySQL 5.7 or MySQL 8.0 server instance by performing the preliminary checks described ...