MySQL Type conversion considerations

One of the most recent jobs is to use the MSSQLServer database service before

Rewritten to support the MySQL database, some types of conversion functions are involved in SQL statements,

It turns out that MySQL's type conversion function "Convert" does not provide good data type name compatibility.

The parameters are not the same in order!

Using CONVERT (int, port) in SQL Server, convert (port, signed) as ' Port ' in MySQL

Note: If you do not add as ' Port ', the column name in the result set will appear as convert (port, signed)

In SQL Server, use brackets [] to troubleshoot special symbols, keywords, and so on, but you need to use reverse single quotes in MySQL ·

Commonly known as a small period, on the end, also known as heavy notes, the keyboard is the upper left corner ESC below the key, input without pressing SHIFT.

The data type used for conversion needs to be noted that this type can be one of the following values:

binary[(N)]

char[(N)]

DATE

Datetime

DECIMAL

Signed [INTEGER]

Time

UNSIGNED [INTEGER]