Search Results
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/9.7/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/9.7/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/9.7/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/refman/9.7/en/mysql-cluster-ndbd-definition.html
(This also means that DataMemory pages, once allocated to a given table, cannot be used by other tables.) Performing a data node recovery also compresses the partition because all records are inserted into empty partitions from other live nodes.
https://dev.mysql.com/doc/refman/9.7/en/srjs-examples.html
This section contains examples illustrating a number of different aspects of using JavaScript programs under various circumstances. The following example demonstrates the use of a JavaScript stored function with table column values. Next, we create ...
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/c-api/9.7/en/mysql-stmt-execute.html
Statement processing following mysql_stmt_execute() depends on the type of statement: For an UPDATE, DELETE, or INSERT, the number of changed, deleted, or inserted rows can be found by calling mysql_stmt_affected_rows(). int ...