MySQL Forums
Forum List  »  MySQL Workbench

edit data for json column with bigint
Posted by: Lion Hawk
Date: November 07, 2017 02:34AM

I have a table named "t_flow_sheet",and it have a json type column named "FORM_JSON".
when I run sql script´╝Ü
SELECT json_extract(FORM_JSON,"$.*.createTime") from t_flow_sheet LIMIT 1;

Then I get a result grid:
[1509588087000]
it is correct.

but I open value in viewer,I get
[
-2147483648
]

How I can get correct value when edit data for json ?

Options: ReplyQuote


Subject
Views
Written By
Posted
edit data for json column with bigint
63
November 07, 2017 02:34AM


Sorry, only registered users may post in this forum.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.