Differences between ms SQL Server and MySQL

Source: Internet
Author: User
Tags mysql text

1. MySQL supports enum, set, and SQL Server.
2. MySQL does not support nchar, nvarchar, and ntext types.
3. the incremental Statement of MySQL is AUTO_INCREMENT, while that of ms SQL is identity)
4. ms SQL does not support replace into statements, but in the latest sql20008, it also supports merge syntax
5. MySQL supports insert into table1 set t1 = "", t2 = ", but MSSQL does not support this write.
6. MySQL supports insert into tabl1 values)
7. ms SQL does not support limit statements. It is a pity that only the top function can be used to replace limt0, N, row_number () over () with the limit N, M
8. When creating a table, MySQL must specify a storage engine type for each table, while ms SQL only supports one storage engine.
9. PHP connects to MySQL and ms SQL in similar ways. You only need to replace the MySQL of the function with ms SQL.
10. 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.
11. MySQL needs to specify the storage type for the table
12. 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 key 1
(Note: This is not a single quotation mark. I am sleepy at the beginning !!!) .
13. MSSQL supports the getdate () method to obtain the current time and date, but MySQL can divide the date type and time type to obtain the current date as cur_date (), and the current complete time is the now () function.
14. MySQL does not support the datetime type whose default value is the current time (MSSQL is easy to do). in MySQL, the timestamp type is used.
15. Check whether the table exists in ms SQL and delete it again. You need:
If exists (select * from dbo. S
Where id = t_id (N "uc_newpm") andTPROPERTY (id, N "IsUserTable") = 1)
However, in MySQL, you only need to drop table if exists cdb_forums;
16. MySQL text field types cannot have default values
17. The total field length of a MySQL table cannot exceed 65XXX.
18. ms SQL by default, the default value of the table creation statement is (0), while MySQL does not allow two parentheses.
19. The same load pressure, MySQL consumes less CPU and memory, ms SQL is indeed very resource-consuming.
20. MySQL supports unsigned integers, so it can store up to twice the maximum number of unsigned ms SQL statements.
21. MySQL does not support the varchar (max) type that is very convenient in MSSQL. This type can be used in both general data storage and blob Data Storage in MSSQL.
22. To create a non-clustered index in MySQL, you only need to specify the key when creating the table. For example, KEYdisplayorder (fid, displayorder) must be:
Create unique nonclustered index
Index_uc_protectedmrs_username_appid on dbo. uc_protectedmrs
(Username asc, appid asc)
23. 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 .....
24. MySQL stored procedures only appear in the latest version. The stability and performance may be inferior to that of ms SQL.
25. MySQL supports date, time, year type, ms SQL to 2008 only support date and time.
 

Related Article

Contact Us

The content source of this page is from Internet, which doesn't represent Alibaba Cloud's opinion; products and services mentioned on that page don't have any relationship with Alibaba Cloud. If the content of the page makes you feel confusing, please write us an email, we will handle the problem within 5 days after receiving your email.

If you find any instances of plagiarism from the community, please send an email to: info-contact@alibabacloud.com and provide relevant evidence. A staff member will contact you within 5 working days.

A Free Trial That Lets You Build Big!

Start building with 50+ products and up to 12 months usage for Elastic Compute Service

  • Sales Support

    1 on 1 presale consultation

  • After-Sales Support

    24/7 Technical Support 6 Free Tickets per Quarter Faster Response

  • Alibaba Cloud offers highly flexible support services tailored to meet your exact needs.