[MySql] DELETE + JOIN 사용법

-- Defult Query
delete from [table name];
 
delete from [table name] where [column] = 00000;

 

• JOIN 문과 결합하여 삭제하는 경우 Query

-- 멀티 삭제가 아닌 경우 JOIN 문을 사용할 경우
DELETE [T_name] FROM [table_name] as [T_name] JOIN [table_name] ON [조건문] WHERE [조건문];
 
 
-- 예제를 살펴보는게 더 좋을 수 있으므로 첨부
DELETE T1 FROM test_table as T1 JOIN join_table ON T1.char_idx = join_table.char_idx
WHERE join_table.user_idx > 1 and join_table.user_idx < 10;