Search Results
https://dev.mysql.com/doc/connectors/en/connector-j-time-instants.html
The challenge: The timestamps' instant values need to be preserved when they are saved onto or retrieved from the server using Connector/J. connectionTimeZone={LOCAL|SERVER|user-defined-time-zone}: Specifies how the server's session time zone (in ...
https://dev.mysql.com/doc/connector-j/en/connector-j-time-instants.html
The challenge: The timestamps' instant values need to be preserved when they are saved onto or retrieved from the server using Connector/J. connectionTimeZone={LOCAL|SERVER|user-defined-time-zone}: Specifies how the server's session time zone (in ...
https://dev.mysql.com/doc/refman/8.4/en/data-size.html
MySQL has many specialized types that save disk space and memory. For InnoDB tables, the primary key columns are duplicated in each secondary index entry, so a short primary key saves considerable space if you have many secondary indexes. Keep ...
https://dev.mysql.com/doc/workbench/en/wb-mysql-firewall.html
You can modify the plugin controls as follows: Install: Executes queries to install the new MySQL Enterprise Firewall tables and stored procedure needed to switch the state. Firewall Rules and Information The Firewall Rules tab lists the active and ... MySQL Workbench provides a graphical interface to MySQL Enterprise ...
https://dev.mysql.com/doc/workbench/en/wb-forward-engineering-sql-scripts.html
Leave this field blank to view, but not save, the generated output. You can then use the saved script to create a database. Forward engineering enables you to create a script of your database model. You may export a script to alter an existing ...
https://dev.mysql.com/doc/workbench/en/wb-migration-overview-steps.html
Note The Recreate Objects operation is required to save any changes here. This also means that the previously saved schema will be dropped. This example migrates a Microsoft SQL Server database to MySQL and includes an image for each step. From ...
https://dev.mysql.com/doc/workbench/en/wb-migration-wizard-create-target.html
Note The Recreate Objects operation is required to save any changes here. This also means that the previously saved schema will be dropped. The generated objects are listed here, along with the error messages if any exist. The migration code may ...
https://dev.mysql.com/doc/refman/8.4/en/replication-gtids-lifecycle.html
You might need to do this after carrying out test queries to verify a replication setup on new GTID-enabled servers, or when you want to join a new server to a replication group but it contains some unwanted local transactions that are not accepted ... The life cycle of a GTID consists of the following steps: A transaction is executed and committed on the ...
https://dev.mysql.com/doc/workbench/en/wb-reverse-engineer-create-script.html
Figure 9.48 Reverse Engineer SQL Script: Results Before exiting MySQL Workbench, save the schema. Click File and then Save from the menu to save the reverse-engineered database as a MySQL Workbench file with the .mwb extension. To reverse-engineer ...
https://dev.mysql.com/doc/workbench/en/wb-reverse-engineer-live.html
Click File and then Save from the menu to save the reverse-engineered database as a MySQL Workbench file with the .mwb extension. To reverse-engineer a live database, click Database and then Reverse Engineer from the menu. The figure that follows ...