Search Results
https://dev.mysql.com/doc/refman/8.4/en/replication-gtids-lifecycle.html
Whenever the binary log is rotated or the server is shut down, the server writes GTIDs for all transactions that were written into the previous binary log file into the mysql.gtid_executed table. With binary logging enabled (as required for the ...
https://dev.mysql.com/doc/refman/8.4/en/starting-server.html
Start the MySQL server like this if your installation includes mysqld_safe: $> bin/mysqld_safe --user=mysql & Note For Linux systems on which MySQL is installed using RPM packages, server startup and shutdown is managed using systemd rather than ...
https://dev.mysql.com/doc/refman/8.4/en/string-literals.html
(For more information, see Section 12.8.5, “The binary Collation Compared to _bin Collations”.) Note Within the mysql client, binary strings display using hexadecimal notation, depending on the value of the --binary-as-hex. For more information ... A string is a sequence of bytes or characters, enclosed within either single quote (') or double quote (") ...
https://dev.mysql.com/doc/refman/8.4/en/tutorial.html
This chapter provides a tutorial introduction to MySQL by showing how to use the mysql client program to create and use a simple database. mysql (sometimes referred to as the “terminal monitor” or just “monitor”) is an interactive program ...If you are interested only in accessing an existing database, you may want to skip the sections that describe how to create the database and the tables it ...
https://dev.mysql.com/doc/refman/8.4/en/x-plugin-connection-compression.html
Note Different MySQL clients implement support for connection compression differently; consult your client documentation for details. For example, for classic MySQL protocol connections, see Section 6.2.8, “Connection Compression Control”. X ...
https://dev.mysql.com/doc/mysql-errors/8.4/en/client-error-reference.html
Client error messages originate from within the MySQL client library. Here is an example client error message, as displayed by the mysql client: $> mysql -h no-such-host ERROR 2005 (HY000): Unknown MySQL server host 'no-such-host' (0) Each client ...For client errors, the SQLSTATE value is always 'HY000' (general error), so it is not meaningful for distinguishing one client error from ...
https://dev.mysql.com/doc/c-api/8.4/en/c-api-threaded-clients.html
This section provides guidance for writing client programs that use the thread-related functions in the MySQL C API. For examples of source code that uses them, look in the client directory of a MySQL source distribution: The source for mysqlimport ...For further information about these functions, see Section 8.2, “C API Threaded Function ...
https://dev.mysql.com/doc/mysql-ai/9.5/en/mys-ai-aml-data-drift-detection.html
MySQL AI includes data drift detection for classification and regression models. mysql> CALL sys.ML_TRAIN('table_name', 'target_column_name', JSON_OBJECT('task', 'task_name'), @variable); Replace table_name, target_column_name, task_name, and ...
https://dev.mysql.com/doc/workbench/en/wb-design-modeling-interface.html
MySQL Workbench represents each active data model as an icon in the models view of the home screen tab. Both models derive from MySQL database samples (see https://dev.mysql.com/doc/index-other.html), which you can download and use to explore the ...Figure 9.1 Data Models on the Home Screen The sakila database sample includes a model file (sakila.mwb) in the product ...
https://dev.mysql.com/doc/workbench/en/wb-migration-database-mssql-typemapping.html
The following table shows the mapping between Microsoft SQL Server (source) data types and MySQL data types. Table 10.2 Type mapping Source Type MySQL Type Comment INT INT TINYINT TINYINT UNSIGNED flag set in MySQL. MySQL Server 5.6 and higher can ...SMALLINT SMALLINT BIGINT BIGINT BIT TINYINT(1) FLOAT FLOAT Precision value is used for storage size in ...