· 9 years ago · Oct 20, 2016, 09:40 AM
1CREATE TABLE IF NOT EXISTS `mahasiswa` (
2 `Nim` varchar(9) NOT NULL,
3 `Nama_Mhs` varchar(25) NOT NULL,
4 `Tgl_Lahir` date NOT NULL,
5 `Alamat` varchar(50) NOT NULL,
6 `Jenis_Kelamin` enum('Pria','Wanita') NOT NULL,
7 PRIMARY KEY (`Nim`)
8) ENGINE=InnoDB DEFAULT CHARSET=utf8;