Search Results
https://dev.mysql.com/doc/refman/9.7/en/load-xml.html
User variables can be especially useful when you want to insert data from an XML file into table columns whose names do not match those of the XML fields. To write data from a table to an XML file, you can invoke the mysql client with the --xml and ...The tagname in the optional ROWS IDENTIFIED BY clause must also be given as a literal string, and must be surrounded by angle brackets (< 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 ...
https://dev.mysql.com/doc/refman/9.7/en/ansi-diff-foreign-keys.html
In an SQL statement that inserts, deletes, or updates many rows, foreign key constraints (like unique constraints) are checked row-by-row. In that case, a (child table) row containing such a foreign key can be inserted even though it does not match ...For example, if you define a RESTRICT type constraint, and there is a child row with several parent rows, InnoDB does not permit the deletion of any of the parent ...
https://dev.mysql.com/doc/refman/9.7/en/atomic-ddl.html
An atomic DDL statement combines the data dictionary updates, storage engine operations, and binary log writes associated with a DDL operation into a single, atomic operation. Atomic DDL Characteristics The characteristics of atomic DDL statements ...The operation is either committed, with applicable changes persisted to the data dictionary, storage engine, and binary log, or is rolled back, even if the server halts during the ...
https://dev.mysql.com/doc/refman/9.7/en/mysql-shell-tutorial-javascript-documents-in-tables.html
In the following example, a document is passed as the final value to be inserted into the Info column. mysql-js> db.city.insert().values( None, "San Francisco", "USA", "California", '{"Population":830000}') Select a Record You can issue a query with ... In MySQL, a table may contain traditional relational data, JSON values, or ...
https://dev.mysql.com/doc/refman/9.7/en/mysql-shell-tutorial-python-documents-in-tables.html
In the following example, a document is passed as the final value to be inserted into the Info column. mysql-py> db.city.insert().values( None, "San Francisco", "USA", "California", '{"Population":830000}') Select a Record You can issue a query with ... In MySQL, a table may contain traditional relational data, JSON values, or ...
https://dev.mysql.com/doc/refman/9.7/en/replication-features-variables.html
sql_mode is also replicated except for the NO_DIR_IN_CREATE mode; the replica always preserves its own value for NO_DIR_IN_CREATE, regardless of changes to it on the source. However, when mysqlbinlog parses a SET @@sql_mode = mode statement, the ...
https://dev.mysql.com/doc/refman/9.7/en/view-check-option.html
The check for v3 also fails: mysql> INSERT INTO v2 VALUES (2); ERROR 1369 (HY000): CHECK OPTION failed 'test.v2' mysql> INSERT INTO v3 VALUES (2); ERROR 1369 (HY000): CHECK OPTION failed 'test.v3' . The WITH CHECK OPTION clause can be given for an ...It also prevents updates to rows for which the WHERE clause is true but the update would cause it to be not true (in other words, it prevents visible rows from being updated to nonvisible ...
https://dev.mysql.com/doc/relnotes/mysql/9.7/en/news-9-6-0.html
This update splits the monolithic Audit Log software into smaller, more manageable components, encapsulated into MySQL components, making it easier to install, manage, and maintain. (Bug #110485, Bug #35221441) Fixed an issue related to bulk inserts. You can explicitly specify allowed DML operations (INSERT, UPDATE, DELETE) per table when defining a JSON duality ...