Search Results
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/internals/en/guided-tour-skeleton.html
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 done. Our objective is to follow the server from the time ... And now we're going to walk through something harder, namely the ...
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 ...
https://dev.mysql.com/doc/mysql-monitor/8.0/en/performance-advisors-ref.html
Default frequency 00:05:00 Default auto-close enabled no MyISAM Concurrent Insert Setting May Not Be Optimal MyISAM uses table-level locking, which can adversely affect performance when there are many concurrent INSERT and SELECT statements because ...For optimal performance, transactions that move through the binary log should be contained within the binary log ...
https://dev.mysql.com/doc/refman/8.4/en/archive-storage-engine.html
The ARCHIVE engine supports INSERT, REPLACE, and SELECT, but not DELETE or UPDATE. 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 ...
https://dev.mysql.com/doc/refman/8.4/en/data-type-defaults.html
For nontransactional tables, an error occurs, but if this happens for the second or subsequent row of a multiple-row statement, the preceding rows are inserted. Suppose that a table t is defined as follows: CREATE TABLE t (i INT NOT NULL); In this ... Data type specifications can have explicit or implicit default ...
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/lock-tables.html
The LOCAL modifier enables nonconflicting INSERT statements (concurrent inserts) by other sessions to execute while the lock is held. (See Section 10.11.3, “Concurrent Inserts”.) However, READ LOCAL cannot be used if you are going to manipulate ... LOCK {TABLE | TABLES} tbl_name [[AS] alias] lock_type [, tbl_name [[AS] alias] lock_type] ...
https://dev.mysql.com/doc/refman/8.4/en/optimizing-innodb-bulk-data-loading.html
These performance tips supplement the general guidelines for fast inserts in Section 10.2.5.1, “Optimizing INSERT Statements”. When importing data into InnoDB, turn off autocommit mode, because it performs a log flush to disk for every insert.