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

Today, I will talk to you about the difference between SQL Server and MySQL. Many people may not know much about it. In order to make you understand better, the editor has summarized the following for you. I hope you can get something according to this article.

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 MS SQL is identity.

4. By default, the default value of MS SQL 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 MS SQL 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 MS SQL 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 MS SQL 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 MS SQL does not support writing like this

10 MySQL supports insert into tabl1 values (1), (1), (1), (1), (1), (1), (1), (1)

11 MS SQL 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 MS SQL supports only one storage engine

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

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

If exists (select * from dbo.sysobjects where id = object_id (Nuc_newpm) and OBJECTPROPERTY (id,NIsUserTable) = 1) but only DROP TABLE IF EXISTS cdb_forums is needed in MySQL

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 MS SQL.

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

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 in MS SQL:

Create unique nonclustered indexindex_uc_protectedmembers_username_appid on dbo.uc_protectedmembers (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 MS SQL.

Under the same load pressure, MySQL consumes less CPU and memory, and MS SQL really consumes a lot of resources.

24 the way to connect MySQL and MS SQL is similar, just replace the MySQL of the function with MS SQL.

25MySQL supports date,time,year types, while MS SQL does not support date and time until 2008.

After reading the above, do you have any further understanding of the difference between SQL Server and MySQL? If you want to know more knowledge or related content, please follow the industry information channel, thank you for your support.

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.