9Xkhs67v

1CREATE TABLE IF NOT EXISTS `user` (
2  `id` int(11) NOT NULL AUTO_INCREMENT,
3  `nama` varchar(50) NOT NULL,
4  `alamat` text NOT NULL,
5  `pekerjaan` varchar(50) NOT NULL,
6  PRIMARY KEY (`id`)
7) ENGINE=InnoDB  DEFAULT CHARSET=latin1 AUTO_INCREMENT=3 ;
8 
9--
10-- Dumping data for table `user`
11--
12 
13INSERT INTO `user` (`id`, `nama`, `alamat`, `pekerjaan`) VALUES
14(1, 'Andi', 'Surabaya', 'web programmer'),
15(2, 'Budi', 'Bandung', 'Web Designer');