Delete Records MySql Terminal Command

To delete records in mysql use this #terminal command. #mysql

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];

Deleting tables.

DROP TABLE [table];

Delete a database.

DROP DATABASE [database];