SQL ServerMySQL查询（T-SQL）教程

Microsoft SQL Server and MySQL, both are quite well-established database engines. In our role as a DBA, at some given time point we require T-SQL straddling between both database engines unites Select, Insert, Update, Delete and some other…

Microsoft SQL Server和MySQL都是非常完善的数据库引擎。 在作为DBA的角色中，在某些给定的时间点，我们需要两个数据库引擎之间的T-SQL跨越，将Select，Insert，Update，Delete和其他一些…

In terms of requirements for correlating with a MySQL database, eventually, we need to get to information from a MySQL database and synchronize it into Microsoft SQL Server. Now, a simple way to pursue that is with the utilization of MySQL connectors. The SQL Server statements or a query to insert, fetch or to do manipulations with the data from MySQL tables which are concerning to SQL Server tables. This means by inserting, fetching or manipulating in the solution we will have enough to import data from a MySQL Server database.

根据与MySQL数据库关联的要求，最终，我们需要从MySQL数据库获取信息并将其同步到Microsoft SQL Server中。 现在，一种简单的实现方法是利用MySQL连接器。 SQL Server语句或查询，用于对与SQL Server表有关MySQL表中的数据进行插入，提取或操作。 这意味着通过在解决方案中插入，获取或操作，我们将有足够的能力从MySQL Server数据库导入数据。

Now before dealing with T-SQL for MySQL inside the SQL Server, the Connection needs to be set up within inter-related Server as an initial step to start with. Additionally, the MySQL ODBC driver needs to be preinstalled on the machine.

现在，在处理SQL Server中用于MySQL的T-SQL之前，首先需要在相互关联的Server中建立连接。 此外，需要在计算机上预安装MySQL ODBC驱动程序。

创建一个MySQL链接服务器 (Create a MySQL Linked Server)

Let’s start with establishing an ODBC data source to the MySQL Server on the machine on which the SQL Server is installed.

让我们从在安装SQL Server的计算机上为MySQL Server建立ODBC数据源开始。

打开ODBC数据源 (Open ODBC Data Sources)

To add new source, click the Add button, select the MySQL ODBC 8.0 ANSI Driver to integrate MySQL connection and click the Finish button.

要添加新源，请单击“ 添加”按钮，选择“ MySQL ODBC 8.0 ANSI驱动程序”以集成MySQL连接，然后单击“ 完成”按钮。

Subsequently, configure the required information in MySQL Connector window to configure MySQL Data Source Name. In this example, we have used the localhost as the MySQL server name. Now, we can verify the connection with tapping on Test button. upon the successful test, the data source would be available to include another MySQL Linked Server in SQL Server illustration.

随后，在“ MySQL连接器”窗口中配置所需的信息以配置MySQL数据源名称 。 在此示例中，我们使用localhost作为MySQL服务器名称。 现在，我们可以点击“ 测试”按钮来验证连接。 测试成功后，数据源将可用于在SQL Server插图中包括另