The difference between mysql:mysql and SQL Server

First, SQL Server Basic Introduction 1.1, overview

SQL Server is a relational database management system launched by Microsoft Corporation. With ease of use scalability and the high degree of integration of related software, you can span multiple platforms, from laptops running Microsoft Windows 98 to large multiprocessor servers running Microsoft Windows 2012.
Microsoft SQL Server is a comprehensive database platform that provides enterprise-class data management with integrated Business Intelligence (BI) tools. The Microsoft SQL Server Database engine provides more secure and reliable storage capabilities for relational and structured data, enabling you to build and manage high-availability and high-performance data applications for your business.

1.2, Application Range

The scope of application of SQL Server, and its specific version has a certain relationship, basically: Enterprise Edition (Enterprises Edition) (medium and large enterprise business), Standard Edition (Edition) (Small business commercial), development version (Developer Edition) (for development companies, developers), Personal Edition (Personal Edition) (developer), MSDE (Microsoft sql Server Desktop Engine) (Simple stand-alone database, Developer Dev Test use)

1.3. Advantages and disadvantages

(1) Strong extensibility: When the system to higher database processing speed, as long as simply increase the database server can be extended.
(2) Maintainability: When a node fails, the system will automatically detect the failure and transfer the application of the fault node to ensure the continuous work of the database.
(3) Security: Because the data will be synchronized on multiple servers, you can achieve the redundancy of the data set, through multiple copies of data to ensure security. In addition, it successfully put the database into the intranet to better protect the security of the database.
(4) Ease of use: completely transparent to the application, the cluster exposes an IP
(1) The load cannot be allocated according to the processing capacity of the Web server.
(2) The Load Balancer (control side) failure can cause the entire database system to be paralyzed.

1.4, basic syntax

Add: INSERT INTO Target datasheet SELECT * from source datasheet (adds a record of the source data table to the target datasheet)

Delete: Delete from data table where condition expression

Change: Update data Table set field 1= value 1, field 2= value 2 ... field n= value n WHERE Condition expression

Check: SELECT * from data table where field name = field value order BY field name [DESC]

Ii. MySQL Basic introduction 2.1, overview

MySQL is a relational database management system developed by the Swedish MySQL AB Company, currently owned by the Oracle company. MySQL's most popular relational database management system, MySQL is one of the best RDBMS (relational database Management system, relational databases management systems) application software in WEB applications. MySQL is an associated database management system that keeps data in separate tables rather than putting all of the data in a large warehouse, which increases speed and increases flexibility. The SQL language used by MySQL is the most commonly used standardized language for accessing databases.

2.2, Application Range

Web Site System : Simple installation configuration, superior performance, open source.

Log Management System : Efficient insertion and query function, if the design is better, when using the MyISAM storage engine, the two can be unlocked, to achieve high concurrency performance.

Data Warehouse System : In the need of large storage space and efficient data analysis needs, there are basically three ways to solve this problem: 1, the use of expensive high-performance host to improve computing performance, high-end storage equipment to improve I/O performance, the results are ideal, but the cost is very high; 2, By copying data to multiple inexpensive pcserver that use large capacity hard drives to improve overall computing performance and I/O capability, the effect is fair, storage space is limited, low cost, 3, by splitting the data horizontally, using multiple inexpensive pcserver and local disks to hold the data, Each machine above only a part of all the data, solve the problem of data volume, all pcserver parallel computing, but also solve the problem of computing power, through the intermediary agent program to allocate the operation of each machine task, can solve the computational performance problems and can solve the I/O performance problems, the cost is very low. For the second and third, MySQL has a great advantage (simple replication across domains, free).

Embedded System: The biggest limitation of the embedded environment to software system is that the hardware resource is very limited, and the software system running in the embedded environment must be a lightweight and low-consumption software. MySQL has a version specifically for embedded systems.

2.3. Advantages and disadvantages

1, support 50 million records of Data Warehouse, 2, adapt to all platforms, 3, is open source software, version update faster; 4, performance is excellent. In purely performance terms, MySQL is pretty good because it contains a default desktop format, MyISAM. The MyISAM database is very compatible with the disk without consuming too much CPU and memory. MySQL can run on windows without conflict, and it is better to run on UNIX or similar UNIX-like systems. Additional performance can be obtained by using a 64-bit processor. Because MySQL often uses 64-bit integer processing in the internal, 5, the price is cheap

Disadvantage: The lack of some of the functions of stored programs, do not support unfamiliar keywords, using the default port IP (also advantages), easy to be hacked. MyISAM (the default storage engine for MySQL and the other is InnoDB) do not support transactional processing.

2.4, basic syntax

The basic syntax for MySQL is basically the same as SQL Server.

Iii. Linkages and differences

Contact: All belong to the relational database, are the current mainstream database, its basic operation syntax is the same.

Difference: The biggest difference is that MySQL is open source. Open source, what does it mean??????????

Iv. Feeling

Looking at other people's summary, just think oneself also need to summarize. Now, because of the reasons for learning, we are exposed to these two kinds of databases, the first analysis here. Before listening to everyone share MongoDB, is a non-relational database. This is to be summarized in the following. In a bad mood, you always want to write something. If I am in a bad mood, write a summary of the blog, then in fact, the mood is not good, it is not much important.

This time, the understanding of open source deepened more than before. may also benefit from the last reply shorthand, the teacher's Nudge bar!

The difference between mysql:mysql and SQL Server