How to do a Select in an insert MySQL

Question

My question is how do i do a select of one attribute in my table. I have the following table->

CREATE TABLE `Group` ( `group_id` varchar(10) NOT NULL, `user_id` varchar(10) NOT NULL, `group_creator` varchar(20) NOT NULL, `group_name` varchar(50) NOT NULL, `date_created` datetime DEFAULT NULL, CONSTRAINT UC_Group UNIQUE (group_id,group_code,group_name) ) ENGINE=InnoDB DEFAULT CHARSET=latin1; ALTER TABLE `Group` ADD PRIMARY KEY (`group_id`), ADD KEY (`user_id`);

I would like to insert the user_id from another table called User. However it is not working.
My insert is as follows->

INSERT INTO `Group` (`group_id`, `user_id`, `group_creator`, `group_name`, `date_created`) SET `group_id`=UUID(), `user_id`=(SELECT user_id FROM User WHERE username='TheDoctor'), `group_creator`='TheDoctor', `group_name`='HeroesUnited', `date_created`= CURRENT_TIMESTAMP();

Naming a table group is just asking for trouble

Strawberry
– Strawberry

2018-01-27 21:08:37 +00:00
Commented Jan 27, 2018 at 21:08 — Strawberry
– Strawberry, Commented Jan 27, 2018 at 21:08

Carol · Accepted Answer · 2018-01-27 21:34:48Z

1

Source

INSERT INTO Group SELECT UUID(),user_id,'TheDoctor','HeroesUnited', CURRENT_TIMESTAMP() FROM User WHERE username='TheDoctor'

answered Jan 27, 2018 at 21:34

Carol

381 silver badge6 bronze badges

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

1 Comment

Asilver Over a year ago

It gave me an error when i added this though it worked. INSERT INTO Group(group_id, user_id, group_creator, group_name, date_created) SO thanks!

Collectives™ on Stack Overflow

How to do a Select in an insert MySQL

1 Answer 1

1 Comment

Linked

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

1 Comment

Linked

Related