The difference between delete and truncate in DML

-- Delete data delete from Table name truncate table Table name
TRUNCATE TABLE tea;
/*
    delete and truncate The difference between
   delete from Table name ： Delete the number of records in the whole table
         For growth, the primary key field is not affected id 1,2,3,4,5   Next time insert data into the table id 6
   truncate table Table name ： Deleted table , Copying an identical table
         Leave the self growing primary key field blank , Insert data next time ： from 1 It has been increasing since the beginning
*/
DROP TABLE test;
SHOW TABLES;
CREATE TABLE test(
    id INT PRIMARY KEY AUTO_INCREMENT,-- Self growing primary key
    NAME VARCHAR(20),
    gender    VARBINARY(10)
);

SELECT *FROM test;

INSERT INTO test(NAME,gender)VALUES(' Zhang San ',' male ');
INSERT INTO test(NAME,gender)VALUES(' Lisa ',' Woman ');
INSERT INTO test(NAME,gender)VALUES(' Wang Wu ',' male ');
INSERT INTO test(NAME,gender)VALUES(' Zhao Liu ',' Woman ');

DELETE FROM test;-- Just deleted all records
TRUNCATE TABLE test;-- Delete table , Recreate an identical table