user505880
Reputation: 391
How can I delete two column (attribute) at a time from one table in mysql?
How can I delete two column (attribute) at a time from one table in mysql?
Upvotes: 0
Views: 1076
Answers (1)
shankhan
Reputation: 6571
ALTER TABLE `table_name` DROP COLUMN `column1`, DROP COLUMN `column2`
Upvotes: 2
Related Questions
- sql deleting multiple rows of different columns
- How to delete the same table fields with an sql query
- How to delete a certain value from columns in mysql
- MYSQL Delete multiple or single row from different columns
- MySql delete from select with multiple column?
- SQL statement to delete multiple fields in a table MYSQL
- MySQL: How to make select and delete in the same table in single query?
- how delete from two table?
- MySQL delete from 2 tables with one query
- delete 2 rows 1 Sql statement mysql