Tuesday, September 2, 2014

Lesson 13: Add multiple column in table using mysql

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