Considerations for MySQL type conversion

One of the most recent tasks is to rewrite the services that used the MSSQLServer database to support MySQL databases. SQL statements involve some type conversion functions, the result shows that the MySQL type conversion function CONVERT does not provide good compatibility with data type names, and the parameter order is also different! Use convert (int, Por in SQLServer

One of the most recent tasks is to rewrite the services that used the MSSQLServer database to support MySQL databases. SQL statements involve some type conversion functions, the result shows that the MySQL type conversion function CONVERT does not provide good compatibility with data type names, and the parameter order is also different! Use convert (int, Por in SQLServer

One of the most recent tasks is to use the MSSQLServer database service,

To support MySQL databases, SQL statements involve some type conversion functions,

The result shows that the MySQL type conversion function "CONVERT" does not provide good compatibility with data type names,

The Parameter order is also different!

Use convert (int, Port) in SQLServer, and use convert (Port, SIGNED) AS 'Port' in MySQL'

Note: If the column name in the result set is not added AS 'Port', it will be displayed AS convert (port, SIGNED)

SQL Server uses brackets [] to solve special symbols, keywords, and other problems, but MySQL needs to use single quotes ·

It is also called a short period. It is also a weighing note, that is, the key under Esc in the upper left corner of the keyboard. If you enter it, you do not press Shift.

Note the Data Type Used for conversion. This type can be one of the following values:

BINARY [(N)]

CHAR [(N)]

DATE

DATETIME

DECIMAL

SIGNED [INTEGER]

TIME

UNSIGNED [INTEGER]