如何在一个Sql文件中合并所有sql文件？ [英] How merge All sql files in one Sql file?

问题描述

如何在一个Sql文件中合并所有sql文件？

How merge All sql files in one Sql file?

推荐答案

我找到了一种更快捷的方法，可以通过比赛菜单打开右侧目录中的命令提示符。



在文件资源管理器中，转到要合并文件的目录。

右键单击文件夹时按住SHIFT键然后单击打开命令提示符

在命令提示符下输入：copy * .sql merged.sql按Enter键将所有数据复制到merged.sql

关闭命令提示符窗口。

在您喜欢的sql编辑器中打开merged.sql并转到内容底部以检查Windows是否添加了不需要的字符，如果需要则将其删除。

所有* .sql都合并到merged.sql中，您现在可以在phpMyAdmin中点击几下来导入它们。





如何在一个Sql文件中合并所有sql文件e？ [ ^ ]

I have found a faster way to open the Command Prompt in the right directory with the contest menu.

In your files explorer go to the directory where are your files to merge.
Hold the SHIFT key while you right-click the folder and click on "Open Command Prompt Here"
In the Command Prompt enter : copy *.sql merged.sql hit Enter to copy all data into merged.sql
Close the Command Prompt window.
Open merged.sql in your favorite sql editor and go to the bottom of the content to check if Windows has added an unwanted character, remove it if needed.
All your *.sql are merged into merged.sql you can now import them with few clicks in phpMyAdmin.


How merge All sql files in one Sql file?[^]

http://website2backup.com/merge-mysql-sql-files -with-windows.html [ ^ ]

http://www.sqlservercentral.com/论坛/ Topic458542-148-1.aspx [ ^ ]

http://www.ownedcore.com/forums/world-of-warcraft/world-of -warcraft仿真器的服务器/哇鸸鹋-克uides-tutorials / 140347-guide-pictures-combined-bunch-of-sql-files-into-one.html [ ^ ]

http://website2backup.com/merge-mysql-sql-files-with-windows.html[^]
http://www.sqlservercentral.com/Forums/Topic458542-148-1.aspx[^]
http://www.ownedcore.com/forums/world-of-warcraft/world-of-warcraft-emulator-servers/wow-emu-guides-tutorials/140347-guide-pictures-combining-bunch-of-sql-files-into-one.html[^]

这篇关于如何在一个Sql文件中合并所有sql文件？的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！