MySQL commands: Difference between revisions

Jump to navigation Jump to search
340 bytes removed ,  20 March 2025
Line 119: Line 119:


Transfer date from MS SQL server to MySQL or MariaDB server<ref>[https://mariadb.com/kb/en/library/monyog-sqlyog/ MONyog & SQLyog - MariaDB Knowledge Base]</ref>:  
Transfer date from MS SQL server to MySQL or MariaDB server<ref>[https://mariadb.com/kb/en/library/monyog-sqlyog/ MONyog & SQLyog - MariaDB Knowledge Base]</ref>:  
* To export MySQL data compatible with Microsoft SQL Server: {{kbd | key=<nowiki>mysqldump --compatible=mssql [database_name]</nowiki>}}<ref>[https://stackoverflow.com/questions/60139129/how-to-convert-mysql-dump-to-sql-server-format How to convert MySQL dump to SQL Server format - Stack Overflow]</ref>
* See on [[Troubleshooting_of_MySQL_errors#Transfer_Data_from_MySQL_to_MSSQL | Transfer Data from MySQL to MSSQL]]
* ''$'' [https://www.webyog.com/product/sqlyog SQLyog] for {{Win}}. Use a query to specify the data to transfer from MS SQL server into MySQL server.


=== Show the MySQL process list & kill the process ===
=== Show the MySQL process list & kill the process ===

Navigation menu