Search Results
https://dev.mysql.com/doc/workbench/en/wb-getting-started-tutorial-creating-a-model.html
Change moviesid to movie_id and keep the Datatype as INT, and also select the PK (PRIMARY KEY), NN (NOT NULL), and AI (AUTO_INCREMENT) check boxes. This tutorial describes how to create a new database model and how to forward-engineer a model to a ...
https://dev.mysql.com/doc/workbench/en/wb-preferences-modeling.html
Length of ENUMs and SETs to Display: [20] Show Column Flags Shows column flags, such as NOT NULL and UNSIGNED, along their names in table figures. This section provides configuration options that affect the modeling functionality in MySQL Workbench ...
https://dev.mysql.com/doc/workbench/en/wb-table-editor-foreign-keys-tab.html
The options are: RESTRICT CASCADE SET NULL NO ACTION To drop a foreign key, right-click the row you wish to delete, then select the Delete Selected FKs menu item. The Foreign Keys subtab is organized in much the same fashion as the Indexes subtab ...
https://dev.mysql.com/doc/workbench/en/wbcopytables.html
The table must have a numeric UNIQUE NOT NULL or PRIMARY KEY that is used to create a WHERE expression for the range. wbcopytables is a command-line utility included in MySQL Workbench that enables you to copy table data from a supported source ...
https://dev.mysql.com/doc/connectors/en/connector-j-connp-props-metadata.html
getProceduresReturnsFunctions Pre-JDBC4 'DatabaseMetaData' API has only the 'getProcedures()' and 'getProcedureColumns()' methods, so they return metadata info for both stored procedures and functions. JDBC4 was extended with the 'getFunctions()' ...
https://dev.mysql.com/doc/connectors/en/connector-j-connp-props-session.html
If not set or set to "null", the server will send data in its original character set and the driver will decode it according to the result metadata. sessionVariables A comma or semicolon separated list of "name=value" pairs to be sent as "SET ...
https://dev.mysql.com/doc/connectors/en/connector-j-session-state-tracker.html
Connector/J can receive information on client session state changes tracked by the server if the tracking has been enabled on the server. The reception of the information is enabled by setting the Connector/J connection property trackSessionState ...
https://dev.mysql.com/doc/connectors/en/connector-j-usagenotes-connect-drivermanager.html
import java.sql.Connection; import java.sql.DriverManager; import java.sql.SQLException; Connection conn = null; ... When you are using JDBC outside of an application server, the DriverManager class manages the establishment of connections. Specify ...
Connectors and APIs Manual :: 3.5.12.4 Connecting Using Web Authentication (WebAuthn) Authentication
https://dev.mysql.com/doc/connectors/en/connector-j-WebAuthn-authentication.html
Web Authentication (WebAuthn) enables user authentication for MySQL Server using devices such as smart cards, security keys, and biometric readers. WebAuthn enables passwordless authentication, and can be used for MySQL accounts that use ...
https://dev.mysql.com/doc/connectors/en/connector-net-programming-bulk-loader.html
CREATE TABLE Career ( Name VARCHAR(100) NOT NULL, Age INTEGER, Profession VARCHAR(200) ); A simple tab-delimited data file is also created (it could use any other field delimiter such as comma). MySQL Connector/NET features a bulk loader class that ...