Skip to content

Instantly share code, notes, and snippets.

@tlkshadow

tlkshadow/multi_inserts.mysql

Created February 8, 2020 17:44
Show Gist options
  • Star 0 You must be signed in to star a gist
  • Fork 0 You must be signed in to fork a gist
  • Save tlkshadow/87f2a3fbdbf2331d4492f4c04802fb8b to your computer and use it in GitHub Desktop.
Save tlkshadow/87f2a3fbdbf2331d4492f4c04802fb8b to your computer and use it in GitHub Desktop.
Download ZIP
Raw
multi_inserts.mysql
ALTER TABLE `products` DISABLE KEYS;
INSERT INTO products (name, status) VALUES
('Product 1', 'live'),
...
('Product 10', 'live');
ALTER TABLE `products` ENABLE KEYS;
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment