PDF (US Ltr)
- 35.1Mb
PDF (A4)
- 35.2Mb
Man Pages (TGZ)
- 256.4Kb
Man Pages (Zip)
- 361.2Kb
Info (Gzip)
- 3.4Mb
Info (Zip)
- 3.4Mb
Search Results
https://dev.mysql.com/doc/refman/5.7/en/create-table-generated-columns.html
STORED: Column values are evaluated and stored when rows are inserted or updated. For INSERT, REPLACE, and UPDATE, if a generated column is inserted into, replaced, or updated explicitly, the only permitted value is DEFAULT. Values of a generated ...
https://dev.mysql.com/doc/refman/5.7/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/5.7/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/5.7/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/5.7/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/5.7/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 ...
https://dev.mysql.com/doc/refman/5.7/en/fulltext-stopwords.html
The stopword list is loaded and searched for full-text queries using the server character set and collation (the values of the character_set_server and collation_server system variables). False hits or misses might occur for stopword lookups if the ...
https://dev.mysql.com/doc/refman/5.7/en/gone-away.html
An INSERT or REPLACE statement that inserts a great many rows can also cause these sorts of errors. Either one of these statements sends a single request to the server irrespective of the number of rows to be inserted; thus, you can often avoid the ... This section also covers the related Lost connection to server during query ...
https://dev.mysql.com/doc/refman/5.7/en/grant-tables.html
Note Direct modification of grant tables using statements such as INSERT, UPDATE, or DELETE is discouraged and done at your own risk. The mysql system database includes several grant tables that contain information about user accounts and the ...
https://dev.mysql.com/doc/refman/5.7/en/information-schema-innodb-ft-index-cache-table.html
The INNODB_FT_INDEX_CACHE table provides token information about newly inserted rows in a FULLTEXT index. The INNODB_FT_INDEX_CACHE table has these columns: WORD A word extracted from the text of a newly inserted row. Before querying it, set the ...