SQL-server and MySQLNo big differenceBoth databases can run normally under. Net or J2EE, and raid can also be used. The difference is that some control code names are different, but the functions are mostly the same.
|
SQL Server |
MySQL |
|
Commercial database, expensive |
Not all are free, but very cheap |
|
Only Windows systems are supported |
Supports windows, Linux, UNIX, and other systems |
|
Cross-platform failure |
Cross-platform |
|
SQL-Server is a medium-sized database developed by Microsoft. It provides excellent visualization, powerful functions in security, and powerful technical support from Microsoft, suitable for medium and large systems. |
MySQL is a small database developed by MySQL AB. It basically has all the functions required by the database, but its functions are not powerful as SQL-server, and the Technical Support cannot keep up with it. It is suitable for small systems. |
Performance |
Stable, fast running, and strong recovery Difficult operation |
The running speed is slow and unstable. Simple and Easy to operate |
Basic Principles |
Conservative. Server's narrow and conservative storage engine |
Open. The server is scalable. The open storage engine MySQL does not fully support unfamiliar keywords, so it requires less related databases than the SQL server. |
|
Not Supported |
Enum and set types are supported. |
Security Features |
On the SQL server, you can also record SQL-related queries, but this requires a high price. |
User-friendly. MySQL has a binary log used to change data. Because it is binary, this log can quickly copy data from the host to the client. This binary log remains complete even if the server crashes.
|
|
The getdate () method is supported to obtain the current time and date. |
Returns the current date as cur_date (), and the current complete time as the now () function. |
When creating a table |
Only one storage engine is supported. |
Specify a storage engine type for each table |
|
Datetime type supported |
The default value is the datetime type of the current time, And the timestamp type is not supported. |