To delete records in a table from database DELETE statement is used.
DELETE FROM table_name
WHERE some_column=some_value;
Here WHERE clause specifies which record is to be deleted. If you not used the WHERE clause, all records will be deleted.
To delete all the data from a table the query is
DELETE FROM table_name;
or
DELETE * FROM table_name;
DELETE FROM students
WHERE name = 'mitra';
DELETE FROM students
WHERE last_name = 'Mitra'
AND student_id > 3;
DELETE FROM students
WHERE name = 'mitra';
DELETE * FROM Student;