Search Results
https://dev.mysql.com/doc/connector-j/en/connector-j-usagenotes-spring-config-transactional.html
The downloaded script explicitly creates MyISAM tables, which do not support transactional semantics. What this means is that we can create a Java interface and only use the operations on this interface without any internal knowledge of what the ...
https://dev.mysql.com/doc/refman/8.4/en/charset-applications.html
To create a database such that its tables use a given default character set and collation for data storage, use a CREATE DATABASE statement like this: CREATE DATABASE mydb CHARACTER SET latin1 COLLATE latin1_swedish_ci; Tables created in the ... For ...
https://dev.mysql.com/doc/refman/8.4/en/copying-databases.html
In cases where you need to transfer databases between different architectures, you can use mysqldump to create a file containing SQL statements. Note If GTIDs are in use on the server where you create the dump (gtid_mode=ON), by default, mysqldump ...You can then transfer the file to the other machine and feed it as input to the mysql ...
https://dev.mysql.com/doc/refman/8.4/en/data-size.html
Row Format InnoDB tables are created using the DYNAMIC row format by default. To use a row format other than DYNAMIC, configure innodb_default_row_format, or specify the ROW_FORMAT option explicitly in a CREATE TABLE or ALTER TABLE statement. To ...
https://dev.mysql.com/doc/refman/8.4/en/explain.html
The SHOW CREATE TABLE, SHOW TABLE STATUS, and SHOW INDEX statements also provide information about tables. In practice, the DESCRIBE keyword is more often used to obtain information about table structure, whereas EXPLAIN is used to obtain a query ...
https://dev.mysql.com/doc/refman/8.4/en/grant-tables.html
Modifications occur indirectly when you use account-management statements such as CREATE USER, GRANT, and REVOKE to set up accounts and control the privileges available to each one. password_last_changed is updated by the CREATE USER, ALTER USER, ...
https://dev.mysql.com/doc/refman/8.4/en/information-schema-routines-table.html
If the routine has not been modified since its creation, this value is the same as the CREATED value. SQL_MODE The SQL mode in effect when the routine was created or altered, and under which the routine executes. DEFINER The account named in the ...
https://dev.mysql.com/doc/refman/8.4/en/information-schema-views-table.html
This column has most of what you see in the Create Table column that SHOW CREATE VIEW produces. Suppose that the original statement was: CREATE VIEW v AS SELECT s2,s1 FROM t WHERE s1 > 5 ORDER BY s1 WITH CHECK OPTION; Then the view definition looks ...You must have the SHOW VIEW privilege to access this ...
https://dev.mysql.com/doc/refman/8.4/en/keyring-oci-component.html
Prior to using component_keyring_oci, you must create a tenancy if it does not exist. Prior to using component_keyring_oci, you must create a MySQL compartment or subcompartment if it does not exist. Prior to using component_keyring_oci, you must ...
https://dev.mysql.com/doc/refman/8.4/en/merge-table-advantages.html
For example, you can put data from different months into separate tables, compress some of them with myisampack, and then create a MERGE table to use them as one. As a result, MERGE table collections are very fast to create or remap. (You must still ... MERGE tables can help you solve the following problems: Easily manage a set of log ...