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/xml-functions.html
code injection occurs when malicious code is introduced into the system to gain unauthorized access to privileges and data. Table 12.16 XML Functions Name Description ExtractValue() Extract a value from an XML string using XPath notation ...
https://dev.mysql.com/doc/refman/5.7/en/access-control.html
The MySQL server reads the contents of these tables into memory when it starts and bases access-control decisions on the in-memory copies of the grant tables. MySQL enables the creation of accounts that permit client users to connect to the server ...
https://dev.mysql.com/doc/refman/5.7/en/aggregate-functions-and-modifiers.html
They are often used with a GROUP BY clause to group values into subsets.
https://dev.mysql.com/doc/refman/5.7/en/all-subqueries.html
The expression is TRUE if table t2 contains (-5,0,+5) because 10 is greater than all three values in t2. The expression is FALSE if table t2 contains (12,6,NULL,-100) because there is a single value 12 in table t2 that is greater than 10. The ...
https://dev.mysql.com/doc/refman/5.7/en/alter-table.html
ALTER TABLE tbl_name [alter_option [, alter_option] ...] [partition_options] alter_option: { table_options | ADD [COLUMN] col_name column_definition [FIRST | AFTER col_name] | ADD [COLUMN] (col_name column_definition,...) | ADD {INDEX | KEY} ...
https://dev.mysql.com/doc/refman/5.7/en/analyze-table.html
This makes ANALYZE TABLE fast on InnoDB tables but not 100% accurate because it does not take all rows into account. ANALYZE TABLE performs a key distribution analysis and stores the distribution for the named table or tables. For MyISAM tables, ...
https://dev.mysql.com/doc/refman/5.7/en/apis-perl.html
The Perl DBI module provides a generic interface for database access. You can write a DBI script that works with many different database engines without change. To use DBI with MySQL, install the following: The DBI module. Optionally, the DBD ...
https://dev.mysql.com/doc/refman/5.7/en/apis-python.html
The new MySQL Connector/Python component provides an interface to the same Python API, and is built into the MySQL Server and supported by Oracle. MySQLdb is a third-party driver that provides MySQL support for Python, compliant with the Python DB ...
https://dev.mysql.com/doc/refman/5.7/en/backup-methods.html
Also, even if the server is not actively updating data, InnoDB may still have modified data cached in memory and not flushed to disk.) Making Delimited-Text File Backups To create a text file containing a table's data, you can use SELECT * INTO ...
https://dev.mysql.com/doc/refman/5.7/en/backup-policy.html
With binary logging enabled, the server writes each data change into a file while it updates data. A full backup (a snapshot of the data at a point in time) can be done in MySQL with several tools. For example, MySQL Enterprise Backup can perform a ...