mysql while loop; select and insert

Question

I'm trying to move enums from a table into their own table, the easiest way would be to run an SQL query which I figured I might use a WHILE loop for, but having never used one before the below obviously doesn't work. Is it possible to do something as the following:

WHILE (SET @cat = (SELECT DISTINCT `category` FROM `tablename`))
DO
  BEGIN
   INSERT INTO `categories` (title) VALUES (@cat);
  END;
END WHILE;

silly · Accepted Answer · 2012-04-04 09:03:43Z

5

why do you dont try to insert the categories direct like this:

INSERT INTO `categories`
(
    title
)
SELECT DISTINCT
    `category`
FROM `tablename`

answered Apr 4, 2012 at 9:03

silly

7,8972 gold badges26 silver badges37 bronze badges

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

Collectives™ on Stack Overflow

mysql while loop; select and insert

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