Search Results
https://dev.mysql.com/doc/refman/9.7/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/9.7/en/date-and-time-literals.html
You can specify a time zone offset when inserting TIMESTAMP and DATETIME values into a table. The value inserted must not have a zero for the month part, the day part, or both parts. Standard SQL and ODBC Date and Time Literals String and Numeric ...
https://dev.mysql.com/doc/refman/9.7/en/charset-binary-collations.html
The binary collation differs from _bin collations in several respects, discussed in the following sections: The Unit for Comparison and Sorting Character Set Conversion Lettercase Conversion Trailing Space Handling in Comparisons Trailing Space ...
https://dev.mysql.com/doc/refman/9.7/en/create-event.html
row *************************** EVENT_NAME: e EVENT_SCHEMA: d EVENT_DEFINITION: INSERT INTO d.t VALUES ROW(NULL, NOW(), FLOOR(RAND()*100)) EVENT_TYPE: RECURRING 1 row in set (0.00 sec) If an event's definer has privileges sufficient to set global ...
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/refman/9.7/en/json-modification-functions.html
JSON_INSERT(json_doc, path, val[, path, val] ...) Inserts data into a JSON document and returns the result. If a path identifies an array element, the corresponding value is inserted at that element position, shifting any following values to the ...
https://dev.mysql.com/doc/refman/9.7/en/mysql-cluster-programs-ndb-restore.html
This program reads the files created as a result of the backup and inserts the stored information into the database. Otherwise, any trailing spaces are dropped from such column values when they are inserted into the new columns. You should use this ...--num-slices=# Command-Line Format --num-slices=# Type Integer Default Value 1 Minimum Value 1 Maximum Value 1024 When restoring a backup by slices, this option sets the number of slices into which to divide the ...
https://dev.mysql.com/doc/refman/9.7/en/partitioning-management-range-list.html
However, there is one important difference in the effect this has on your use of the table afterward: You can no longer insert into the table any rows having any of the values that were included in the value list defining the deleted partition.
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 NDB API applications, there are two types of failures to be taken into account: Transaction failures: If nonpermanent, these can be handled ... This program demonstrates handling errors and retrying failed transactions using the NDB ...
https://dev.mysql.com/doc/refman/9.7/en/miscellaneous-functions.html
mysql> INSERT INTO table (a,b,c) VALUES (1,2,3),(4,5,6) -> ON DUPLICATE KEY UPDATE c=VALUES(a)+VALUES(b); Important This usage is deprecated, and subject to removal in a future release of MySQL. The MAC address of an interface is taken into account ...The function return value and type are the same as the return value and type of its argument, but the function result is not checked for the ONLY_FULL_GROUP_BY SQL ...