Search Results
https://dev.mysql.com/doc/refman/9.7/en/audit-log-reference.html
If instead you modify the contents of those tables directly using statements such as INSERT, UPDATE, and DELETE, the changes do not affect filtering immediately. Table 8.45 Write-Strategy Effect on the Direct Write Count Write Strategy Description ... Important The audit_log plugin is deprecated, and is being replaced by the audit_log ...
https://dev.mysql.com/doc/refman/9.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 ...
https://dev.mysql.com/doc/refman/9.7/en/calculating-days.html
CREATE TABLE t1 (year YEAR, month INT UNSIGNED, day INT UNSIGNED); INSERT INTO t1 VALUES(2000,1,1),(2000,1,20),(2000,1,30),(2000,2,2), (2000,2,23),(2000,2,23); The example table contains year-month-day values representing visits by users to the page. The following example shows how you can use the bit group functions to calculate the number of days per month a user has visited a Web ...
https://dev.mysql.com/doc/refman/9.7/en/charset-errors.html
This section describes how the MySQL server uses character sets for constructing error messages. For information about the language of error messages (rather than the character set), see Section 12.12, “Setting the Error Message Language”. For ...
https://dev.mysql.com/doc/refman/9.7/en/charset-metadata.html
INSERT INTO t1 (latin1_column) SELECT USER(); This works because the contents of USER() are automatically converted to latin1 before the assignment. Metadata is “the data about the data.” Anything that describes the database—as opposed to ...
https://dev.mysql.com/doc/refman/9.7/en/data-size.html
Indexes are good for retrieval, but slow down insert and update operations. Joins In some circumstances, it can be beneficial to split into two a table that is scanned very often. Design your tables to minimize their space on the disk. This can ...
https://dev.mysql.com/doc/refman/9.7/en/examples.html
Here are examples of how to solve some common problems with MySQL. Some of the examples use the table shop to hold the price of each article (item number) for certain traders (dealers). Supposing that each trader has a single fixed price per ...
https://dev.mysql.com/doc/refman/9.7/en/floating-point-types.html
MySQL performs rounding when storing values, so if you insert 999.00009 into a FLOAT(7,4) column, the approximate result is 999.0001. The FLOAT and DOUBLE types represent approximate numeric data values. MySQL uses four bytes for single-precision ...
https://dev.mysql.com/doc/refman/9.7/en/full-text-adding-collation.html
Warning User-defined collations are deprecated; you should expect support for them to be removed in a future version of MySQL. The server issues a warning for any use of COLLATE user_defined_collation in an SQL statement; a warning is also issued ...
https://dev.mysql.com/doc/refman/9.7/en/geometry-well-formedness-validity.html
Syntactic well-formedness is also checked for attempts to store geometries into tables. It is permitted to insert, select, and update geometrically invalid geometries, but they must be syntactically well-formed. For geometry values, MySQL ...