langsung aja pake contoh ya:
ALTER TABLE thotnews_bts
ADD COLUMN `pln_state` VARCHAR(15) DEFAULT NULL AFTER last_updated,
ADD COLUMN `id_pln` TEXT AFTER pln_state,
ADD COLUMN `power_status` VARCHAR(15) DEFAULT NULL AFTER id_pln,
ADD COLUMN `power_capacity` TEXT AFTER power_status,
ADD COLUMN `external_alarm` VARCHAR(15) DEFAULT NULL AFTER power_capacity,
ADD COLUMN `battery_backup` VARCHAR(15) DEFAULT NULL AFTER external_alarm,
ADD COLUMN `battery_capacity` TEXT AFTER battery_backup
kata kunci di sini adalah 'add column' dan 'after' soalnya kalo cuma pake keyword 'add' setelah nama table, hasilnya akan error
No comments:
Post a Comment