What is the difference between MySQL database and MSSQL Server?

The following articles mainly introduce the differences between the MSSQL Server and the MySQL database. We all know that the proportion of the MySQL database in actual application is always high, therefore, knowledge about MySQL databases is also of high concern.

1. MySQL supports the enum and set types, but SQL Server does not;

2. MySQL does not support nchar, nvarchar, and ntext types;

3. the incremental Statement of MySQL database is AUTO_INCREMENT, while that of ms SQL is identity );

4. ms SQL by default, the default value of the everywhere table creation statement is (0), and in MySQL it is not allowed to contain square brackets;

5. MySQL needs to specify the storage type for the table;

6. The ms SQL identifier is [], [type], indicating that it is different from the keyword, but MySQL is ', that is, the symbol on the left of the key 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, get the current date is cur_date (), the current complete time is now () function;

8. ms SQL does not support replace into statements, but in the latest SQL Server 2008, it also supports merge syntax;

9. MySQL database supports insert into table1 set t1 = '', t2 ='', but ms SQL does not support this write;

10. MySQL supports insert into tabl1 values)

11. ms SQL does not support the limit statement, it is very sorry, can only replace limt 0, N, row_number () over () function instead of limit N, M;

12. When creating a table, MySQL must specify a storage engine type for each table, while ms SQL only supports one storage engine;

13. MySQL does not support the datetime type of the default value for the current time (ms SQL is easy to do), in MySQL is the timestamp type;

14. check whether this table exists in the ms SQL and then delete 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) 
 
 

However, in MySQL, you only need to drop table if exists cdb_forums;

15. MySQL supports unsigned integers, so it can store up to twice the maximum number of unsigned ms SQL statements;

16. MySQL does not support the varchar (max) type that is very convenient in ms SQL. This type can be used for both general data storage and blob Data Storage in ms SQL;

17. To create a non-clustered index in the MySQL database, you only need to specify the key when creating the table, for example, KEY displayorder (fid, displayorder)

In ms SQL, you must:

 
 

  
  
create unique nonclustered index  
  
  
index_uc_protectedmembers_username_appid on dbo.uc_protectedmembers(username asc,appid asc) 
 
 

18. MySQL text field types cannot have default values;

19. The total field length of a MySQL table cannot exceed 65XXX.

20. The obvious difference is that the installation of MySQL is very simple, and the file size is only 110 M (non-installation version). Compared with Microsoft, the installation progress is simply .....

21. There are several good MySQL management tools, MySQL_front and the official suite, but they are not easy to use SSMS, which is a major disadvantage of MySQL.

22. MySQL stored procedures only appear in the latest version, and the stability and performance may be inferior to that of ms SQL.

23. The same load pressure, MySQL to consume less CPU and memory, ms SQL is indeed very resource-consuming;

24. php connects to the MySQL database and ms SQL in similar ways. You only need to replace the MySQL function with ms SQL.

25. MySQL supports date, time, year type, ms SQL to 2008 only support date and time.