Search Results
https://dev.mysql.com/doc/refman/8.4/en/create-table-generated-columns.html
STORED: Column values are evaluated and stored when rows are inserted or updated. If the column is also declared as NOT NULL, attempting to insert NULL is explicitly rejected with ER_BAD_NULL_ERROR. For INSERT, REPLACE, and UPDATE, if a generated ...
https://dev.mysql.com/doc/refman/8.4/en/faqs-general.html
A multiple-table insert can be accomplished using a trigger whose FOR EACH ROW clause contains multiple INSERT statements within a BEGIN ... However, MySQL has an AUTO_INCREMENT system, which can also handle inserts in a multi-source replication ...
https://dev.mysql.com/doc/refman/8.4/en/faqs-views.html
Can you insert into views that are based on joins? A.6.1. Can you insert into views that are based on joins? It is possible, provided that your INSERT statement has a column list that makes it clear there is only one table involved. You cannot ...
https://dev.mysql.com/doc/refman/8.4/en/fractional-seconds.html
(This differs from the standard SQL default of 6, for compatibility with previous MySQL versions.) Inserting a TIME, DATE, or TIMESTAMP value with a fractional seconds part into a column of the same type but having fewer fractional digits results in ... MySQL has fractional seconds support for TIME, DATETIME, and TIMESTAMP values, with up to microseconds (6 digits) precision: To define a column that includes a fractional seconds part, use the syntax type_name(fsp), where type_name is TIME, DATETIME, or TIMESTAMP, and fsp is the fractional seconds ...
https://dev.mysql.com/doc/refman/8.4/en/innodb-autocommit-commit-rollback.html
mysql> START TRANSACTION; Query OK, 0 rows affected (0.00 sec) mysql> INSERT INTO customer VALUES (10, 'Heikki'); Query OK, 1 row affected (0.00 sec) mysql> COMMIT; Query OK, 0 rows affected (0.00 sec) mysql> -- Do another transaction with ...If ...
https://dev.mysql.com/doc/refman/8.4/en/innodb-information-schema-fulltext_index-tables.html
INNODB_FT_INDEX_CACHE: Provides token information about newly inserted rows in a FULLTEXT index. mysql> SET GLOBAL innodb_ft_aux_table = 'test/articles'; Query the INNODB_FT_INDEX_CACHE table, which shows information about newly inserted rows in a ...INNODB_FT_BEING_DELETED: Provides a snapshot of the INNODB_FT_DELETED table; it is used only during an OPTIMIZE TABLE maintenance ...
https://dev.mysql.com/doc/refman/8.4/en/innodb-locking-reads.html
If you query data and then insert or update related data within the same transaction, the regular SELECT statement does not give enough protection. Can you safely insert the child row to table CHILD? No, because some other session could delete the ...Other transactions can update or delete the same rows you just ...
https://dev.mysql.com/doc/refman/8.4/en/internal-temporary-tables.html
SELECT statements that select from and insert into the same table, MySQL creates an internal temporary table to hold the rows from the SELECT, then inserts those rows into the target table. The union is not the top-level query block of an {INSERT | ... In some cases, the server creates internal temporary tables while processing ...
https://dev.mysql.com/doc/refman/8.4/en/join.html
MySQL supports the following JOIN syntax for the table_references part of SELECT statements and multiple-table DELETE and UPDATE statements: table_references: escaped_table_reference [, escaped_table_reference] ... index_hint: { USE {INDEX|KEY} ...
https://dev.mysql.com/doc/refman/8.4/en/json-validation-functions.html
As before, you can see this by attempting to insert the value into the geo table, then issuing SHOW WARNINGS afterwards: mysql> INSERT INTO geo VALUES(@point3); ERROR 3819 (HY000): Check constraint 'geo_chk_1' is violated. MySQL supports validation ...