Skip to content

Instantly share code, notes, and snippets.

@nosmall

nosmall/duplicating_entire_rows.sql

Created February 28, 2018 10:28
Show Gist options
  • Save nosmall/de5c4b2bc4de02f80de5683b5f0f57f0 to your computer and use it in GitHub Desktop.
Save nosmall/de5c4b2bc4de02f80de5683b5f0f57f0 to your computer and use it in GitHub Desktop.
Download ZIP
Duplicating entire rows in MySQL table to the same table
Raw
duplicating_entire_rows.sql
INSERT IGNORE INTO `db_lang` (`id`, `hodnota`, `jazyk`) SELECT `id`, `hodnota`, 'en' FROM db_lang;
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment