Posts Tagged: MySQL

Quickly duplicate a row in MySQL

A quick way of duplicating a row in a table without running into duplicate key errors or having to type out all the field names… Not quite a one-liner, but very straightforward. /* Duplicate row 58 from mytable */ CREATE TEMPORARY TABLE tmptable SELECT * FROM mytable WHERE id = 58;   /* Change the… Read more »

MySQL DATE_FORMAT() AND PHP date() formats

I’m always finding myself looking up strings to format PHP and MySQL dates. A simple d/m/Y is pretty straight forward but sometimes things can get a bit fiddly. Where ever possible I try and leave my date formatting in the database, but I still find myself doing it in PHP all the time. Here are… Read more »