Skip to content

Instantly share code, notes, and snippets.

View keybase.md

Keybase proof

I hereby claim:

  • I am zandeez on github.
  • I am zandeez (https://keybase.io/zandeez) on keybase.
  • I have a public key ASArNpvWR0izdP_EKqBlvV9f3tv7H8h33axkBD6-h0lCBgo

To claim this, I am signing this object:

@zandeez
zandeez / gist:6760670
Created Sep 30, 2013
MySQL Stored Procedure for truncating all tables in the database.
View gist:6760670
DELIMITER //
CREATE PROCEDURE TruncateAll()
--
-- TruncateAll
-- Date: 2013-09-29
-- Author: Andrew Cassidy <andrew@cassidywebservices.co.uk>
--
-- This Stored Procedure Loops over the tables in the current database and
-- truncates them. Behaviour of tables containing or referenced by foreign keys
-- is undefined (by me, MySQL documentation may have other ideas, TL;DR)