Search Results
https://dev.mysql.com/doc/refman/8.4/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/8.4/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/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/8.4/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/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/8.4/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 ...
https://dev.mysql.com/doc/refman/8.4/en/performance-schema-statement-tables.html
If the request is, for example, an INSERT statement, the Performance Schema refines the instrument name from statement/abstract/Query to statement/sql/insert, which is the final name. If the request is, for example, an INSERT statement, the ...
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-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 ...
https://dev.mysql.com/doc/refman/8.4/en/show-grants.html
SHOW GRANTS [FOR user_or_role [USING role [, role] ...]] user_or_role: { user (see Section 8.2.4, “Specifying Account Names”) | role (see Section 8.2.5, “Specifying Role Names”. } This statement displays the privileges and roles that are ...