Search Results
https://dev.mysql.com/doc/connector-j/en/connector-j-usagenotes-connect-drivermanager.html
If testing this code, first read the installation section at Chapter 4, Connector/J Installation, to make sure you have connector installed correctly and the CLASSPATH set up. When you are using JDBC outside of an application server, the ...
https://dev.mysql.com/doc/connector-j/en/connector-j-usagenotes-j2ee-concepts-connection-pooling.html
How Connection Pooling Works Most applications only need a thread to have access to a JDBC connection when they are actively processing a transaction, which often takes only milliseconds to complete. Using Connection Pooling with Connector/J The ...
https://dev.mysql.com/doc/refman/8.4/en/access-control.html
MySQL handles this by enabling you to distinguish users on different hosts that happen to have the same name: You can grant one set of privileges for connections by joe from office.example.com, and a different set of privileges for connections by ...
https://dev.mysql.com/doc/refman/8.4/en/administrative-connection-interface.html
As mentioned in Connection Volume Management, to allow for the need to perform administrative operations even when max_connections connections are already established on the interfaces used for ordinary connections, the MySQL server permits a ...
https://dev.mysql.com/doc/refman/8.4/en/alter-database.html
An ALTER DATABASE statement blocks until all concurrent transactions that have already accessed an object in the database being altered have committed. If it is not desirable to have the same database read-only state in the clone, the option must be ...alter_option: { [DEFAULT] CHARACTER SET [=] charset_name | [DEFAULT] COLLATE [=] collation_name | [DEFAULT] ENCRYPTION [=] {'Y' | 'N'} | READ ONLY [=] {DEFAULT | 0 | 1} } ALTER DATABASE enables you to change the overall characteristics of a ...
https://dev.mysql.com/doc/refman/8.4/en/batch-mode.html
If you make a mistake, you don't have to retype everything. In the previous sections, you used mysql interactively to enter statements and view the results. If you want the script to continue even if some of the statements in it produce errors, you ...
https://dev.mysql.com/doc/refman/8.4/en/cannot-initialize-character-set.html
You might see an error like this if you have character set problems: MySQL Connection Failed: Can't initialize character set charset_name This error can have any of the following causes: The character set is a multibyte character set and you have ...In this case, you need to recompile the client by running CMake with the -DDEFAULT_CHARSET=charset_name ...
https://dev.mysql.com/doc/refman/8.4/en/case-sensitivity.html
For example, if e and é have the same sort value in a given collation, they compare as equal. For nonbinary strings (CHAR, VARCHAR, TEXT), string searches use the collation of the comparison operands. For binary strings (BINARY, VARBINARY, BLOB), ...
https://dev.mysql.com/doc/refman/8.4/en/cast-functions.html
Some conditions apply to all spatial type casts, and some conditions apply only when the cast result is to have a particular spatial type. Table 14.15 Cast Functions and Operators Name Description Deprecated BINARY Cast a string to a binary string ...
https://dev.mysql.com/doc/refman/8.4/en/charset-conversion.html
A special case occurs if you have old tables from before MySQL 4.1 where a nonbinary column contains values that actually are encoded in a character set different from the server's default character set. For example, an application might have stored ... To convert a binary or nonbinary string column to use a particular character set, use ALTER ...