Search Results
https://dev.mysql.com/doc/connector-j/en/connector-j-usagenotes-spring-config.html
The Spring Framework is a Java-based application framework designed for assisting in application design by providing a way to configure components. The technique used by Spring is a well known design pattern called Dependency Injection (see ...
https://dev.mysql.com/doc/connector-j/en/connector-j-usagenotes-statements.html
Statement objects allow you to execute basic SQL queries and retrieve the results through the ResultSet class, which is described later. To create a Statement instance, you call the createStatement() method on the Connection object you have ...
https://dev.mysql.com/doc/connector-j/en/connector-j-usagenotes-tomcat.html
The following instructions are based on the instructions for Tomcat-5.x, available at http://tomcat.apache.org/tomcat-5.5-doc/jndi-datasource-examples-howto.html which is current at the time this document was written. First, install the .jar file ...
https://dev.mysql.com/doc/refman/8.4/en/activestate-perl.html
If you cannot get the procedure to work, you should install the ODBC driver instead and connect to the MySQL server through ODBC: use DBI; $dbh= DBI->connect("DBI:ODBC:$dsn",$user,$password) || die "Got error $DBI::errstr when connecting to $dsn\n"; ... On Windows, you should do the following to install the MySQL DBD module with ActiveState Perl: Get ActiveState Perl from http://www.activestate.com/Products/ActivePerl/ and install ...
https://dev.mysql.com/doc/refman/8.4/en/alter-resource-group.html
ALTER RESOURCE GROUP group_name [VCPU [=] vcpu_spec [, vcpu_spec] ...] [THREAD_PRIORITY [=] N] [ENABLE|DISABLE [FORCE]] vcpu_spec: {N | M - N} ALTER RESOURCE GROUP is used for resource group management (see Section 7.1.16, “Resource Groups”).
https://dev.mysql.com/doc/refman/8.4/en/alter-table-examples.html
For NDB tables, it is also possible to change the storage type used for a table or column. row *************************** Table: t1 Create Table: CREATE TABLE `t2` ( `c1` int(11) DEFAULT NULL ) /*!50100 TABLESPACE ts_1 STORAGE DISK */ ...
https://dev.mysql.com/doc/refman/8.4/en/alter-table-problems.html
If you get a duplicate-key error when using ALTER TABLE to change the character set or collation of a character column, the cause is either that the new column collation maps two keys to the same value or that the table is corrupted. In the latter ...
https://dev.mysql.com/doc/refman/8.4/en/alter-tablespace.html
ALTER TABLESPACE ts1 ENGINE_ATTRIBUTE='{"key":"value"}'; ENGINE_ATTRIBUTE values can be repeated without error. It can be used to add a new data file to, or to drop a data file from an NDB tablespace. It can also be used to rename an NDB Cluster ...
https://dev.mysql.com/doc/refman/8.4/en/analyze-table.html
Column Value Table The table name Op analyze or histogram Msg_type status, error, info, note, or warning Msg_text An informational message Key Distribution Analysis ANALYZE TABLE without either HISTOGRAM clause performs a key distribution analysis ...ANALYZE [NO_WRITE_TO_BINLOG | LOCAL] TABLE tbl_name UPDATE HISTOGRAM ON col_name [, col_name] ...
https://dev.mysql.com/doc/refman/8.4/en/ansi-diff-foreign-keys.html
For example, if you define a RESTRICT type constraint, and there is a child row with several parent rows, InnoDB does not permit the deletion of any of the parent rows. This means that you cannot use self-referential ON UPDATE CASCADE or ON UPDATE ...