Search Results
https://dev.mysql.com/doc/refman/8.4/en/optimizing-innodb-bulk-data-loading.html
When importing data into InnoDB, turn off autocommit mode, because it performs a log flush to disk for every insert. Use the multiple-row INSERT syntax to reduce communication overhead between the client and the server if you need to insert many ...
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/data-type-defaults.html
When not using strict mode, only the third statement produces an error; the implicit default is inserted for the first two statements, but the third fails because DEFAULT(i) cannot produce a value: INSERT INTO t VALUES(); INSERT INTO t ...For ...
https://dev.mysql.com/doc/internals/en/guided-tour-skeleton.html
Graphic: client <===== MESSAGE ====> server <======PACKETS ====> Example: INSERT INTO Table1 VALUES (1); To put it graphically, at this point there is a long-lasting connection between the client and one server thread. The first thing to do is check ...Important files we'll be walking through: /sql/mysqld.cc /sql/sql_parse.cc /sql/sql_prepare.cc /sql/sql_insert.cc /sql/ha_myisam.cc /myisam/mi_write.c This is not as simple as what we've just ...
https://dev.mysql.com/doc/refman/8.4/en/precision-math-expressions.html
In strict SQL mode, for INSERT into a column with an exact data type (DECIMAL or integer), a number is inserted with its exact value if it is within the column range. Inserts into numeric columns are affected by the SQL mode, which is controlled by ...When retrieved, the value should be the same as what was ... With precision ...
https://dev.mysql.com/doc/connector-odbc/en/connector-odbc-examples-programming-net-vb.html
The following sample creates a table my_vb_net and demonstrates the use in VB.
https://dev.mysql.com/doc/refman/8.4/en/archive-storage-engine.html
ARCHIVE does not support inserting a value into an AUTO_INCREMENT column less than the current maximum column value. There are several types of insertions that are used: An INSERT statement just pushes rows into a compression buffer, and that buffer ...The ARCHIVE engine supports INSERT, REPLACE, and SELECT, but not DELETE or ... The ARCHIVE storage engine produces ...
https://dev.mysql.com/doc/refman/8.4/en/lock-tables.html
This occurs because t2 is inserted into within the trigger, so the READ request is converted to a WRITE request. The LOCAL modifier enables nonconflicting INSERT statements (concurrent inserts) by other sessions to execute while the lock is held.
https://dev.mysql.com/doc/x-devapi-userguide/en/collections-as-relational-tables.html
The following example shows how to insert a JSON document string into the doc field. Applications that seek to store standard SQL columns with Documents can cast a collection to a table. In this case a collection can be fetched as a Table object ...
https://dev.mysql.com/doc/x-devapi-userguide/en/transaction-handling.html
Transactions can be used to group operations into an atomic unit. Either all operations of a transaction succeed when they are committed, or none. It is possible to roll back a transaction as long as it has not been committed. Transactions can be ...