Search Results
https://dev.mysql.com/doc/refman/8.4/en/roles.html
To restore modification privileges to the role, simply re-grant them: GRANT INSERT, UPDATE, DELETE ON app_db.* TO 'app_write'; Now rw_user1 again has modification privileges, as do any other accounts granted the app_write role. Like user accounts, ...
https://dev.mysql.com/doc/refman/8.4/en/values.html
The DEFAULT keyword is not supported by VALUES and causes a syntax error, except when it is used to supply values in an INSERT statement. You should also not confuse it with the VALUES() function that refers to column values in INSERT ... In place ... VALUES is a DML statement which returns a set of one or more rows as a ...
https://dev.mysql.com/doc/c-api/8.4/en/mysql-affected-rows.html
It returns the number of rows changed, deleted, or inserted by the last statement if it was an UPDATE, DELETE, or INSERT. For REPLACE statements, the affected-rows value is 2 if the new row replaced an old row, because in this case, one row was ...
https://dev.mysql.com/doc/workbench/en/wb-develop-sql-editor-results.html
Note MySQL Workbench handles quoting and escaping for strings entered into the result grid, so adding quotes and proper escaping here is optional. Note It is possible to enter a function, or other expression, into a field. Export: Writes a result ...
https://dev.mysql.com/doc/internals/en/the-myi-file.html
A .MYI file for a MyISAM table contains the table's indexes. The .MYI file has two parts: the header information and the key values. So the next sub-sections will be "The .MYI Header" and "The .MYI Key Values". The .MYI Header A .MYI file begins ...
https://dev.mysql.com/doc/refman/8.4/en/aggregate-functions.html
They are often used with a GROUP BY clause to group values into subsets. For a faster count, create a counter table and let your application update it according to the inserts and deletes it does. To specify a separator explicitly, use SEPARATOR ...
https://dev.mysql.com/doc/refman/8.4/en/charset-unicode-utf16.html
For example, since U+F8FF is the Apple Logo, this is legal: INSERT INTO t (utf16_column)VALUES (0xf8ff); /* legal */ Such characters cannot be expected to mean the same thing to everyone. Because utf16 supports surrogates and ucs2 does not, there is ... The utf16 character set is the ucs2 character set with an extension that enables encoding of supplementary characters: For a BMP character, utf16 and ucs2 have identical storage characteristics: same code values, same encoding, same ...
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 ...To ... You can create one table from another by adding a SELECT statement at the end of the CREATE TABLE statement: CREATE TABLE new_tbl [AS] SELECT * FROM orig_tbl; MySQL creates new columns for all elements in the ...
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 ...