puoi usare DELETE FROM o TRUNCATE TABLE.

ti rimando al manuale on-line per chiarimenti sulle differenze

delete -> http://dev.mysql.com/doc/mysql/en/delete.html

truncate -> http://dev.mysql.com/doc/mysql/en/truncate.html