Search Results
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/mysql-ai/9.5/en/mys-ai-aml-prepare-an-anomaly-detection-model.html
mysql> CREATE DATABASE anomaly_data; mysql> USE anomaly_data; Create the table to insert the sample data into. mysql> CREATE TABLE credit_card_train ( transaction_id INT AUTO_INCREMENT PRIMARY KEY, home_address VARCHAR(100), purchase_location ...
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 ...
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/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/json-modification-functions.html
If a path identifies an array element, the corresponding value is inserted at that element position, shifting any following values to the right. If a path identifies an array position past the end of an array, the value is inserted at the end of the ... The functions in this section modify JSON values and return the ...