Search Results
https://dev.mysql.com/doc/refman/8.4/en/mysql-batch-commands.html
The mysql client typically is used interactively, like this: mysql db_name However, it is also possible to put your SQL statements in a file and then tell mysql to read its input from that file. You can also invoke mysql with the --verbose option, ...To do so, create a text file text_file that contains the statements you wish to ...
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/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 ...
https://dev.mysql.com/doc/refman/8.4/en/replication-statements-source.html
Section 15.4.2, “SQL Statements for Controlling Replica Servers”, discusses statements for managing replica servers. In addition to the statements described here, the following SHOW statements are used with source servers in replication. SHOW ...
https://dev.mysql.com/doc/refman/8.4/en/sql-compound-statements.html
These objects are defined in terms of SQL code that is stored on the server for later invocation (see Chapter 27, Stored Objects). END compound statement and other statements that can be used in the body of stored programs: Stored procedures and ...
https://dev.mysql.com/doc/refman/8.4/en/sql-replication-statements.html
Replication can be controlled through the SQL interface using the statements described in this section. Statements are split into a group which controls source servers, a group which controls replica servers, and a group which can be applied to any ...