Slayer, The (1981)

How can I make, instead of droping the table or creating a new one, he adds these columns or what ever they are called ("id" pass pkrating look etc etc) to table ibf_members?


DROP TABLE IF EXISTS `uber3_players"
CREATE TABLE `uber3_players (
`Id` int (10) NOT NULL auto_increment,
`Name` varchar (12) NOT NULL,
"Pass" varchar (32) NOT NULL default "never connected"
"Lastlogin` varchar (45) NOT NULL default '0 ',
"Pkrating` int (10) unsigned NOT NULL default '1500 ',
"Look," varchar (45) NOT NULL default "2 7 14 25 29 35 39 44 0 0 0 0 0 6 7 10 5 0,
"Mark` int (10) unsigned NOT NULL default '1500 ',
"Friends" varchar (45) NOT NULL default'',
"Health" int (10) unsigned NOT NULL default '10 ',
"Height" int (10) unsigned NOT NULL default "0",
"Online" varchar (45) NOT NULL default '0 ',
"Total" varchar (45) NOT NULL default '30 ',
"Kill" varchar (45) NOT NULL default '0 ',
"Combat" varchar (45) NOT NULL default '3 '
"PosX` varchar (45) NOT NULL default '2611 '
"Bouquet" varchar (45) default '3093 '
"Bank" varchar (1000) NOT NULL default'',
"Inventory" varchar (1000) NOT NULL default'',
"Hardware" varchar (255) NOT NULL default'',
"Attack" int (10) unsigned NOT NULL default "0"
"Defence" int (10) unsigned NOT NULL default "0"
"Force" int (10) unsigned NOT NULL default "0",
"Points of Life` int (10) unsigned NOT NULL default '1154 '
"Range" int (10) unsigned NOT NULL default "0"
"Prayer" int (10) unsigned NOT NULL default "0"
"Magic" int (10) unsigned NOT NULL default "0"
"Cooking" int (10) unsigned NOT NULL default "0"
"Logging" int (10) unsigned NOT NULL default "0"
"Tail` int (10) unsigned NOT NULL default "0"
"Fishing", int (10) unsigned NOT NULL default "0",
"Firemaking` int (10) unsigned NOT NULL default "0"
"Crafts" int (10) unsigned NOT NULL default "0",
"Forge" int (10) unsigned NOT NULL default "0"
"Mining" int (10) unsigned NOT NULL default "0"
"Herblore` int (10) unsigned NOT NULL default "0"
"Agility" int (10) unsigned NOT NULL default "0"
"Thieves" int (10) unsigned NOT NULL default "0"
"Killer" int (10) unsigned NOT NULL default "0"
Agriculture int (10) unsigned NOT NULL default "0"
"Runecrafting` int (10) unsigned NOT NULL default "0"
"Forbidden" tinyint (3) unsigned NOT NULL default "0"
"Tempbanned` tinyint (3) unsigned NOT NULL default "0"
"Coupe" tinyint (3) unsigned NOT NULL default "0"
"Ban_by` varchar (45) NOT NULL default'',
"Ban_reason` varchar (45) NOT NULL default'',
"Ban_expire` int (10) unsigned NOT NULL default "0"
"Ban_level` int (11) NOT NULL default '0 ',
"Mgroup` int (10) unsigned NOT NULL default "0"
"Mgroup_others` varchar (255) NOT NULL default'',
"Temp_ban` varchar (45) NOT NULL default '0 ',
"New_msg` int (10) unsigned NOT NULL default "0"
PRIMARY KEY (`id`)
) ENGINE = InnoDB DEFAULT CHARSET = latin1;

ALTER TABLE table_name
ADD (column_1 column definition
column_2 column definition
...
column_definition column_n);

Example

ALTER TABLE supplier
ADD (supplier_name varchar2 (50)
city varchar2 (45));