Shulou(Shulou.com)05/31 Report--

This article mainly talks about "what are the differences between mysql and mssql". Interested friends may wish to take a look. The method introduced in this paper is simple, fast and practical. Now let the editor take you to learn "what are the differences between mysql and mssql"?

Differences: 1. Mysql supports enum and set types, but mssql does not; 2. Mssql does not support limit,mysql; 3. Mysql supports unsigned integers, but mssql does not; 4. Under the same load pressure, mysql consumes less 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, which is a database platform that provides a complete solution of the database from the server to the terminal. The database server part is a database management system used to establish, use and maintain the database.

At the beginning, SQL Server was not a product developed by Microsoft itself, but it was produced in cooperation with Sybase in order to compete with IBM at that time. Its earliest developer was Sybase. At the same time, Microsoft also cooperated with Sybase in the research and development of SQL Server 4.2. Microsoft also transplanted SQL Server 4.2 to Windows NT (then version 3.1). After terminating the partnership with Sybase, it independently developed SQL Server version 6.0. Later SQL Server was developed by Microsoft itself.

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 is less demanding than MSSQL. MySQL is a free, open source SQL database, so free MYSQL is very popular, php+mysql,MySQL database is dedicated to PHP sites, generally used on PHP pages, he and PHP can be said to be a golden partner (both open source free things).

For websites that are not particularly heavy traffic, they are especially competent and efficient, and MYSQL is suitable for small and medium-sized websites. Mysql is an open source database Server, which can be run on windows platform, unix platform and linux platform. Its standard version is free. ASP.NET and MYSQL are not suitable for use together. PHP+MySQL+Apache is very popular for building stations in China.

MS SQL is a commercial database system launched by Microsoft, whose full name is Microsoft SQL Sever. It is Microsoft's stuff, and it needs to be charged, so it is more expensive. At present, large websites generally use Oracle or MSSQL,JSP.PHP.ASP. It is 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.

Differential summary

1 mysql supports enum, and set types, but not sql server.

2 mysql does not support nchar,nvarchar,ntext type

The incrementing statement of 3 mysql is AUTO_INCREMENT, while mssql is identity.

4. By default, the default value of msms everywhere table creation statement is ((0)), but two parentheses are not allowed in mysql.

5 mysql needs to specify the storage type for the table

6 the mssql identifier is [], and [type] indicates that it is different from the keyword, but mysql is `, which is the symbol to the left of button 1.

7 mssql supports the getdate () method to get the current time and date, but mysql can be divided into date type and time type. The current date is cur_date (), and the current full time is the now () function.

8 mssql does not support replace into statements, but in the latest sql20008, 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)

11 mssql does not support limit statements, which is very regrettable. We can only use top to replace the limt 0meme NMagi rowbook number () over () function instead of limit NMagi M.

12 mysql specifies one storage engine type for each table when creating tables, while mssql supports only one storage engine

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

14. Check whether the table is deleted in 14 mssql. You need to do this:

If exists (select * from dbo.sysobjects where id = object_id (newpm') and OBJECTPROPERTY (id, Noble IsUserTable') = 1)

But in mysql, only DROP TABLE IF EXISTS cdb_forums is needed.

15 mysql supports unsigned integers, so there is twice as much maximum storage as unsigned mssql.

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 to create a nonclustered index, you only need to specify key when creating the table. For example, KEY displayorder (fid,displayorder) must be create unique nonclustered index index_uc_protectedmembers_username_appid on dbo.uc_protectedmembers in mssql.

(username asc,appid asc)

18 default values are not allowed for mysql text field types

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

20 A superficial difference is that mysql installation is very simple, and the file size is only 110m (non-installation version), compared to the Microsoft behemoth, the installation progress is almost the same.

21mysql has several good management tools, mysql_front, and the official suite, but they are not as easy to use as SSMS, which is a big disadvantage of mysql.

22mysql stored procedures only appear in the latest version, and their stability and performance may not be as stable as mssql.

Under the same load pressure, mysql consumes less CPU and memory, and mssql really consumes a lot of resources.

24php connects mysql and mssql in the same way, just replace the mysql of the function with mssql.

25mysql supports date,time,year types, while mssql does not support date and time until 2008.

At this point, I believe you have a deeper understanding of "what is the difference between mysql and mssql". You might as well do it in practice. Here is the website, more related content can enter the relevant channels to inquire, follow us, continue to learn!

Welcome to subscribe "Shulou Technology Information " to get latest news, interesting things and hot topics in the IT industry, and controls the hottest and latest Internet news, technology news and IT industry trends.