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; DROP TABLE tmp;
My personal list of links which I keep here publicly incase they help someone else one day.
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.
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