ygz38yJ1

1CREATE DATABASE IF NOT EXISTS `latihan` DEFAULT CHARACTER SET latin1 COLLATE latin1_swedish_ci;
2USE `latihan`;
3
4DROP TABLE IF EXISTS `mahasiswa`;
5CREATE TABLE `mahasiswa` (
6`nim` char(10) NOT NULL PRIMARY KEY,
7`nama` varchar(50) NOT NULL,
8`jenis_kelamin` enum('Laki-laki','Perempuan') NOT NULL,
9`alamat` text NULL
10) ENGINE=InnoDB DEFAULT CHARSET=latin1;