Difference between mysql and mssql

Mssql is the Microsoft SQL Server that runs on windows and platforms.

Mysql is an open-source database Server that runs on windows and unix \ linux platforms. Its Standard Edition is free of charge. You can visit www.mysql.com

Asp \ php is just an explanatory language. It is not necessarily because mssql cannot use php or mysql must use php, but asp-mssql and php-mysql are a common combination.

MsSql is Microsoft's ms SQL SERVER.

MySQL is another company.

Comparison:
1. MsSQL is large and MySQL is small.

2. MsSQL can only be used in Windows, and MySQL is multi-platform.

3. MsSQL requires money. MySQL is free of charge (it is charged for windows, but rarely ).

MySQL is designed for WEB databases and features fast response.

Of course, MSSQL cannot match in this respect.

As for stability, it's hard to say anything about Microsoft.

I have also tried MYSQL under WIN32 and used DELPHI to connect. Several connection methods are quite fast. Of course, there is no ADO connection.

For larger enterprise applications, MYSQL may be insufficient.

MSSQL is not as good as SYBASE and Oracle.

MySql is short and concise. It is a file-type database like access, but it is hundreds of times better than access. It is a real multi-user and multi-task database system. It is transplanted from Linux and has high security, it can be used as a large database, but most operations are performed under dos. Although there is a graphical interface developed by a third party, it is not easy to use.

MsSql is a micro-engine product that is always stupid, powerful, and easy to use on a GUI, just like a dumb camera, but it is too big, MSSQL, which is developed by Microsoft, is a database management software based on the NT system. That is to say, MSSQL can only run in WINDOWS.

MYSQL is a cross-platform database management software that runs on LINUX, NT, UNIX, and other systems and can be effectively integrated with PHP.

MSSQL requires a lot of system resources, but it is powerful and supports command and graphical management,

MYSQL has multiple versions and supports command and graphical management. It is suitable for general databases and occupies less system resources, which is faster and open-source.

Mysql is developed based on the php language for the linux platform.

Mssql is mainly developed for the win platform in combination with asp.