MYSQL, Savepoint & Truncate

-- 1. UPDATE TABLE "world"

UPDATE world set code = 1 WHERE lang = 'kor';

-- 2. SET SAVEPOINT

SAVEPOINT kr;

-- 3. DELETE FROM world

DELETE FROM world WHERE lang = 'kor';

-- 4. Rollback to kr

ROLLBACK TO kr;

-- BONUS 1. TRUNCATE : DELETE TABLE's ALL row.

truncate table world;

-- BONUS 2. ROLLBACK

rollback;

-- BONUS 3. LOOK TABLE "world"

SELECT * FROM world;

-- Empty set.
-- TRUNCATE can not recovery.

-- Yeungnam University College // Cyber Security [2014] //
-- homepage: http://www.ync.ac.kr/
-- blog: http://namedit.tistory.com/