MySQL How to drop multiple columns in MySQL

Dropping multiple columns in MySQL is done with a single SQL statement. For example, let's assume you have a users table and you want to drop the email and name columns:

ALTER TABLE users DROP COLUMN name, DROP COLUMN email;

It's important to keep in mind that when you drop a column, all data stored in that column will be permanently deleted.