How do I use json_object in mysql to create objects whose values are dynamic?

Question

I'm trying to create add a json object to a number of records where the value is a UUID. poking at it, i can limit the issue to this:

select json_object("uuid", select UUID())

even a basic

select json_object("uuid", select "1") doesn't seem to work

in both instances i get a syntax error on the subselect. does json_object not support having one of the parameters be the result of a mysql method? and/or is there a better way for me to do this? this is in MySql 5.7.12

Barmar · Accepted Answer · 2020-09-16 18:44:57Z

2

You don't need to nest SELECT. Just call the function.

SELECT JSON_OBJECT("uuid", UUID());

answered Sep 16, 2020 at 18:44

Barmar

789k57 gold badges554 silver badges669 bronze badges

Sign up to request clarification or add additional context in comments.

Collectives™ on Stack Overflow

How do I use json_object in mysql to create objects whose values are dynamic?

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related