为了进行比较，我们可以在 strcmp() 函数中使用数值作为参数。它们作为参数给出，不带引号。下面的示例将对其进行演示。
示例mysql> select strcmp(10,10)as 'equal numbers', strcmp(11,10)as '2nd smaller', strcmp(10,11)as '1st smaller', strcmp(10,null)as '2nd null',strcmp(null,10)as '1st null',strcmp(null,null)as 'both null';+---------------+-------------+-------------+----------+----------+-----------+| equal numbers | 2nd smaller | 1st smaller | 2nd null | 1st null | both null |+---------------+-------------+-------------+----------+----------+-----------+| 0 | 1 | -1 | null | null | null |+---------------+-------------+-------------+----------+----------+-----------+1 row in set (0.00 sec)
以上就是如何在 mysql strcmp() 函数中使用数值作为参数？的详细内容。