Search Results
https://dev.mysql.com/doc/workbench/en/wb-using-table-tool.html
Make sure that you associate the new table with a database. The Default Engine and Default Collation values refer to the database defaults. Tables can also be added to an EER Diagram using the table tool on the vertical toolbar. Make sure that the ...
https://dev.mysql.com/doc/workbench/en/wb-what-is-new-60.html
This section summarizes many of the new features added to MySQL Workbench 6.0, in relation to the MySQL Workbench 5.2 release. The following figure contains three screenshots of the Schema window in the SQL Editor. The first is from MySQL Workbench ...
https://dev.mysql.com/doc/connectors/en/apis-php-introduction.html
It is available for most operating systems and Web servers, and can access most common databases, including MySQL. PDO_MySQL: Not its own API, but instead it's a MySQL driver for the PHP database abstraction layer PDO (PHP Data Objects). PHP is a ...
https://dev.mysql.com/doc/connectors/en/connector-j-logging-slf4j.html
Besides its default logger com.mysql.cj.log.StandardLogger, which logs to stderr, Connector/J supports the SLF4J logging facade, allowing end users of applications using Connector/J to plug in logging frameworks of their own choices at deployment ...
https://dev.mysql.com/doc/connectors/en/connector-j-reference-implementation-notes.html
The BLOB implementation does not allow in-place modification (they are copies, as reported by the DatabaseMetaData.locatorsUpdateCopies() method). Because of this, use the corresponding PreparedStatement.setBlob() or ResultSet.updateBlob() (in the ... MySQL Connector/J, as a rigorous implementation of the JDBC API, passes all of the tests in the publicly available version of Oracle's JDBC compliance test ...
https://dev.mysql.com/doc/connectors/en/connector-j-source-replica-replication-connection.html
This section describe a number of features of Connector/J's support for replication-aware deployments. Such Connection objects report they are read-only, and isSourceConnection() returns false for them. The Connection tests for available source ...
https://dev.mysql.com/doc/connectors/en/connector-j-time-instants.html
A time instant is said to be preserved when it always refers to the same point in time when its value is being stored to or retrieved from a database, no matter what time zones the database server and the clients are operating in. Background A time ...
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
Notice that FIDO authentication requires some sort of human interactions, so this is not a solution to apply for a typical three-tier architecture, where there is usually a single database user configured in the application server and connections to ... Web Authentication (WebAuthn) enables user authentication for MySQL Server using devices such as smart cards, security keys, and biometric ...
https://dev.mysql.com/doc/connectors/en/connector-net-entityframework-core.html
Configuration with MySQL To use Entity Framework Core with a MySQL database, do the following: Install the NuGet package. optionsBuilder.UseMySQL("server=localhost;database=library;user=user;password=password"); } Limitations The Connector/NET ...
https://dev.mysql.com/doc/connectors/en/connector-net-programming-datetime-restricting.html
The DateTime class will only allow valid dates, ensuring that the values in your database are also valid. The disadvantage of this is that it is not useful in a mixed environment where .NET and non .NET code are used to manipulate the database, as ... The best solution to the date problem is to restrict users from entering invalid ...