1 Star2 Stars3 Stars4 Stars5 Stars (3 votes, average: 5.00 out of 5)

Delete Records MySql Terminal Command

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.

Tip: Click on images to make them larger. If you find anything wrong on this page or need further assistance please comment below or contact me. 🙂
DELETE FROM [table];

Delete all records in a table.

truncate table [table];

Remove table columns.

Subscribe To My YouTube Channel:
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: December 12th, 2016 by Maximus Mccullough

Please like, share and subscribe.

Advanced Programming Made Easy

I hope you enjoyed the article. If I was able to help you please consider a tip for the content.

One Time Tip

more tips

Reoccuring Tips


Cool People Share:
Delete Records MySql Terminal Command

Leave a Reply

Your email address will not be published. Required fields are marked *

This site uses Akismet to reduce spam. Learn how your comment data is processed.