What is the difference between mysql and mssql

Difference: 1. MySQL supports enum and set types, but MSSQL does not support them; 2. MSSQL does not support limit, but MySQL supports it; 3. MySQL supports unsigned integers, but MSSQL does not support them; 4. The same Under load pressure, mysql consumes fewer resources, while mssql consumes more resources.

The operating environment of this tutorial: windows7 system, mysql8 version, Dell G3 computer.

What is mssql

ms SQL refers to Microsoft's SQLServer database server. It is a database platform that provides database access from server to terminal. The complete solution, of which the database server part is a database management system, is used to establish, use and maintain databases.

SQL Server was not a product developed by Microsoft itself at the beginning, but was produced in cooperation with Sybase when it was trying to compete with IBM. Its earliest developer was Sybase, and Microsoft also cooperated with Sybase. In the development of SQL Server 4.2 version, Microsoft also ported SQL Server 4.2 to Windows NT (version 3.1 at the time). After terminating the partnership with Sybase, it independently developed SQL Server version 6.0. All subsequent SQL Servers will be developed by Microsoft itself. R&D.

The difference between mysql and mssql

MySQL can be said to be a simplified version of MSSQL.

The concept is the same, but the implementation of MySQL has lower requirements than MSSQL. MySQL is a free, open source SQL database, so free MYSQL is very popular, php mysql, MySQL database is specially used for PHP websites, and is generally used on PHP web pages. It and PHP can be said to be golden partners ( They are all open source and free).

For websites that do not have particularly large traffic, MYSQL is particularly competent and efficient. MYSQL is suitable for small and medium-sized websites. mysql is an open source database server that can run on windows, unix, and linux platforms. Its standard version is free. ASP.NET and MYSQL are not suitable for use together. PHP MySQL Apache is very popular for domestic website building.

MS SQL is a commercial database system launched by Microsoft. Its full name is Microsoft SQL Sever. , is a product of Microsoft, and requires payment, so it is more expensive. Currently, large websites generally use Oracle or MSSQL, JSP, PHP or ASP. Generally used by enterprise-level business websites.

MS SQL Server and ASP are both Microsoft products and have the best compatibility with each other, so it is best to use MS SQL Server for ASP websites, so match them!

Summary of differences

1 mysql supports enum and set types, but sql server does not support them

2 mysql nchar, nvarchar, ntext types are not supported

3 The increment statement of mysql is AUTO_INCREMENT, while mssql is identity(1,1)

4 The default value of msms for table creation statements is ( (0)), and two parentheses are not allowed in mysql

5 mysql needs to specify the storage type for the table

6 mssql identifier is [], [type] indicates the difference For keywords, but mysql is `, which is the symbol to the left of button 1

7 mssql supports the getdate() method to obtain the current time and date, but mysql can be divided into date type and time type to obtain the current date It is cur_date(), and the current complete time is the now() function

8 mssql does not support the replace into statement, but in the latest sql20008, the merge syntax is also supported

9 Mysql supports insert into table1 set t1 = '', t2 = '', but mssql does not support writing like this

10 mysql supports insert into tabl1 values ​​(1,1), (1,1), (1,1), (1 ,1), (1,1), (1,1), (1,1)

11 mssql does not support the limit statement, which is very regrettable. You can only use top instead of limit 0,N, row_number () over() function replaces limit N,M

12 mysql needs to specify a storage engine type for each table when creating a table, while mssql only supports one storage engine

13 mysql The datetime type whose default value is the current time is not supported (mssql is easy to do). In mysql, the timestamp type is used

14 In mssql, check whether there is such a table before deleting it. You need to do this:

if exists (select * from dbo.sysobjects where id = object_id(N'uc_newpm') and OBJECTPROPERTY(id, N'IsUserTable') = 1)

But in mysql, you only need DROP TABLE IF EXISTS cdb_forums;

15 mysql supports unsigned integers, so it can double the maximum number storage than mssql that does not support unsigned integers

16 Mysql does not support the very convenient varchar(max) type in mssql. This type can be used for both general data storage and blob data storage in mssql.

17 Mysql creates non-aggregation The index only needs to be specified as key when creating the table, for example: KEY displayorder (fid, displayorder) In mssql it must be: create unique nonclustered index index_uc_protectedmembers_username_appid on dbo.uc_protectedmembers

(username asc,appid asc)

18 The mysql text field type does not allow default values ​​

19 The total field length of a mysql table does not exceed 65XXX.

20A very superficial difference is that the installation of mysql is very simple, and the file size is only 110M (non-installation version). Compared with the behemoth Microsoft, the installation progress is simply...

21 Mysql has several better management tools, including mysql_front and the official suite, but they are not as easy to use as SSMS. This is a big shortcoming of mysql.

22Mysql's stored procedures only appear in the latest version, and the stability and performance may not be as good as mssql.

23 Under the same load pressure, mysql consumes less CPU and memory, while mssql is indeed very resource-consuming.

24php has similar methods of connecting mysql and mssql. You only need to replace the mysql of the function with mssql.

25mysql supports date, time, and year types, and mssql only supports date and time in 2008.

[Related recommendations: mysql video tutorial]

The above is the detailed content of What is the difference between mysql and mssql. For more information, please follow other related articles on the PHP Chinese website!