1, the datetime in SQL SERVER, reservation to microseconds (three seconds after the decimal point), and mysql to retain only seconds, after the transformation will affect the business, if affected, need to add a field to store the special microseconds or milliseconds, although I have no time to the precision of the data type in mysql to microseconds or milliseconds, but mysql provides microsecond the processing function of microseconds, extract with date_format
2, MySQL using tinyint instead of SQL SERVER bit
3, on the processing, on the step with the incremental value of mysql are the unity of the whole instance, not every form dynamic modification, so here are in the process of transformation, according to the auto_increment, for instance set up to handle
Second, the corresponding relation of SQL SERVER and MySQL data types as shown in figure
CodePudding user response:
Refer to