Have an account?
It looks like you're new here. If you want to get involved, click one of these buttons!
Apply for Membership
Who's Online (1)
Looking to introduce yourself? Look no further, and click here! We also have IRC! [irc.evilzone.org #iexploit]
how Truncate is an ddl statement in mysql ?
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.
can some one explain me this clearly
Add a Comment