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];
Deleting tables.
DROP TABLE [table];
Delete a database.
DROP DATABASE [database];
Complete Cheat Sheet https://gist.github.com/hofmannsven/9164408
Delete Records MySql Terminal Command was last modified: March 10th, 2023 by
A1WEBSITEPRO Social Media Pages
Here are my social media pages, lets hook up!