How to Delete All Records from MySQL Table


How to delete all records from a table in MySQL:
- To delete all records from a table; we take help of truncate table command

Note: in MySQL
- tables are also called relations
- columns are also called fields
- rows are also called records

Basic Syntax:
truncate table tablename;
truncate table tbl_faculty;

Interview Questions: