mysql drop multiple columns single alter table

mysql drop multiple columns single alter table | java php laravel linux mysql sql bootstrap html css query java php laravel linux mysql sql bootstrap html css query: mysql drop multiple columns single alter table

Rabu, 20 November 2019

mysql drop multiple columns single alter table

Drop Multiple Columns on Mysql

Struktur table configurations

id bigint(20) unsigned
kode varchar(10)
nilai varchar(50)
created_by_user bigint(20)
modified_by_user bigint(20)
created_at timestamp
updated_at timestamp

Kolom created_by_user dan kolom modified_by_user akan dihapus menggunakan perintah alter,

perintahnya adalah :
alter table configs drop column created_by_user, drop column modified_by_user