· 7 years ago · Nov 10, 2018, 04:54 AM
1CREATE TABLE IF NOT EXISTS `mahasiswa` (
2 `nim` int(8) NOT NULL AUTO_INCREMENT,
3 `nama` varchar(65) NOT NULL,
4 `alamat` text NOT NULL,
5 `jurusan` varchar(50) NOT NULL,
6 PRIMARY KEY (`nim`)
7) ENGINE=InnoDB DEFAULT CHARSET=latin1 AUTO_INCREMENT=3 ;
8
9INSERT INTO `mahasiswa` (`nim`, `nama`, `alamat`, `jurusan`) VALUES
10(17523128, 'Hirzin F', 'Jogja', 'Teknik Informatika');