Search Results
https://dev.mysql.com/doc/refman/8.4/en/update.html
If you use a multiple-table UPDATE statement involving InnoDB tables for which there are foreign key constraints, the MySQL optimizer might process tables in an order that differs from that of their parent/child relationship. UPDATE is a DML ...
https://dev.mysql.com/doc/workbench/en/wb-migration-database-concepts.html
The following table shows a comparison between each DBMS product supported by the Migration Wizard and MySQL. Table 10.1 Conceptual equivalents between supported DBMS products and MySQL Concept MS SQL Server Sybase ASE PostgreSQL MySQL Note ...
https://dev.mysql.com/doc/workbench/en/wb-mysql-connections-secure-auth.html
Options Depend on your secure_auth Option Upgrading a password does have constraints. MySQL 4.1 extended password hashes from 16 to 41 bytes. However, upgrading MySQL does not automatically update the old password passwords, so existing passwords ...
https://dev.mysql.com/doc/workbench/en/wb-reverse-engineer-create-script.html
Tables, views, routines, routine groups, indexes, keys, and constraints can be imported from an SQL script file. To reverse-engineer a database using a create script, do one of the following: On the home screen, select the model view from the ...
https://dev.mysql.com/doc/workbench/en/workbench-faq.html
What do the column flag acronyms (PK, NN, UQ, BIN, UN, ZF, AI, G) in the MySQL Workbench Table Editor mean? Checking these boxes alters the table column by assigning the checked constraints to the designated columns. FAQ Categories Basic Usage ...
https://dev.mysql.com/doc/connectors/en/connector-j-connp-props-statements.html
Setting this property to "true" relaxes this constraint, and can be more memory efficient for some applications. This results in better performance when dealing with time zone conversions in Date and Time data types, however it won't be aware of ...
https://dev.mysql.com/doc/connectors/en/connector-net-programming-authentication-user-plugin.html
/// </summary> protected virtual void CheckConstraints() /// <summary> /// This method, called when the authentication failed, provides a chance to plugins to manage the error /// the way they consider decide (either showing a message, logging it, ... Advanced users with special security requirements can create their own authentication plugins for MySQL Connector/NET ...
https://dev.mysql.com/doc/connectors/en/connector-net-ref-efcore.html
MySQLDropUniqueConstraintAndRecreateForeignKeysOperation A migration operation for dropping a unique constraint and recreating foreign keys. Namespaces in this section: MySql.EntityFrameworkCore.DataAnnotations Namespace ...
https://dev.mysql.com/doc/connectors/en/connector-odbc-reference-errorcodes.html
The following tables lists the error codes returned by Connector/ODBC apart from the server errors.
https://dev.mysql.com/doc/connectors/en/connector-python-api-errors-integrityerror.html
For example, a duplicate key was inserted or a foreign key constraint would fail. This exception is raised when the relational integrity of the data is affected. The following example shows a duplicate key error raised as IntegrityError: ...