Search Results
https://dev.mysql.com/doc/refman/8.4/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/8.4/en/request-access.html
This is where the privilege columns in the grant tables come into play. A '%' or blank Host value means “any host.” A '%' or blank Db value means “any database.” The server reads the db table into memory and sorts it at the same time that it ... After the server accepts a connection, it enters Stage 2 of access ...
https://dev.mysql.com/doc/refman/8.4/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/8.4/en/subquery-restrictions.html
MySQL permits a subquery to refer to a stored function that has data-modifying side effects such as inserting rows into a table. FROM t ...); Exception: The preceding prohibition does not apply if for the modified table you are using a derived table ... In general, you cannot modify a table and select from the same table in a ...
https://dev.mysql.com/doc/refman/8.4/en/timestamp-lookups.html
Temporal values are stored in TIMESTAMP columns as UTC values, and values inserted into and retrieved from TIMESTAMP columns are converted between the session time zone and UTC. (The example shown earlier illustrates how this can occur.) The query ...(This is the same type of conversion performed by the CONVERT_TZ() ...
https://dev.mysql.com/doc/connectors/en/connector-net-tutorials-sql-command.html
The results are usually returned into a MySqlDataReader object, and then processed. This is because ExecuteNonQuery is only used for inserting, updating and deleting data. When a connection has been established with the MySQL database, the next ...
https://dev.mysql.com/doc/connectors/en/connector-python-api-errors-integrityerror.html
The following example shows a duplicate key error raised as IntegrityError: cursor.execute("CREATE TABLE t1 (id int, PRIMARY KEY (id))") try: cursor.execute("INSERT INTO t1 (id) VALUES (1)") cursor.execute("INSERT INTO t1 (id) VALUES (1)") except ...
https://dev.mysql.com/doc/connector-net/en/connector-net-tutorials-sql-command.html
The results are usually returned into a MySqlDataReader object, and then processed. This is because ExecuteNonQuery is only used for inserting, updating and deleting data. When a connection has been established with the MySQL database, the next ...
https://dev.mysql.com/doc/connector-python/en/connector-python-api-errors-integrityerror.html
The following example shows a duplicate key error raised as IntegrityError: cursor.execute("CREATE TABLE t1 (id int, PRIMARY KEY (id))") try: cursor.execute("INSERT INTO t1 (id) VALUES (1)") cursor.execute("INSERT INTO t1 (id) VALUES (1)") except ...
https://dev.mysql.com/doc/x-devapi-userguide/en/collection-modify.html
For example: arrayInsert("favorNums[1]", 7), arrayInsert("favorNums[1]", {even: 2, odd: 3, irrational: 'pi'}). If DocPath identifies an array position past the end of an array, the value is inserted at the end of the array. The ...