728x90 2018/12/181 트랜잭션 Transcation, 락 Lock, 격리수준 IsolationLevel -- Transcation select @@autocommit; set autocommit = false; create database sampleDB; create table BusinessCard(Name varchar(255), Address varchar(255), Telephone varchar(255)); insert into BusinessCard values ('Bob', 'Seocho-dong 123', '123-4567'); commit; rollback; -- Lock select engine, support from information_schema.engines where support='DEFAULT'; set default_storage_engine = InnoDb;set de.. 2018. 12. 18. 이전 1 다음 728x90