Search Results
https://dev.mysql.com/doc/connector-j/en/connector-j-server-authentication.html
If the truststore file does not already exist, a new one will be created; otherwise the certificate will be added to the existing file. The next step is to configure Java or Connector/J to read the truststore you just created or modified. Setting ...
https://dev.mysql.com/doc/connector-j/en/connector-j-usagenotes-spring-config-connpooling.html
When this is the case, it usually makes sense to create a pool of database connections available for web requests as needed. Although MySQL does not spawn an extra process when a connection is made, there is still a small amount of overhead to ...
https://dev.mysql.com/doc/refman/8.4/en/archive-storage-engine.html
When you create an ARCHIVE table, the storage engine creates files with names that begin with the table name. Attempting to create an index on any other column results in an error. The ARCHIVE engine also supports the AUTO_INCREMENT table option in ... The ARCHIVE storage engine produces special-purpose tables that store large amounts of unindexed data in a very small ...
https://dev.mysql.com/doc/refman/8.4/en/change-replication-filter.html
Multiple replication filtering rules can be created in a single CHANGE REPLICATION FILTER statement by separating the rules with commas, as shown here: CHANGE REPLICATION FILTER REPLICATE_DO_DB = (d1), REPLICATE_IGNORE_DB = (d2); Issuing the ...
https://dev.mysql.com/doc/refman/8.4/en/declare-handler.html
statement handler_action: { CONTINUE | EXIT | UNDO } condition_value: { mysql_error_code | SQLSTATE [VALUE] sqlstate_value | condition_name | SQLWARNING | NOT FOUND | SQLEXCEPTION } The DECLARE ... HANDLER statement specifies a handler that deals ...
https://dev.mysql.com/doc/refman/8.4/en/drop-database.html
The DROP DATABASE statement removes from the given database directory those files and directories that MySQL itself may create during normal operation. Dropping a database does not remove any TEMPORARY tables that were created in that database.
https://dev.mysql.com/doc/refman/8.4/en/events-metadata.html
The session time zone that is current when a CREATE EVENT or ALTER EVENT statement executes is used to interpret times specified in the event definition. Value EVENTS Table SHOW EVENTS Execute at ETZ ETZ Starts ETZ ETZ Ends ETZ ETZ Last executed ETZ ... To obtain metadata about events: Query the EVENTS table of the INFORMATION_SCHEMA ...
https://dev.mysql.com/doc/refman/8.4/en/example-auto-increment.html
To start with an AUTO_INCREMENT value other than 1, set that value with CREATE TABLE or ALTER TABLE, like this: mysql> ALTER TABLE tbl AUTO_INCREMENT = 100; InnoDB Notes For information about AUTO_INCREMENT usage specific to InnoDB, see Section ...
https://dev.mysql.com/doc/refman/8.4/en/example-foreign-keys.html
To demonstrate ON DELETE and ON UPDATE referential actions, drop the child table and recreate it to include ON UPDATE and ON DELETE subclauses with the CASCADE option. MySQL supports foreign keys, which permit cross-referencing related data across ...
https://dev.mysql.com/doc/refman/8.4/en/gis-general-property-functions.html
For example: SET @g1 = ST_SRID(Point(1, 1), 4326); However, that method creates the geometry in SRID 0, then casts it to SRID 4326 (WGS 84). A preferable alternative is to create the geometry with the correct spatial reference system to begin with.