Skip to content

Instantly share code, notes, and snippets.

@celsowm
Created June 19, 2019 01:29
Show Gist options
  • Save celsowm/82cace3ae81fdaf653a3e944007892bc to your computer and use it in GitHub Desktop.
Save celsowm/82cace3ae81fdaf653a3e944007892bc to your computer and use it in GitHub Desktop.
DROP TABLE IF EXISTS `log`;
CREATE TABLE IF NOT EXISTS `log` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`dados` text NOT NULL,
PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=11 DEFAULT CHARSET=latin1;
--
-- Extraindo dados da tabela `log`
--
INSERT INTO `log` (`id`, `dados`) VALUES
(9, 'C:3:\"Log\":174:{a:2:{s:2:\"id\";i:1;s:5:\"dados\";a:3:{s:7:\"usuario\";s:5:\"maria\";s:6:\"metodo\";s:12:\"incluirLivro\";s:10:\"parametros\";a:2:{s:5:\"preco\";d:7.99;s:6:\"titulo\";s:14:\"Livro de Teste\";}}}}'),
(10, 'C:3:\"Log\":93:{a:2:{s:2:\"id\";i:2;s:5:\"dados\";a:2:{s:2:\"ip\";s:14:\"10.120.100.210\";s:6:\"origem\";s:5:\"CHINA\";}}}');
COMMIT;
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment