i have been learning about mysql database technology,while revising the concepts i found this thing confusing to me.
truncate is in ddl command,as far as i know any command that deals with the structure of table has been classified in to ddl statement,
but truncate in mysql just deletes the table data ,NOT THE STRUCTURE,
this looks like delete to me,the only difference i know between them is you can not rollback an ddl statement(i.e truncate),but you can rollback on dml statement(i.e delete),beyond this i couldn't able to find any difference between them.