How to select a list of data in MySQL and insert with one Query with SQL Language

user_5595861 0
Viewed 24

I have a Select Statement that fetches more than 1 data

set @name := select name from users;

Now I want to insert all of them with one Query

for example

insert into users2 (name , created) Values (@name , NOW())

it returns this error

Error Code: 1242
Subquery returns more than 1 row

is there any way to do this without a loop?

mysql sql
2 Answers

The syntax must be like this

insert into users2 (name , created)
select name, NOW()  from users
user_51935360

Try this

insert into users2 (name , created) 
 select name, NOW() from users;
user_52472790
Related