Difference between SQL Server and MySQL

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.