Search Results
https://dev.mysql.com/doc/refman/8.4/en/mysql-cluster-limitations-syntax.html
Some SQL statements relating to certain MySQL features produce errors when used with NDB tables, as described in the following list: Temporary tables. Like other MySQL storage engines, the NDB storage engine can handle a maximum of one ...Trying ...
https://dev.mysql.com/doc/workbench/en/wb-migration-database-mssql-typemapping.html
The following table shows the mapping between Microsoft SQL Server (source) data types and MySQL data types. Table 10.2 Type mapping Source Type MySQL Type Comment INT INT TINYINT TINYINT UNSIGNED flag set in MySQL. MySQL Server 5.6 and higher can ...SMALLINT SMALLINT BIGINT BIGINT BIT TINYINT(1) FLOAT FLOAT Precision value is used for storage size in ...
https://dev.mysql.com/doc/workbench/en/wb-migration-database-mssql.html
The MySQL Workbench Migration Wizard is tested with Microsoft SQL Server 2016.
https://dev.mysql.com/doc/connectors/en/connector-python-api-mysqlconnection-sql-mode.html
This property is used to retrieve and set the SQL Modes for the current connection. The value should be a list of different modes separated by comma (","), or a sequence of modes, preferably using the constants.SQLMode class. >>> cnx.sql_mode = ...
https://dev.mysql.com/doc/connector-python/en/connector-python-api-mysqlconnection-sql-mode.html
This property is used to retrieve and set the SQL Modes for the current connection. The value should be a list of different modes separated by comma (","), or a sequence of modes, preferably using the constants.SQLMode class. >>> cnx.sql_mode = ...
https://dev.mysql.com/doc/internals/en/guided-tour-chunk.html
Now, having finished with our bird's eye view of the source code from the air, let's take the perspective of the worms on the ground (which is another name for MySQL's developer staff -- turn on laugh track here). if (updated && (error <= 0 || ...
https://dev.mysql.com/doc/internals/en/memory-allocation-mysql-server.html
The basic logic to use: All things that are used only for the duration of a query are allocated in THD::mem_root through sql_alloc() or thd->alloc() except: Things that may grow, like string buffers of type String. Things in libraries that are ...
https://dev.mysql.com/doc/refman/8.4/en/charset-collate.html
With the COLLATE clause, you can override whatever the default collation is for a comparison.
https://dev.mysql.com/doc/refman/8.4/en/mysql-tzinfo-to-sql.html
The mysql_tzinfo_to_sql program loads the time zone tables in the mysql database. If your system does not have a zoneinfo database, you can use the downloadable package described in Section 7.1.15, “MySQL Server Time Zone Support”. It is used ...
https://dev.mysql.com/doc/refman/8.4/en/replication-statements-replica.html
Section 15.4.1, “SQL Statements for Controlling Source Servers”, discusses statements for managing source servers. In addition to the statements described here, SHOW REPLICA STATUS and SHOW RELAYLOG EVENTS are also used with replicas. For ...