· 9 years ago · Apr 03, 2017, 07:40 PM
1CREATE TABLE IF NOT EXISTS `users` (
2`id` int(11) NOT NULL,
3 `full_name` varchar(255) NOT NULL,
4 `user_name` varchar(255) NOT NULL,
5 `email` varchar(100) NOT NULL
6) ENGINE=InnoDB AUTO_INCREMENT=6 DEFAULT CHARSET=utf8;
7
8INSERT INTO `users` (`id`, `full_name`, `user_name`, `email`) VALUES
9(1, 'Sam Ben', 'samben', 'samben@gmail.com'),
10(2, 'Ofani Dariyan', 'ofani', 'ofanidariyan@hotmail.com'),
11(3, 'Toni Stark', 'toni', 'tonistark@hotmail.com'),
12(4, 'Mrs Valak', 'valak', 'valak@conjuring.com'),
13(5, 'Iron Wine', 'iron', 'iron@wine.com');