Search Results
https://dev.mysql.com/doc/refman/8.4/en/example-auto-increment.html
For example: INSERT INTO animals (id,name) VALUES(0,'groundhog'); If the column is declared NOT NULL, it is also possible to assign NULL to the column to generate sequence numbers. For example: INSERT INTO animals (id,name) VALUES(NULL,'squirrel'); ...You can also explicitly assign 0 to the column to generate sequence numbers, unless the NO_AUTO_VALUE_ON_ZERO SQL mode is ...
https://dev.mysql.com/doc/refman/8.4/en/example-foreign-keys.html
MySQL supports foreign keys, which permit cross-referencing related data across tables, and foreign key constraints, which help keep the related data consistent. A foreign key relationship involves a parent table that holds the initial column ...
https://dev.mysql.com/doc/refman/8.4/en/get-diagnostics.html
GET DIAGNOSTICS can obtain either statement or condition information, but not both in the same statement: To obtain statement information, retrieve the desired statement items into target variables. This instance of GET DIAGNOSTICS assigns the ...
https://dev.mysql.com/doc/refman/8.4/en/innodb-buffer-pool.html
For efficiency of high-volume read operations, the buffer pool is divided into pages that can potentially hold multiple rows. When InnoDB reads a page into the buffer pool, it initially inserts it at the midpoint (the head of the old sublist). By ...
https://dev.mysql.com/doc/refman/8.4/en/innodb-locking.html
For example, SELECT c1 FROM t WHERE c1 BETWEEN 10 and 20 FOR UPDATE; prevents other transactions from inserting a value of 15 into column t.c1, whether or not there was already any such value in the column, because the gaps between all existing ...
https://dev.mysql.com/doc/refman/8.4/en/mysqldump.html
Dumps can be easily imported into a MySQL Server instance or a MySQL HeatWave DB System using the MySQL Shell load dump utilities. If you are using a recent version of mysqldump to generate a dump to be reloaded into a very old MySQL server, use the ... The mysqldump client utility performs logical backups, producing a set of SQL statements that can be executed to reproduce the original database object definitions and table ...
https://dev.mysql.com/doc/refman/8.4/en/range-optimization.html
Otherwise, any index on col_name is nonunique and the optimizer can estimate the row count for each range using dives into the index or index statistics. The idea is that if index use is forced, there is nothing to be gained from the additional ...
https://dev.mysql.com/doc/mysql-enterprise-backup/8.4/en/glossary.html
apply The operation that transforms a raw backup into a prepared backup by incorporating changes that occurred while the backup was running, using data from the log. (For recent backups of critical data, you might leave the data uncompressed, to ...
https://dev.mysql.com/doc/connectors/en/connector-j-time-instants.html
For example: When storing java.sql.Timestamp to, for example, a DATETIME column, you might not get back the same instant value when retrieving it into a client that is in a different time zone than the one the client was in when storing the value.
https://dev.mysql.com/doc/connectors/en/connector-odbc-examples-programming-net.html
This section contains simple examples that demonstrate the use of Connector/ODBC drivers with ODBC.NET. 5.6.7.2.1 Using Connector/ODBC with ODBC.NET and C# (C sharp) The following sample creates a table my_odbc_net and demonstrates its use in C#.