Search Results
https://dev.mysql.com/doc/workbench/en/wb-data-modeling.html
Model-driven database design is an efficient methodology for creating valid and well-performing databases, while providing the flexibility to respond to evolving data requirements. MySQL Workbench provides extensive capabilities for creating and ...
https://dev.mysql.com/doc/workbench/en/wb-generating-sql.html
MySQL Workbench can be used to generate SQL, most typically as either INSERT statements or SELECT statements. The following common methods are for generating SQL statements in MySQL Workbench. Note All of the MySQL Workbench Export options include ...
https://dev.mysql.com/doc/workbench/en/wb-importing-sql-script.html
Open MySQL Workbench, select the models view from the sidebar in the home screen, click (>) next to Models, and then click Reverse Engineer MySQL Create Script. If the file was successfully imported, the application's status bar reads, Import MySQL ... For this tutorial, use the sakila database script, which you can find by visiting the https://dev.mysql.com/doc/index-other.html ...
https://dev.mysql.com/doc/connectors/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/connectors/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/connector-odbc/en/connector-odbc-examples-programming-net-vb.html
The following sample creates a table my_vb_net and demonstrates the use in VB.
https://dev.mysql.com/doc/internals/en/binlog-event-flag.html
Hex Flag 0x0001 LOG_EVENT_BINLOG_IN_USE_F 0x0002 LOG_EVENT_FORCED_ROTATE_F 0x0004 LOG_EVENT_THREAD_SPECIFIC_F 0x0008 LOG_EVENT_SUPPRESS_USE_F 0x0010 LOG_EVENT_UPDATE_TABLE_MAP_VERSION_F 0x0020 LOG_EVENT_ARTIFICIAL_F 0x0040 LOG_EVENT_RELAY_LOG_F ...
https://dev.mysql.com/doc/internals/en/determining-logging-format.html
The sp_head object stores the Lex that was generated when the statement defining the sub-statement was parsed (that is, when CREATE FUNCTION/CREATE PROCEDURE/CREATE TRIGGER/CREATE VIEW/PREPARE was parsed). For each statement, we must determine the ...
https://dev.mysql.com/doc/internals/en/myisam-introduction.html
MySQL creates files named Table1.MYD ("MySQL Data"), Table1.MYI ("MySQL Index"), and Table1.frm ("Format"). "Filler Bits" = 1 The length of the record header is thus: (1 + number of NULL columns + 7) / 8 bytes After the header, all columns are ...
https://dev.mysql.com/doc/internals/en/optimizer-partition-pruning.html
Suppose that we have a partitioned table with N columns, using partitioning type p_type and the partitioning function p_func, represented like this: CREATE TABLE t (columns) PARTITION BY p_type(p_func(col1, col2,... 7.3.2.1.2.2 Interval Walking Let ...Partitions that did not get into this set (that is, those that were pruned away) will not be accessed at all: this is how query execution is made ...