Recent posts

[SQL] DELETE FROM vs TRUNCATE

less than 1 minute read

DELETE FROM vs TRUNCATE 공통적으로 record를 삭제 DELETE FROM은 WHERE을 통해 특정 조건을 만족하는 record 삭제/ TRUNCATE는 모든 record 삭제 DELETE FROM보다 TRUNCATE의 속도가 빠름 TRUNCAT...

[SQL] Transaction

1 minute read

Transaction 개념 autocommit=True autocmmit=False try/catch & autocommit