Search Results
https://dev.mysql.com/doc/heatwave-aws/en/running-autopilot-index-advisor-using-heatwave-console.html
Recommendation: It is either DROP or CREATE Schema Name Table Name Indexed Columns Reason: Reason for making the recommendation. Running Autopilot Index Advisor 11.1 Running Autopilot Index Advisor To run Autopilot Index Advisor, the user must ...
https://dev.mysql.com/doc/connector-j/en/connector-j-exceptions-changes.html
Applications that used to catch the removed exceptions should now catch the corresponding exceptions listed in Table 4.3 below. Note Some of these Connector/J 5.1 exceptions are duplicated in the com.mysql.jdbc.exception.jdbc4 package; that is ...
https://dev.mysql.com/doc/connector-j/en/connector-j-support-bug-report.html
If you have a repeatable bug report, please report it to the bugs database at http://bugs.mysql.com/. If at all possible, create a repeatable, standalone testcase that doesn't involve any third-party classes. In the setUp() method, create code that ... The normal place to report bugs is http://bugs.mysql.com/, which is the address for our bugs ...
https://dev.mysql.com/doc/refman/8.4/en/alter-logfile-group.html
For example, you cannot have a tablespace and an undo log file with the same name, or an undo log file and a data file with the same name. You can verify that the undo files were created and obtain information about them by querying the Information ... ALTER LOGFILE GROUP logfile_group ADD UNDOFILE 'file_name' [INITIAL_SIZE [=] size] [WAIT] ENGINE [=] engine_name This statement adds an UNDO file named 'file_name' to an existing log file group ...
https://dev.mysql.com/doc/refman/8.4/en/assigning-passwords.html
MySQL stores credentials in the user table in the mysql system database. This enables MySQL to obfuscate passwords prior to storing them in the mysql.user system table. Required credentials for clients that connect to the MySQL server can include a ...
https://dev.mysql.com/doc/refman/8.4/en/binary-varbinary.html
Instead, it causes the binary (_bin) collation for the column character set (or the table default character set if no column character set is specified) to be used, and the column itself stores nonbinary character strings rather than binary byte ...
https://dev.mysql.com/doc/refman/8.4/en/calculating-days.html
CREATE TABLE t1 (year YEAR, month INT UNSIGNED, day INT UNSIGNED); INSERT INTO t1 VALUES(2000,1,1),(2000,1,20),(2000,1,30),(2000,2,2), (2000,2,23),(2000,2,23); The example table contains year-month-day values representing visits by users to the page. The following example shows how you can use the bit group functions to calculate the number of days per month a user has visited a Web ...
https://dev.mysql.com/doc/refman/8.4/en/charset-collation-implementations.html
MySQL implements several types of collations: Simple collations for 8-bit character sets This kind of collation is implemented using an array of 256 weights that defines a one-to-one mapping from character codes to weights. It is a case-insensitive ...
https://dev.mysql.com/doc/refman/8.4/en/charset-collation-names.html
The following table shows the suffixes used to indicate these characteristics. Table 12.1 Collation Suffix Meanings Suffix Meaning _ai Accent-insensitive _as Accent-sensitive _ci Case-insensitive _cs Case-sensitive _ks Kana-sensitive _bin Binary For ... MySQL collation names follow these conventions: A collation name starts with the name of the character set with which it is associated, generally followed by one or more suffixes indicating other collation ...
https://dev.mysql.com/doc/refman/8.4/en/clone-plugin-local.html
Note A local cloning operation does not support cloning of user-created tables or tablespaces that reside outside of the data directory. Attempting to clone such tables or tablespaces causes the following error: ERROR 1086 (HY000): File ...The ...