mysql - SQL Insert from Select to same table but with a changed ID - MySQL

Question

我需要从一个表中复制一些具有相同 id_shop 值的行，然后将这些行插入回同一个表但具有不同的 id_shop 值。我不确定如何做后面的部分。我猜这将是以下内容的变体。

  INSERT INTO `ps_hook_module`(`id_module`, `id_shop`, `id_hook`, `position`)
  SELECT `id_module`, `id_shop`, `id_hook`, `position` FROM `ps_hook_module` WHERE     
  `id_shop` = 1

Answer 1

INSERT INTO `ps_hook_module`(`id_module`, `id_shop`, `id_hook`, `position`)
SELECT `id_module`, 42, `id_hook`, `position` FROM `ps_hook_module` 
WHERE `id_shop` = 1

42 是您想要的不同 id_shop 值