Advertisement
Bedhoel

Untitled

Sep 7th, 2018
112
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
MySQL 0.44 KB | None | 0 0
  1. CREATE 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.  
  13. INSERT INTO `user` (`id`, `nama`, `alamat`, `pekerjaan`) VALUES
  14. (1, 'Andi', 'Surabaya', 'web programmer'),
  15. (2, 'Budi', 'Bandung', 'Web Designer');
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement