How to Delete All Records from MySQL Table
Notes:
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;
Ex:
truncate table tbl_faculty;
Interview Questions:
