[请益] mysql的cast函数

楼主: yommy1108 (chiakila)   2016-04-16 23:35:55
想请教各位前辈
mysql> SELECT CAST(NOW() AS DATE) x1,
-> CAST(CAST(1-2 AS UNSIGNED) AS SIGNED) x2,
-> CAST(1-2 AS UNSIGNED) x3,
-> CAST(1 AS UNSIGNED) - 2.0 x4;
+
作者: locklose (允)   2016-04-16 23:52:00
x3 -> Unsigned x4 -> Signedhttp://goo.gl/HvB5rg
作者: MOONRAKER (㊣牛鹤鳗毛人)   2016-04-17 02:15:00
都unsigned了还想要看到-1是怎样 用P档开完驾照考试吗

Links booklink

Contact Us: admin [ a t ] ucptt.com