Search Results
https://dev.mysql.com/doc/refman/8.4/en/create-index.html
The expression need not reference an existing element in a JSON document inserted into the indexed column, but must itself be syntactically valid. Take this into account when specifying a prefix length for a nonbinary string column that uses a ...
https://dev.mysql.com/doc/refman/8.4/en/problems-with-null.html
For example, the following statements are completely different: mysql> INSERT INTO my_table (phone) VALUES (NULL); mysql> INSERT INTO my_table (phone) VALUES (''); Both statements insert a value into the phone column, but the first inserts a NULL ...
https://dev.mysql.com/doc/refman/8.4/en/events-privileges.html
This user then creates the following event: CREATE EVENT e_insert ON SCHEDULE EVERY 7 SECOND DO INSERT INTO myschema.mytable; After this event has been created, root revokes the EVENT privilege for jon@ghidora. However, e_insert continues to ... To ...
https://dev.mysql.com/doc/refman/8.4/en/privileges-provided.html
INSERT Enables rows to be inserted into tables in a database. The MySQL server reads the contents of the grant tables into memory when it starts, and reloads them under the circumstances indicated in Section 8.2.13, “When Privilege Changes Take ...
https://dev.mysql.com/doc/refman/8.4/en/metadata-locking.html
Client 2: INSERT INTO x VALUES(1); The statement requests and blocks waiting for a write lock on x. Client 2: INSERT INTO x VALUES(1); The statement requests and blocks waiting for a write lock on x. Client 2 then acquires its lock on x, performs ...
https://dev.mysql.com/doc/refman/8.4/en/mysqlslap.html
The permissible values are read (scan tables), write (insert into tables), key (read primary keys), update (update primary keys), or mixed (half inserts, half scanning selects). mysqlslap --delimiter=";" --number-of-queries=10 --query="use ...
https://dev.mysql.com/doc/refman/8.4/en/innodb-standard-monitor.html
INSERT BUFFER AND ADAPTIVE HASH INDEX This section shows the status of the InnoDB insert buffer (also referred to as the change buffer) and the adaptive hash index. The Lock Monitor is the same as the Standard Monitor except that it includes ...
https://dev.mysql.com/doc/x-devapi-userguide/en/processing-warnings.html
Similar to the execution of single statements committing or rolling back a transaction can also trigger warnings. To be able to process these warnings the replied result object of Session.commit(); or Session.rollback(); needs to be checked. The ...
https://dev.mysql.com/doc/refman/8.4/en/innodb-undo-logs.html
For example, a transaction that performs INSERT, UPDATE, and DELETE operations on regular and temporary tables requires a full assignment of four undo logs. A transaction that performs only INSERT operations on regular tables requires a single undo ... An undo log is a collection of undo log records associated with a single read-write ...
https://dev.mysql.com/doc/refman/8.4/en/mysql-cluster-install-example-data.html
One of these is to modify the table definition before importing it into the Cluster database. Then modify the table definitions as just described and import the file into the SQL node of the cluster like this: $> mysql world < /tmp/world.sql If you ... Note The information in this section applies to NDB Cluster running on both Unix and Windows ...