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]