SELECT UUID() inside an insert statment MySQL

Question

I'm trying to use SELECT UUID() INSIDE an insert query. Here is my uery

INSERT INTO `posts`(`post_id`, `user_id`, `content`, `time`) VALUES (SELECT uuid(),1,'my content',mytime)

I'm getting error a comma or a closing bracket was expected mysql near uuid

NineBerry · Accepted Answer · 2017-10-17 22:57:43Z

8

uuid is a function, that you can use on its own without having to write select.

INSERT INTO `posts`(`post_id`, `user_id`, `content`, `time`) VALUES (uuid(),1,'my content',mytime)

answered Oct 17, 2017 at 22:57

NineBerry

28.8k4 gold badges68 silver badges104 bronze badges

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

1 Comment

Alternatively, I guess you could remove VALUES ( and )