Search Results
https://dev.mysql.com/doc/refman/9.7/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/9.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/9.7/en/innodb-and-mysql-replication.html
It is possible to use replication in a way where the storage engine on the replica is not the same as the storage engine on the source. For example, you can replicate modifications to an InnoDB table on the source to a MyISAM table on the replica.
https://dev.mysql.com/doc/refman/9.7/en/memory-storage-engine.html
Deleted rows are put in a linked list and are reused when you insert new data into the table. For example, you can put statements such as INSERT INTO ... MEMORY tables also have none of the problems commonly associated with deletes plus inserts in ... The MEMORY storage engine (formerly known as HEAP) creates special-purpose tables with contents that are stored in ...
https://dev.mysql.com/doc/refman/9.7/en/mysql-cluster-replication-issues.html
If this occurs, it is entirely possible for new data to be inserted into the source cluster without being recorded in the source SQL node's binary log. In the event of a node failure, errors in replication of NDB tables without primary keys can ...
https://dev.mysql.com/doc/refman/9.7/en/precision-math-rounding.html
This section discusses precision math rounding for the ROUND() function and for inserts into columns with exact-value types (DECIMAL and integer). The ROUND() function rounds differently depending on whether its argument is exact or approximate: ...
https://dev.mysql.com/doc/refman/9.7/en/telemetry-metrics-meter-metrics.html
rows_deleted Innodb_rows_deleted ASYNC COUNTER The number of rows inserted into InnoDB tables. system_rows_inserted Innodb_system_rows_inserted ASYNC COUNTER Number of rows inserted into InnoDB tables belonging to system-created schemas ...write ...
https://dev.mysql.com/doc/relnotes/mysql/9.7/en/news-9-7-0.html
With this update, you can leverage auto-generated values for primary keys, enabling easier insertion of data into JSON duality views. Errors were returned similar to the following: ERROR 3977 (HY000) at line 117: Only BINLOG INSERT, COMMIT and ...
https://dev.mysql.com/doc/workbench/en/wb-forward-engineering-sql-scripts.html
Figure 9.36 SQL Export Options The SQL Export Options displays the following facilities: Output SQL Script File: To specify the output file name, enter it into the Output SQL Script File field, or use the Browse button to select a file. Don't create ... Forward engineering enables you to create a script of your database ...
https://dev.mysql.com/doc/internals/en/multi-resultset.html
In our case we inserted 2 rows, but only the affected_rows of the last INSERT statement is returned as part of the OK_Packet. 01 31 00 0c 3f 00 01 00 00 00 08 81 00 00 00 00 .1..?........... 05 00 00 03 fe 00 00 0a 00 02 00 00 04 01 31 05 ...