Skip to content

Instantly share code, notes, and snippets.


Keybase proof

I hereby claim:

  • I am zandeez on github.
  • I am zandeez ( on keybase.
  • I have a public key ASArNpvWR0izdP_EKqBlvV9f3tv7H8h33axkBD6-h0lCBgo

To claim this, I am signing this object:

zandeez / gist:6760670
Created Sep 30, 2013
MySQL Stored Procedure for truncating all tables in the database.
View gist:6760670
-- TruncateAll
-- Date: 2013-09-29
-- Author: Andrew Cassidy <>
-- 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)