9GikHGpc

1
2CREATE TABLE IF NOT EXISTS `users` (
3 `id` int(11) NOT NULL AUTO_INCREMENT,
4 `name` varchar(128),
5 `email` varchar(128) NOT NULL,
6 `password` varchar(128) NOT NULL,
7 PRIMARY KEY (`id`)
8) ENGINE=InnoDB  DEFAULT CHARSET=latin1;
9
10INSERT INTO `users` (`id`, `name`, `email`, `password`) VALUES
11(1, 'testowy', 'testowy@email.com', 'test123'),
12(2, 'testowy2', 'testowy2@email.com', 'test123');
13
14INSERT INTO `users` (`id`, `name`, `email`, `password`) VALUES
15(3, NULL, 'testowy@email.com', 'test123');
16
17ALTER TABLE `users` ADD `created_at` date;
18
19DELETE FROM `users` WHERE id=3;
20
21UPDATE `users` SET name='nowy' WHERE id=1;