![]() There is a similarly reported issue here:īut sadly the OP doesn't get a straight answer. If I cast the same column to a signed integer, I again get a 64 bit integer returned: mysql> select CAST(contact_id as signed integer) from contact where contact_id = 20 įield 1: `CAST(contact_id as signed integer)` Mysql> select contact_id from contact where contact_id = 20 | contact_id | int(11) | NO | PRI | NULL | auto_increment | | Field | Type | Null | Key | Default | Extra | ![]() Copyright and help message snipped for brevity - I was reading the 'MySQL supports arithmetic with both signed and unsigned 64-bit values. The next several paragraphs describe how MySQL. If I do CAST(1 AS SIGNED INTEGER) I always end up getting a BIGINT returned, for example: $ mysql -u root -p -column-type-info You can also obtain JSON values from a number of functions supplied by MySQL for this purpose (see Section 12.17.2, Functions That Create JSON Values) as well as by casting values of other types to the JSON type using CAST(value AS JSON) (see Converting between JSON and non-JSON values).
0 Comments
Leave a Reply. |