All differences between mysql and sqlserver _ MySQL

All the differences between mysql and SQL Server: the official name of mssql is from SQL Server MS. The graphic operation interface is better, and the performance is good. It cannot be exchanged between mssql and oracle. OLEDB connections are supported. asp and mssaql can only be used for windows.
Mysql is mysql. below is readme: free software. Performance is also acceptable. Fast, used for small-scale. command line interface. (graphical operation software can be installed .)
I used to use SQL Server for ASP.
Now I want to use PHP... with mysql. it feels quite good. The operation is simple. the function is powerful ..

Different drivers have different field types

Mysql has complete permission control, comprehensive tcp protocol support, and cross-web access. as long as the structure is well designed, mysql is also a very valuable and database system, but does not support foreign keys, transactions, stored procedures, and triggers are not supported. the full-text search will not be available, except for the window version to give money, other platforms are free of charge, it can be understood as a user controlled access database. the most popular feature is that php + mysql is free and cross-platform. On the contrary, how much does it cost to use asp + mssql?

The paging difference lies in the difference between SQL statements when obtaining the total number of records.
Select count (*) from guestbook; // mssql
Select name from note; // mysql

Mysql is an open-source database, which is relatively small, but functional and fast. it is much better than access.

SQL server and mssql are also the databases of Microsoft. they are very large and powerful.

For program developers, the two most popular backend databases are MySQL and SQL Server. The most basic similarity between the two is data storage and query system. You can use SQL to access the data of these two databases, because they support ANSI-SQL. Also, both database systems support binary keywords and key indexes, which greatly speeds up query. Both of them also support various XML formats. In addition to the obvious differences in software prices, are there any significant differences between the two products? How do you choose between them? Let's take a look at the main differences between the two products, including release fees, performance, and their security.

The fundamental difference is that they follow the basic principles

The basic principle they follow is their main difference: Open vs Conservative. SQL Server's narrow, conservative storage engine is very different from MySQL server's scalable and open storage engine. Although you can use the Sybase engine of the SQL Server, MySQL can provide more options, such as MyISAM, Heap, InnoDB, and Berkeley DB. MySQL does not fully support unfamiliar keywords, so it requires less related databases than the SQL Server. MySQL also lacks some storage program functions. for example, the MyISAM engine supports the exchange function.

Release fee: MySQL is not all free, but cheap

When it comes to release fees, the two products adopt two absolutely different decisions. For SQL servers, the most common way to get a free development fee is to buy Microsoft Office or Visual Studio. However, if you want to develop commercial products, you must purchase SQL Server Standard Edition. Schools or non-profit enterprises may not consider this additional fee.

Performance: advanced MySQL

For pure performance, MySQL is excellent because it contains a default desktop format MyISAM. The MyISAM database is very compatible with the disk without occupying too much CPU and memory. MySQL can run on Windows without conflict. it is better to run on UNIX or UNIX-like systems. You can also use a 64-bit processor to obtain additional performance. Because MySQL uses 64-bit integers in many internal departments. Yahoo! Commercial websites use MySQL as the background database.

When talking about the performance of the software, the stability of the SQL Server is much better than its competitors. However, these features have to be paid. For example, additional complex operations, disk storage, and memory loss must be added. If your hardware and software do not fully support the SQL Server, I suggest you select another database such as DBMS, because this will produce better results.

Security features

MySQL has a binary log used to change data. Because it is binary, this log can quickly copy data from the host to the client. Even if the server crashes, this binary log is still complete and the copied part is not damaged.

On the SQL server, you can also record SQL-related queries, but this requires a high price.

Security

Both products have their own complete security mechanisms. As long as you follow these security mechanisms, the general program will not have any problems. Both use the default IP ports, but sometimes, unfortunately, these IP addresses are also broken into by some hackers. Of course, you can also set these IP ports by yourself.

Restoration: advanced SQL Server

Restoration is also a feature of MySQL, which is mainly manifested in the MyISAM configuration. This method has inherent defects. if you accidentally damage the database, the results may lead to all data loss. However, the SQL Server is very stable. The SQL server can monitor data exchange points at all times and save the database corruption process.

Decide your choice as needed

If you have to tell me which database is better, I may disappoint you. In my opinion, any database that is helpful to your work is a good database. no database is absolutely outstanding, and no database is absolutely bad. What I want to tell you is that you should start from your own needs, that is, what kind of task should you complete? Instead of simply starting from the functions of the software.

If you want to establish a. NET server system that allows you to access data from multiple different platforms and manage databases, you can select an SQL Server. If you want to create a third-party site that can read data from some clients, MySQL will be the best choice.

Both databases can run normally under. NET or J2EE, and RAID can also be used.

I didn't pay attention that day. MySQL didn't recognize it when I used select top x. although it wasn't impossible without top x, I always felt awkward. later I found that it was originally in MySQL, you need to use limit x to LIMIT.
X represents a non-zero positive integer. This may be the so-called "SQL dialect" seen in Hibernate. Different databases may have different SQL languages.

Mysql: it is free and cross-platform, but only databases, tables, and user management are supported. it is suitable for small databases and medium-sized databases.

Mssql: to purchase, it can only be built on the window, including the above features and view, PROCEDURE, TRIGGER, JOB... too much, suitable for small and medium-sized databases, it is barely a bit large