Code Snippets

Duplicate all rows in a Mysql table | mysql

This query makes a duplicate of all rows in a table.

# This assumes that the table you want to duplicate is called 'maths_score' and you have an auto_increment field called 'uniqueid' -- change accordingly!

CREATE TEMPORARY TABLE tmp SELECT * from maths_score;  
ALTER TABLE tmp DROP uniqueid;  
INSERT INTO maths_score SELECT 0, tmp.* FROM tmp;  

Published: Fri 12th January 2018
||COMMENTS|| This site proudly uses PrismJS to display code snippets

If you like this page, please share it.

Code Links - PHP, JS, CSS, Bootstrap, Bash, Emmet, IntelliJ, Sublime etc.

My personal list of links which I keep here publicly incase they help someone else one day.

Code Snippets

Snippets of PHP code I have gathered over the years. I keep them here for my own repository but also to share with others. I always link back when I remember the source.

My Github Repos

A work in progress. I am going to make as many modules that I write in my devbox public as possible.

Kit's Homepage

This site was originally intended as a test bed for code. It now includes my blog about business and powerlifting, as well as games for Spanish language learning

© 2018