Question - How can we delete a column or a row in MySQL?
Answer -
Now dropping a column can be simply done by using the ALTER TABLE command and then using the DROP command. It goes something like this:
ALTER TABLE table_name DROP column name;
To drop a row, first, an identification for the row is required. Once that is handy, use the DELETE command in conjunction with the conditional WHERE command. Something like this:
DELETE FROM cars WHERE carID = 3;