Tags » Delete

How to DELETE all records from all tables in a schema?

This is rather an exercise than a practical task. Anyway, the approach presented below might be helpful in some practical situations.

Problem Level: Beginner/Intermediate

Step 1: Disable all foreign key constraints. 152 more words


It's fixed!

Yes, it’s fixed! My computer.  Or rather, my laptop.  The nice, calm, friendly Computer Man (CM) was like a dog with a bone. He didn’t give up until it was all working properly, bless him. 679 more words

Wellbeing Corner

Delete files and folders recursively using PHP

unlinkr function recursively deletes all the folders and files in given path by making sure it doesn’t delete the script itself.

    function unlinkr($dir, $pattern = "*") {
        // find all files and folders matching pattern
        $files = glob($dir . 182 more words

Free: make a lantern - this Friday and Saturday

Its the Harringay Lantern Parade on Saturday the 28th of November and in preparation for that there are free lantern making workshops this Friday the 20th and Saturday the 21st of November. 153 more words


Decrease your footprint, increase your design and eco cred

I stumbled across a very exciting, upcycled cabin photo on Pinterest the other day which led me into the fascinating world of “tiny houses”. Of course I’d heard of this trend before – friends from the dogpark were building a house for themselves and their mini schnauzer to live in, which would fit in a car-towed trailer. 381 more words