PDF (US Ltr)
- 41.8Mb
PDF (A4)
- 41.9Mb
Man Pages (TGZ)
- 272.4Kb
Man Pages (Zip)
- 378.4Kb
Info (Gzip)
- 4.2Mb
Info (Zip)
- 4.2Mb
Search Results
https://dev.mysql.com/doc/refman/9.7/en/performance-schema-thread-filtering.html
The threads table contains a row for each server thread. Each row contains information about a thread and indicates whether monitoring is enabled for it. For the Performance Schema to monitor a thread, these things must be true: The ...
https://dev.mysql.com/doc/refman/9.7/en/problems-with-null.html
The concept of the NULL value is a common source of confusion for newcomers to SQL, who often think that NULL is the same thing as an empty string ''. For example, the following statements are completely different: mysql> INSERT INTO my_table ...
https://dev.mysql.com/doc/refman/9.7/en/replication-options.html
The following sections contain information about mysqld options and server variables that are used in replication and for controlling the binary log. Options and variables for use on sources and replicas are covered separately, as are options and ...
https://dev.mysql.com/doc/refman/9.7/en/replication-sbr-rbr.html
For most users, the mixed replication format should provide the best combination of data integrity and performance. If, however, you want to take advantage of the features specific to the statement-based or row-based replication format when ...
https://dev.mysql.com/doc/refman/9.7/en/replication-solutions-backups-read-only.html
Note The instructions in this section place the server to be backed up in a state that is safe for backup methods that get the data from the server, such as mysqldump (see Section 6.5.4, “mysqldump — A Database Backup Program”). You should not ...
https://dev.mysql.com/doc/refman/9.7/en/spatial-relation-functions-object-shapes.html
The OpenGIS specification defines the following functions to test the relationship between two geometry values g1 and g2, using precise object shapes. The return values 1 and 0 indicate true and false, respectively, except that distance functions ...
https://dev.mysql.com/doc/refman/9.7/en/srjs-data-arguments.html
Most MySQL data types are supported for MLE stored program input and output arguments, as well as for return data types. The data types are listed here: Integer: All variants and aliases of MySQL integer data types are supported, including TINYINT, ...
https://dev.mysql.com/doc/refman/9.7/en/srjsapi-column.html
The Column object represents the column metadata in a result set. Column has the methods listed here: getFractionalDigits(): Gets the fractional digits of the column value, if applicable. getCharacterSetName(): Retrieves the name of the character ...
https://dev.mysql.com/doc/refman/9.7/en/srjsapi-sqlresult.html
An SqlResult is produced whenever a query is executed using sqlExecute.execute(), PreparedStatement.execute(), or Session.runSql(). Methods supported by SqlResult are listed here: close(): Closes the result set. fetchAll(): Retrieves a list of all ...
https://dev.mysql.com/doc/refman/9.7/en/srjsapi-table.html
The Table object represents a database table existsInDatabase(): Returns true if the table exists in the current database, otherwise false. count(): Returns the number of rows in this table if it exists in the current database, otherwise throws an ...