Delete all records from a table in SQL

delete notes.txt

delete and truncate :

delete from mytable

This will delete all the content of the table, not reseting the autoincremental id, this process is very slow. If you want to delete specific records append a where clause at the end.

truncate myTable

This will reset the table i.e. all the auto incremental fields will be reset. Its a DDL and its very fast. You cannot delete any specific record through truncate.