[請益] 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