Mssql,mysql Syntax Differences

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)

Mysql:create table Basic (ID int key auto_increment,name varchar (20));
Mssql:create table Basic (ID int identity (), name varchar (20))

4 msms default values for table creation statements are ((0)), and two brackets are not allowed in MySQL

5 MySQL needs to specify the storage type for the table

6 the MSSQL identifier is [],[type] means that he is different from the keyword (optional to include the table name, field name), but MySQL is ' (accent, that is, key 1 to the left of the symbol)

7 MSSQL 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 MSSQL 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 MSSQL does not support this writing

Ten MySQL insert multiple lines support so write insert into TABL1 values ((+), (max), (max), (max), (max), MSSQL does not support

Each MSSQL does not support the limit statement, is very regrettable, can only use the 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 MSSQL 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

Inside the MSSQL to check if there is this table and then delete, need this:

if exists (SELECT * from dbo.sysobjects WHERE id = object_id (n ' uc_newpm ') and OBJECTPROPERTY (ID, n ' isusertable ') = 1)

In MySQL, however, only the DROP TABLE IF EXISTS cdb_forums is required;

MySQL supports unsigned integers, so you can save up to a maximum number of times more than a non-unsigned MSSQL

MySQL does not support the use of the very convenient varchar (max) type in MSSQL, this type in MSSQL can do both general data storage, also can do BLOB data storage

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 MSSQL: Create unique nonclustered index Index_uc_protectedmembers_username_appid on Dbo.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 of stored procedures only appear in the latest version, stability and performance may not be as good as MSSQL.

23 The same load pressure, MySQL to consume less CPU and memory, MSSQL is really very resource-intensive.

24php connects MySQL and MSSQL the same way, only need to replace the function of MySQL to MSSQL.

The 25mysql supports the Date,time,year type and MSSQL to 2008 supports date and time.

36 Assigning values to variables
MYsql: Variable Assignment Select @min_price: =min (Price), @max_price: =max
MSsql: Variable Assignment Select @min_price =min (Price), @max_price =max

Mssql,mysql Syntax Differences