Search Results
https://dev.mysql.com/doc/refman/8.4/en/charset-unicode-utf16.html
Because utf16 supports surrogates and ucs2 does not, there is a validity check that applies only in utf16: You cannot insert a top surrogate without a bottom surrogate, or vice versa. For example, since U+F8FF is the Apple Logo, this is legal: ...
https://dev.mysql.com/doc/refman/8.4/en/comparison-operators.html
For details, including the return value after a multiple-row insert, see Section 14.15, “Information Functions”. If no AUTO_INCREMENT value was successfully inserted, the SELECT statement returns no row. Table 14.4 Comparison Operators Name ...
https://dev.mysql.com/doc/refman/8.4/en/constraint-primary-key.html
Normally, errors occur for data-change statements (such as INSERT or UPDATE) that would violate primary-key, unique-key, or foreign-key constraints. MySQL supports an IGNORE keyword for INSERT, UPDATE, and so forth. See the section for the ...If ...
https://dev.mysql.com/doc/refman/8.4/en/create-event.html
CREATE [DEFINER = user] EVENT [IF NOT EXISTS] event_name ON SCHEDULE schedule [ON COMPLETION [NOT] PRESERVE] [ENABLE | DISABLE | DISABLE ON {REPLICA | SLAVE}] [COMMENT 'string'] DO event_body; schedule: { AT timestamp [+ INTERVAL interval] ... The ...
https://dev.mysql.com/doc/refman/8.4/en/create-table-secondary-indexes.html
There are additional write costs to consider when using a secondary index on a virtual column due to computation performed when materializing virtual column values in secondary index records during INSERT and UPDATE operations. A secondary index ...
https://dev.mysql.com/doc/refman/8.4/en/create-table-select.html
This follows the same rules as with VALUES; all columns of the source table and their names in the source table are always inserted into the new table. SELECT, if IF NOT EXISTS is given and the target table exists, nothing is inserted into the ...
https://dev.mysql.com/doc/refman/8.4/en/creating-accounts.html
Note Direct modification of grant tables using statements such as INSERT, UPDATE, or DELETE is discouraged and done at your own risk. To manage MySQL accounts, use the SQL statements intended for that purpose: CREATE USER and DROP USER create and ...
https://dev.mysql.com/doc/refman/8.4/en/encryption-functions.html
For example: INSERT INTO t VALUES (1,AES_ENCRYPT('text',UNHEX('F3229A0B371ED2D9441B830D21A390C3'))); A passphrase can be used to generate an AES key by hashing the passphrase. For example: INSERT INTO t VALUES (1,AES_ENCRYPT('text', UNHEX(SHA2('My ...If you want to store these results, use a column with a VARBINARY or BLOB binary string data ...
https://dev.mysql.com/doc/refman/8.4/en/explain-output.html
For INSERT or REPLACE statements, EXPLAIN displays this value when there is no SELECT part. For example, it appears for EXPLAIN INSERT INTO t VALUES(10) because that is equivalent to EXPLAIN INSERT INTO t SELECT 10 FROM DUAL. The EXPLAIN statement ...
https://dev.mysql.com/doc/refman/8.4/en/extensions-to-ansi.html
The LOW_PRIORITY clause of the INSERT, REPLACE, DELETE, and UPDATE statements. For example: mysql> SELECT col1=1 AND col2=2 FROM my_table; The LAST_INSERT_ID() function returns the most recent AUTO_INCREMENT value. MySQL Server supports some ...