如何将MSSQL写入MYSQL？ [英] How to write MSSQL to MYSQL?

问题描述

如何在MYSQL中写下面的查询？

从table1删除

输出删除。*到table2

How to write below query in MYSQL?
delete from table1
output deleted.* into table2

推荐答案

没有工具可以将MSSQL转换为MYSQL。

你必须重写它。

No tool is there to convert MSSQL to MYSQL.
You have to rewrite it.

遗憾的是没有相当于MS SQL的输出子句 [ ^ ]。



您将需要查看其他替代品



由于我不确定您希望如何在您的应用程序中处理此问题，我可以建议你看看这个谷歌搜索并选择一个满足你的应用程序需求。



Google search：mysql ou tput条款 [ ^ ]

Sadly there is no equivalent of the MS SQL Output clause[^] in mySQL.

you will need to have a look at other alternatives

As I am not sure on how you want to handle this in your application I can suggest you have a look through this google search and pick one that meets your applications needs.

Google search : mysql output clause[^]

您可以在表格上创建一个触发器然后使用OLD表填充Table2 ...

示例 [ ^ ]和参考 [ ^ ]

You could create a trigger on the table and then use the OLD table to populate Table2...
example[^] and reference[^]

这篇关于如何将MSSQL写入MYSQL？的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！