bulk_character_insert.sql

INSERT INTO `video_game_characters`
  (`id`, `name`, `bio_en`, `type`, `profession`, `console`, `is_alive`, `powerups`, `skills`, `created_on`)
VALUES 
  ('1','mario', 'It’sa him', 'hero','plumber','nes','1','3','{"magic":0, "speed":0, "strength":0, "weapons":0}', NOW()),
  ('2','luigi', 'It’sa his brother', 'hero','plumber','nes','1','5','{"magic":0, "speed":0, "strength":0, "weapons":0}', NOW()),
  ('3','sonic', 'the hedgehog', 'hero','hedgehog','sega genesis','1','0','{"magic":0, "speed":1, "strength":0, "weapons":0}', NOW()),
  ('4','earthworm jim', 'the worm that shoots', 'hero','earthworm','sega genesis','0','0','{"magic":0, "speed":0, "strength":1, "weapons":1}', NOW()),
  ('5','bowser', 'he’s bad', 'villain','evil dinosaur','nes','1','0','{"magic":0, "speed":0, "strength":1, "weapons":0}', NOW()),
  ('6','dr. robotnic', 'not as bad', 'villain','evil doctor','sega genesis','1','0','{"magic":0, "speed":0, "strength":1, "weapons":1}', NOW()),
  ('7','lakitu', 'who?', 'villain','throwing shit from clouds','nes','0','0','{"magic":0, "speed":0, "strength":0, "weapons":1}', NOW()),
  ('8','donkey kong', 'Planet of the ape', 'hero','monkey','nes','1','0','{"magic":0, "speed":0, "strength":1, "weapons":0}', NOW()),
  ('9','pikachu', 'pika-who?', 'hero','pokemon','gameboy','1','0','{"magic":1, "speed":1, "strength":0, "weapons":0}', NOW()),
  ('10','princess peach', 'Im peach', 'hero','princess','nes','1','0','{"magic":0, "speed":0, "strength":0, "weapons":0}', NOW()),
  ('11','chain chomp', 'misunderstood', 'villain','evil chain dude','nes','0','0','{"magic":0, "speed":0, "strength":1, "weapons":0}', NOW()),
  ('12','little mac', 'Big mac’s little brother', 'hero','boxer','nes','1','0','{"magic":0, "speed":0, "strength":1, "weapons":0}', NOW()),
  ('13','pac man', 'Ms Pac Man’s worse three-quarters', 'hero','yellow circle','atari','1','0','{"magic":0, "speed":0, "strength":0, "weapons":0}', NOW()),
  ('14','yoshi', 'Green machine', 'hero','dinosaur','super nintendo','1','0','{"magic":0, "speed":1, "strength":0, "weapons":0}', NOW()),
  ('15','link', 'Zelda? I hardly knew her!', 'hero','not sure','nes','1','0','{"magic":1, "speed":0, "strength":0, "weapons":1}', NOW()),
  ('16','dude', 'Duuuuuude', 'hero','sure','sega genesis','1','0','{"magic":1, "speed":0, "strength":0, "weapons":1}', '2022-01-26 00:00:00')