My SQL and SQL Server differences

MySQL differs from SQL Server

Today we understand the difference between the two, collate the online access to information, summarized as follows:

MSSQL = = SQL Server was the product of the time when Sybase and Microsoft worked together.

For program developers, the two most popular background databases currently used are MySQL and SQL Server. The most basic similarity between the two is that the data is stored and belongs to the query system. You can use SQL to access the data for both databases because they all support ansi-sql. Also, both of these database systems support binary keywords and key indexes, which greatly accelerates query speed. At the same time, both provide various formats that support XML.

The basic principles that they follow are their main differences: Open vs Conservative. The narrow, conservative storage engine of SQL Server is different from the extensible, open storage engine absolutely of MySQL server. While you can use the SQL Server Sybase engine, MySQL can provide more options such as MyISAM, Heap, InnoDB, and Berkeley DB. MySQL does not fully support unfamiliar keywords, so it is less relevant than SQL Server database. At the same time, MySQL also lacks the functions of some stored programs, such as the MyISAM engine to support the Exchange function.

Here's a comparison of cost, performance, security, resiliency, and how to choose.

Comparison of distribution costs: MySQL is not all free, but very cheap

For SQL Server, the most common way to get a free development fee is to purchase Microsoft Office or Visual Studio fees. However, if you want to use commercial product development, you must also purchase SQL Server standard Edition. Schools or non-profit enterprises may not consider this additional fee.

Performance comparison: Advanced MySQL

In terms of performance, MySQL is pretty good because it contains a default desktop format, MyISAM. The MyISAM database is very compatible with the disk without consuming too much CPU and memory. MySQL can run on windows without conflict, and it is better to run on UNIX or similar UNIX-like systems. You can also get some additional performance by using a 64-bit processor. Because MySQL often uses 64-bit integer processing in the interior. Yahoo! 's commercial website uses MySQL as a back-end database.

In terms of software performance, the stability of SQL Server is much stronger than its competitors. However, these features also have to pay a price. For example, additional complex operations, disk storage, memory loss, and so on must be added.
If your hardware and software do not fully support SQL Server, I suggest you better choose other databases like DBMS, because you will get better results. Both databases can be in the. NET or Java EE, the same can be exploited by raid.

Security Features

MySQL has a binary log that is used to change the data. Since it is binary, this log can quickly replicate data from the host to the client. Even if the server crashes, the twos log will remain intact and the copied portions will not be corrupted. In SQL Server, you can also log queries about SQL, but this takes a high price.

Security

Both of these products have their own complete security mechanism. As long as you follow these security mechanisms, there is no problem with the general program. Both use the default IP port, but sometimes unfortunately, these IPs are also hacked into by some hackers. Of course, you can also set these IP ports yourself.

Resiliency: Advanced SQL Server

Recoverability is also a feature of MySQL, which is mainly manifested in the MyISAM configuration. This approach has its inherent shortcomings, and if you accidentally damage the database, the results can result in all data loss. However, it is very stable for SQL Server. SQL Server can monitor the data exchange point at all times and can save the process of database corruption.

Choice: Decide your choice as needed

If you want to build a. NET Server system, this system can access data from many different platforms, participate in database management, then you can choose SQL Server.

If you want to build a third-party site that can read data from some clients, MySQL will be the best choice.

The above content comes from

Https://zhidao.baidu.com/question/448228243.html?fr=iks&word=MSSQL%D3%EBMySQL%C7%F8%B1%F0&ie= GBK thanked the author for his

The details of the two support differences are listed below:

1 MySQL supports enum, and set type, SQL Server does not support
2 MySQL does not support nchar,nvarchar,ntext type
3 MySQL increment statement is auto_increment, and MSSQL is identity (a)
4 MS SQL Default the default value for table creation statements is ((0)), while in MySQL it is not allowed with two brackets
5 MySQL needs to specify the storage type for the table
The 6 MS SQL identifier is [],[type] means that he is different from the keyword, but MySQL is ', that is, the key to the left of the key 1
7 MS SQL supports the GETDATE () method to get the current time date, but MySQL can be divided into date type and time type, get the current date is cur_date (), the current full time is now () function
8 MS SQL does not support the replace into statement, but in the latest sql20008, the merge syntax is also supported
9 MySQL support insert INTO table1 set t1 = ', t2 = ', but MS SQL does not support this write
MySQL support insert into TABL1 values (+), (max), (max), (+), (max), (max)
Each MS SQL does not support the limit statement, it is very regrettable, can only use top instead of LIMT 0,n,row_number () over () function instead of limit n,m
MySQL when you create a table, you specify a storage engine type for each table, and MS SQL supports only one storage engine
MySQL does not support a datetime type with the default value of the current time (MSSQL is easy to do), in MySQL is the timestamp type
MS SQL inside check to see if this table is deleted again, you need this:
if exists (SELECT * from dbo.sysobjects WHERE id = object_id (N ' uc_newpm ') and OBJECTPROPERTY (Id,n ' isusertable ') =1) but In MySQL only DROP TABLE IF EXISTS cdb_forums is required;
MySQL supports unsigned integers, so you can store up to a maximum number of times more than MS SQL that does not support unsigned type
MySQL does not support the use of a very convenient varchar (max) type in MS SQL, which can be used for both general data storage and BLOB data storage in MS SQL.
MySQL creating a nonclustered index only needs to be specified as key when creating the table, for example: Key Displayorder (Fid,displayorder) must be in MS SQL:
Create unique nonclustered Indexindex_uc_protectedmembers_username_appid ondbo.uc_protectedmembers (username ASC, AppID ASC)
MySQL text field type does not allow default values
The total field length for a table of 19MySQL does not exceed 65XXX.
201 A very superficial difference is that MySQL installation is particularly simple, and file size is 110M (non-installed version), compared to the giant of Microsoft, the installation progress is simply ....
21MySQL management Tools There are a few better, Mysql_front, and the official that suite, but none of the ease of use of ssms, which is a big drawback of MySQL.
22MySQL stored procedures only appear in the latest version, and stability and performance may not be as good as Ms SQL.
23 The same load pressure, MySQL to consume less CPU and memory, MS SQL is really very resource-intensive.
PHP connects MySQL and MS SQL in the same way, just to replace the function's MySQL with MS SQL.
MySQL supports the date,time,year type, and MSSQL supports date and time until 2008.

The two detailed support for the distinction enumerated from https://zhidao.baidu.com/question/250454051.html?loc_ans=665059610 to the author expressed thanks

My SQL and SQL Server differences