Search Results
https://dev.mysql.com/doc/refman/8.4/en/get-diagnostics.html
For example: mysql> GET DIAGNOSTICS CONDITION 1 @p5 = SCHEMA_NAME, @p6 = TABLE_NAME; mysql> SELECT @p5, @p6; +------+------+ | @p5 | @p6 | +------+------+ | | | +------+------+ In standard SQL, if there are multiple conditions, the first condition ... GET [CURRENT | STACKED] DIAGNOSTICS { statement_information_item [, statement_information_item] ...
https://dev.mysql.com/doc/refman/8.4/en/optimizing-innodb-diskio.html
For more information, refer to the following sections: Section 17.8.1, “InnoDB Startup Configuration” Section 17.6.1.2, “Creating Tables Externally” Creating a General Tablespace Section 17.6.1.4, “Moving or Copying InnoDB Tables” ... If ...
https://dev.mysql.com/doc/heatwave/en/mys-hw-lakehouse-table-syntax.html
To set options when creating external tables, you have the following options: As of MySQL 9.4.0, you can use SQL syntax to set table-level and column-level options for external tables. You can use table-level and column-level ENGINE_ATTRIBUTE ...
https://dev.mysql.com/doc/refman/8.4/en/innodb-restrictions-limitations.html
You cannot create a table with a column name that matches the name of an internal InnoDB column (including DB_ROW_ID, DB_TRX_ID, and DB_ROLL_PTR. mysql> CREATE TABLE t1 (c1 INT, db_row_id INT) ENGINE=INNODB; ERROR 1166 (42000): Incorrect column name ...InnoDB does not keep an internal count of rows in a table because concurrent transactions might “see” different numbers of rows at the same ...
https://dev.mysql.com/doc/refman/8.4/en/replication-options-source.html
On the source and each replica, you must set the server_id system variable to establish a unique replication ID. It is not possible to restrict the effects of these two variables to a single table; these variables control the behavior of all ...
https://dev.mysql.com/doc/refman/8.4/en/show-warnings.html
Warnings are generated for DML statements such as INSERT, UPDATE, and LOAD DATA as well as DDL statements such as CREATE TABLE and ALTER TABLE. mysql> CREATE TABLE t1 (a TINYINT NOT NULL, b CHAR(4)); Query OK, 0 rows affected (0.05 sec) mysql> ...
https://dev.mysql.com/doc/internals/en/variation-of-storage-engine.html
That means mostly: DO NOT use hardcoded storage engine assignments within CREATE TABLE statements. Solution 1: Do not assign the storage engine within your CREATE TABLE statements at all. Top level script: let $engine_type= MyISAM; The same script ... Checks of the INFORMATION_SCHEMA The storage engines to be used for information_schema tables are ...
https://dev.mysql.com/doc/refman/8.4/en/charset-database.html
The CREATE DATABASE and ALTER DATABASE statements have optional clauses for specifying the database character set and collation: CREATE DATABASE db_name [[DEFAULT] CHARACTER SET charset_name] [[DEFAULT] COLLATE collation_name] ALTER DATABASE db_name ... Every database has a database character set and a database ...
https://dev.mysql.com/doc/refman/8.4/en/json-utility-functions.html
In the case where it is string, the function returns the amount of storage space in the JSON binary representation that is created by parsing the string as JSON and converting it to binary. This section documents utility functions that act on JSON ...
https://dev.mysql.com/doc/refman/8.4/en/charset-collation-effect.html
latin1_swedish_ci latin1_german1_ci latin1_german2_ci Muffler Muffler Müller MX Systems Müller Muffler Müller MX Systems MX Systems MySQL MySQL MySQL The character that causes the different sort orders in this example is ü (German ...