Search Results
https://dev.mysql.com/doc/refman/9.7/en/mysql-shell-tutorial-python-relational-tables.html
mysql-py> db.get_tables() [ <Table:city>, <Table:country>, <Table:countrylanguage> ] Basic Table Operations Basic operations scoped by tables include: Operation form Description db.name.insert() The insert() method inserts one or more records into ... You can also use X DevAPI to work with relational ...
https://dev.mysql.com/doc/refman/9.7/en/mysqldumpslow.html
The MySQL slow query log contains information about queries that take a long time to execute (see Section 7.4.5, “The Slow Query Log”). mysqldumpslow parses MySQL slow query log files and summarizes their contents. Normally, mysqldumpslow ...
https://dev.mysql.com/doc/refman/9.7/en/partitioning-limitations.html
Reads from such tables are relatively unaffected; pending INSERT and UPDATE operations are performed as soon as the partitioning operation has completed. This section discusses current restrictions and limitations on MySQL partitioning support. The ...
https://dev.mysql.com/doc/refman/9.7/en/performance-schema-transaction-tables.html
INSERT INTO t2 VALUES (1), (2), (3); -- Update nontransactional table 7. INSERT INTO t1 VALUES (4), (5), (6); -- Write to transactional table -- Transaction 2 START (implicit) 9. Within the event hierarchy, wait events nest within stage events, ...
https://dev.mysql.com/doc/refman/9.7/en/problems-connecting.html
A very common error is to insert a new row with Host='%' and User='some_user', thinking that this enables you to specify localhost to connect from the same machine. Because that row has a Host value 'localhost' that is more specific than '%', it is ... If you encounter problems when you try to connect to the MySQL server, the following items describe some courses of action you can take to correct the ...
https://dev.mysql.com/doc/refman/9.7/en/replication-features-auto-increment.html
Statement-based replication of AUTO_INCREMENT, LAST_INSERT_ID(), and TIMESTAMP values is carried out subject to the following exceptions: A statement invoking a trigger or function that causes an update to an AUTO_INCREMENT column is not replicated ...(Bug #11754117, Bug #45670) This issue does not affect tables using the InnoDB storage engine, since an InnoDB table with an AUTO_INCREMENT column requires at least one key where the auto-increment column is the only or leftmost ...
https://dev.mysql.com/doc/refman/9.7/en/replication-features-memory.html
SELECT FROM memory_table may insert a different set of rows on the source and replica. When a replication source server shuts down and restarts, its MEMORY tables become empty. To replicate this effect to replicas, the first time that the source ...
https://dev.mysql.com/doc/refman/9.7/en/request-access.html
(The latter table contains no Shutdown_priv column, so there is no need to check it.) For database-related requests (INSERT, UPDATE, and so on), the server first checks the user's global privileges in the user table row (less any privilege ... After ...
https://dev.mysql.com/doc/refman/9.7/en/scalar-subqueries.html
In its simplest form, a subquery is a scalar subquery that returns a single value. A scalar subquery is a simple operand, and you can use it almost anywhere a single column value or literal is legal, and you can expect it to have those ...
https://dev.mysql.com/doc/refman/9.7/en/show-procedure-code.html
For each statement that is taken from source, there is a code word stmt followed by a type (9 means DROP, 5 means INSERT, and so on). SHOW PROCEDURE CODE proc_name This statement is a MySQL extension that is available only for servers that have ...