Search Results
https://dev.mysql.com/doc/refman/8.4/en/innodb-undo-logs.html
For example, a transaction that performs INSERT, UPDATE, and DELETE operations on regular and temporary tables requires a full assignment of four undo logs. A transaction that performs only INSERT operations on regular tables requires a single undo ... An undo log is a collection of undo log records associated with a single read-write ...
https://dev.mysql.com/doc/refman/8.4/en/metadata-locking.html
Client 2: INSERT INTO x VALUES(1); The statement requests and blocks waiting for a write lock on x. Client 2 then acquires its lock on x, performs the insert, and releases its lock. Lock acquisition order results in the RENAME TABLE executing before ... MySQL uses metadata locking to manage concurrent access to database objects and to ensure data ...
https://dev.mysql.com/doc/refman/8.4/en/mysqlslap.html
The permissible values are read (scan tables), write (insert into tables), key (read primary keys), update (update primary keys), or mixed (half inserts, half scanning selects). --auto-generate-sql-write-number=N Command-Line Format ... mysqlslap is ...
https://dev.mysql.com/doc/refman/8.4/en/partitioning-columns-range.html
As with table partitioned by RANGE, you can use MAXVALUE to represent a value such that any legal value inserted into a given column is always less than this value. Placement of rows into partitions is determined by comparing the tuple from a row to ... Range columns partitioning is similar to range partitioning, but enables you to define partitions using ranges based on multiple column ...
https://dev.mysql.com/doc/refman/8.4/en/privileges-provided.html
Renaming a table requires ALTER and DROP on the old table, CREATE, and INSERT on the new table. The creating session can perform any operation on the table, such as DROP TABLE, INSERT, UPDATE, or SELECT. INSERT Enables rows to be inserted into ...
https://dev.mysql.com/doc/refman/8.4/en/problems-with-null.html
For example, the following statements are completely different: mysql> INSERT INTO my_table (phone) VALUES (NULL); mysql> INSERT INTO my_table (phone) VALUES (''); Both statements insert a value into the phone column, but the first inserts a NULL ...
https://dev.mysql.com/doc/connector-odbc/en/connector-odbc-examples-programming-net-csharp.html
The following sample creates a table my_odbc_net and demonstrates its use in C#. { for (int i=0; i < MyOdbcException.Errors.Count; i++) { Console.Write("ERROR #" + i + "\n" + "Message: " + MyOdbcException.Errors[i].Message + "\n" + "Native: " + ...
https://dev.mysql.com/doc/internals/en/replication-correct.html
Specifically: If the slave has a uniqueness constraint (PK or UK), then uniqueness must be guaranteed before a row is inserted on the slave. If a column only exists on the slave (or if application-specific logic ensures that only NULL values are ...
https://dev.mysql.com/doc/ndbapi/en/ndb-examples-handling-errors.html
In this example, we perform two inserts in the same transaction using NdbTransaction::execute(NoCommit). In this example // we execute two inserts in the same transaction using // NdbConnection::execute(NoCommit). \n"; for (int i = 10000; i < 20000; ... This program demonstrates handling errors and retrying failed transactions using the NDB ...
https://dev.mysql.com/doc/ndbapi/en/ndb-ndbtransaction.html
A pointer to an NdbRecord indicating an attribute (attr_rec) to be inserted. A row (attr_row) of data to be inserted as the attribute. A mask which can be used to filter the columns to be inserted. Return value A const pointer to the NdbOperation ...