To delete records in mysql use this terminal command.
DELETE FROM [table] WHERE [column] = [value];
Delete all records without dropping the table. This will also reset the increment number value.
DELETE FROM [table];
Delete all records in a table.
truncate table [table];
Remove table columns.
ALTER TABLE [table] DROP COLUMN [column];
DROP TABLE [table];
Delete a database.
DROP DATABASE [database];
Complete Cheat Sheet https://gist.github.com/hofmannsven/9164408