The special point of Mysql

Internet companies generally choose MySQL, which is widely used in the Internet, but have been using Microsoft's stuff, including databases (MS SQL Server).

This is not the thought of switching databases so easy, but there are some details to note.

Data type DateTime type does not save milliseconds by default

If we use the DateTime field in the MSSQLServer, the number of milliseconds will be automatically stored in the database.

In MySQL, you can specify the precision of time when you can directly declare a column of the time type in the 5.6.4 + version.

eg. DATETIME (3) will add a millisecond to the time

Left Join is not the same as MSSQLServer

Reference

Three points you may need to know about MySQL left JOIN

SQL Data Types for Various DBs

DATETIME (Transact-SQL)

Timestamp with a millisecond precision:how to save them in MySQL

The special point of Mysql