· 8 years ago · Jan 21, 2018, 03:32 AM
1DROP TABLE IF EXISTS superheroes;
2
3CREATE =TABLE superheroes (
4 id int(11) NOT NULL AUTO_INCREMENT,
5 name varchar(50) NOT NULL,
6 alter_ego varchar(50) DEFAULT NULL,
7 power varchar(50) DEFAULT NULL,
8 arch_nemesis varchar(30) DEFAULT NULL,
9 PRIMARY KEY (id)
10);
11
12INSERT INTO superheroes (name,alter_ego,power, arch_nemesis) VALUES ('SpiderMan', 'Peter Parker', 'spidey skills','Green Goblin');
13INSERT INTO superheroes (name,alter_ego,power, arch_nemesis) VALUES ('Superman', 'Clark Kent', 'flyin,laser vision,super strength','DoomsDay');
14INSERT INTO superheroes (name,alter_ego,power, arch_nemesis) VALUES ('Batman', 'Bruce Wayne', 'saving Gotham','Joker');
15INSERT INTO superheroes (name,alter_ego,power, arch_nemesis) VALUES ('THOR', 'null', 'hammer time', 'Loki');
16INSERT INTO superheroes (name,alter_ego,power, arch_nemesis) VALUES ('Hulk', 'Bruce Banner', 'rage strength', 'himself');
17INSERT INTO superheroes (name,alter_ego,power, arch_nemesis) VALUES ('Flash', 'Barry Allen', 'super speed', 'Professor Zoom');
18INSERT INTO superheroes (name,alter_ego,power, arch_nemesis) VALUES ('Mister Fantastic', 'Reed Richards', 'flies', 'Lex Luther');