将A表中的值插入A表

Question

I have one table in mysql that stores menu items. Structure is as below

Table: menu_list_hed

id    menu_name    shop_id    menu category
--------------------------------------------
 1     Breakfast      12          Veg
 2     Dinner         12          Veg
 .... Many more

Now, i have another shop which has same menu but shop_id(13) is different. How can i copy same values again and make table look like as below

id    menu_name    shop_id    menu category
--------------------------------------------
 1     Breakfast      12          Veg
 2     Dinner         12          Veg
 .... Many more
 25    Breakfast      13          Veg
 26    Dinner         13          Veg
 .... Many more

I tried exporting SQL from phpmyadmin but that will take lots of time as i have to manually change the shop_id for each SQL statement.

Answer 1

You can use insert with select and provide your shop_id in select statement

INSERT INTO menu_list_hed
    (`menu_name`, `shop_id`, `menu category`)
select `menu_name`, '13' AS `shop_id`, `menu category`
from menu_list_hed where shop_id = 12
;

Demo