In mysql, delete and truncate both are used for deleting data from table.deletedelete comes under dml (datamanipulation language). delete canbe used to delete a particular rowby using where clause.it ...

DROP comes under DDL (Data Definition Language). It removes whole table (including table structure) from the database. The data cannot be roll backed if the table is dropped by 'DROP' command. Syntax: ...

When extending PHPUnit_Extensions_Database_TestCase, a TRUNCATE statement seems to be executed for all tables found in the fixture. These TRUNCATE statements result in an Exception. The actual caus ...