Search Results
https://dev.mysql.com/doc/refman/8.4/en/charset-binary-set.html
The binary character set is the character set for binary strings, which are sequences of bytes. Comparison and sorting are based on numeric byte values, rather than on numeric character code values (which for multibyte characters differ from ...
https://dev.mysql.com/doc/refman/8.4/en/charset-national.html
These statements are equivalent: SELECT N'some text'; SELECT n'some text'; SELECT _utf8'some text'; MySQL 8.4 interprets the national character set as utf8mb3, which is now deprecated. Standard SQL defines NCHAR or NATIONAL CHAR as a way to ...
https://dev.mysql.com/doc/refman/8.4/en/checking-gpg-signature-windows.html
Figure 2.1 Kleopatra: Lookup on Server Wizard: Finding a Certificate Select the "MySQL Release Engineering" certificate. Select our certificate, then from the main menu select Certificates, Change Certification Power, and click Grant Power. The ...
https://dev.mysql.com/doc/refman/8.4/en/clone-plugin-replication.html
Add replication channels for the instance as shown in the following abbreviated example, using the binary log position that was transferred to the recipient during the cloning operation: SELECT BINLOG_FILE, BINLOG_POSITION FROM ...In addition to ...
https://dev.mysql.com/doc/refman/8.4/en/commit.html
To disable autocommit mode implicitly for a single series of statements, use the START TRANSACTION statement: START TRANSACTION; SELECT @A:=SUM(salary) FROM table1 WHERE type=1; UPDATE table2 SET summary=@A WHERE type=1; COMMIT; With START ...SET ...
https://dev.mysql.com/doc/refman/8.4/en/connecting.html
Because there is no such argument, mysql selects no default database. Only connection options that are relevant to the selected transport protocol are used or checked. This section describes use of command-line options to specify how to establish ...
https://dev.mysql.com/doc/refman/8.4/en/converting-tables-to-innodb.html
Remember that even a SELECT statement opens a transaction, so after running some report or debugging queries in an interactive mysql session, either issue a COMMIT or close the mysql session. Transferring Data To transfer a large volume of data into ... If you have MyISAM tables that you want to convert to InnoDB for better reliability and scalability, review the following guidelines and tips before ...
https://dev.mysql.com/doc/refman/8.4/en/create-table-foreign-keys.html
Example queries are show here: mysql> SELECT * FROM INFORMATION_SCHEMA.INNODB_FOREIGN \G *************************** 1. row *************************** ID: test/child_ibfk_1 FOR_NAME: test/child REF_NAME: test/parent N_COLS: 1 TYPE: 1 mysql> SELECT ... MySQL supports foreign keys, which permit cross-referencing related data across tables, and foreign key constraints, which help keep the related data ...
https://dev.mysql.com/doc/refman/8.4/en/create-user.html
This query displays the row in this table inserted by the statement just shown for creating the user jim@localhost: mysql> SELECT * FROM INFORMATION_SCHEMA.USER_ATTRIBUTES -> WHERE USER = 'jim' AND HOST = 'localhost'\G *************************** 1.
https://dev.mysql.com/doc/refman/8.4/en/declare-cursor.html
DECLARE cursor_name CURSOR FOR select_statement This statement declares a cursor and associates it with a SELECT statement that retrieves the rows to be traversed by the cursor. The number of columns retrieved by the SELECT statement must match the ...Cursor declarations must appear before handler declarations and after variable and condition ...