Quick Backup MySQL / Oracle table

This is a script I use often to get a quick back up of a database table before doing any changes to it.


CREATE TABLE BK_TBL_TEST AS SELECT * FROM TBL_TEST;


Hope this helps for those quick backups. 🙂