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:
it is correct.

but I open value in viewer,I get

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

Options: ReplyQuote

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

Sorry, you can't reply to this topic. It has been closed.

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.