· 8 years ago · Dec 14, 2017, 12:02 PM
1CREATE TABLE IF NOT EXISTS `users` (
2 `id` int(11) NOT NULL AUTO_INCREMENT,
3 `username` varchar(250) NOT NULL,
4 `password` varchar(250) NOT NULL,
5 `NoRoc` varchar(10) NOT NULL,
6 PRIMARY KEY (`id`)
7) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=9 ;
8
9--
10-- Dumping data for table `users`
11--
12
13INSERT INTO `users` (`id`, `username`, `password`,`NoRoc`) VALUES
14(1, 'mike', '5f4dcc3b5aa765d61d8327deb882cf99','ssm001');