Develop somethings, meditation, reading and thinking...

MySQL 테이블 초기화하기

Last updated over 3 years ago
1 0 0 0

MySQL 에서 테이블을 초기화 할 때 사용하는 명령.

TRUNCATE TABLE table_name;

TRUNCATE 을 사용하면 DELETE 와 달리 autocommit 값도 초기화된다.

DELETE FROM `table_name`;

모든 데이터를 삭제

MySQL 테이블 삭제 지우기

Hi, my name is Richard. I’m a developer wants to make the world better with logic power. Mainly I use Linux, Nginx, MySQL, PHP and JavaScript . I want to share my knowledge with someone that it was also based from some great persons via LYNMP. 👨‍💻

Essedrop - Make your file online instantly


Leave a response to @richard

Please sign in to comment.
Markdown is also available in comment.