MySQL :: MySQL 8.0 Reference Manual

Search Results

Displaying 121 to 129 of 129 total results

« Previous
11
12
13
Next »

https://dev.mysql.com/doc/refman/8.0/en/problems-with-null.html

For example, if you insert NULL into an integer or floating-point column that has the AUTO_INCREMENT attribute, the next number in the sequence is inserted. The concept of the NULL value is a common source of confusion for newcomers to SQL, who ...

15.7.3.5 REPAIR TABLE Statement

https://dev.mysql.com/doc/refman/8.0/en/repair-table.html

Telling the server to ignore the .MYI file makes important table metadata stored in the .MYI unavailable to the repair process, which can have deleterious consequences: The current AUTO_INCREMENT value is lost. [QUICK] [EXTENDED] [USE_FRM] REPAIR ...

19.1.7.3 Skipping Transactions

https://dev.mysql.com/doc/refman/8.0/en/replication-administration-skip.html

One event normally corresponds to one SQL statement in the binary log, but note that statements that use AUTO_INCREMENT or LAST_INSERT_ID() count as two events in the binary log. If replication stops due to an issue with an event in a replicated ...

19.5.1.36 Replication and Triggers

https://dev.mysql.com/doc/refman/8.0/en/replication-features-triggers.html

A statement invoking a trigger (or function) that causes an update to an AUTO_INCREMENT column is not replicated correctly using statement-based replication. With statement-based replication, triggers executed on the source also execute on the ...

15.7.7.10 SHOW CREATE TABLE Statement

https://dev.mysql.com/doc/refman/8.0/en/show-create-table.html

row *************************** Table: t Create Table: CREATE TABLE `t` ( `id` int NOT NULL AUTO_INCREMENT, `s` char(60) DEFAULT NULL, PRIMARY KEY (`id`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci As of MySQL 8.0.16, MySQL ...

30.4.1 sys Schema Object Index

https://dev.mysql.com/doc/refman/8.0/en/sys-schema-object-index.html

The following tables list sys schema objects and provide a short description of each one.

15.1.37 TRUNCATE TABLE Statement

https://dev.mysql.com/doc/refman/8.0/en/truncate-table.html

Logically, TRUNCATE TABLE is similar to a DELETE statement that deletes all rows, or a sequence of DROP TABLE and CREATE TABLE statements. To achieve high performance, TRUNCATE TABLE bypasses the DML method of deleting data. Thus, it does not cause ...

14.3 Type Conversion in Expression Evaluation

https://dev.mysql.com/doc/refman/8.0/en/type-conversion.html

When an operator is used with operands of different types, type conversion occurs to make the operands compatible. For example, MySQL automatically converts strings to numbers as necessary, and vice versa. mysql> SELECT 1+'1'; -> 2 mysql> SELECT ...

15.2.17 UPDATE Statement

https://dev.mysql.com/doc/refman/8.0/en/update.html

UPDATE is a DML statement that modifies rows in a table. An UPDATE statement can start with a WITH clause to define common table expressions accessible within the UPDATE. Single-table syntax: UPDATE [LOW_PRIORITY] [IGNORE] table_reference SET ...