· 6 years ago · May 15, 2019, 12:18 PM
1CREATE TABLE IF NOT EXISTS `characters` (
2 `id` int(11) NOT NULL AUTO_INCREMENT,
3 `name` varchar(50) NOT NULL,
4 `family` varchar(50) NOT NULL DEFAULT '',
5 `attack` varchar(50) NOT NULL DEFAULT '',
6 PRIMARY KEY (`id`)
7) ENGINE=InnoDB DEFAULT CHARSET=latin1 AUTO_INCREMENT=6 ;
8
9--
10-- Creating data for table `characters`
11--
12
13INSERT INTO `characters` (`id`, `name`, `family`, `attack`) VALUES
14(1, 'Goku', 'Son', 'Kamehameha, Dragon Fist'),
15(2, 'Vegeta', 'Vegeta', 'Final Flash, Galick Gun'),
16(3, 'Gohan', 'Son', 'Kamehameha'),
17(4, 'Krillian', 'Krillian', 'Kamehameha, Distructo Disk'),
18(5, 'Piccalo', 'Namekian', 'Special Beam Canon');