use latihanibatis;

-- Tabel Master 
DROP TABLE IF EXISTS `Mahasiswa`;
CREATE TABLE `Mahasiswa` (
  `NIM` INT NOT NULL PRIMARY KEY,
  `NAMA` VARCHAR(25) NULL,
  `ALAMAT` VARCHAR(50) NULL,
  `KOTA` VARCHAR(25) NULL,
  `KETER` VARCHAR(50) NULL
) ENGINE = INNODB;

INSERT INTO `Mahasiswa`(`NIM`, `NAMA`, `ALAMAT`, `KOTA`, `KETER`)
VALUES ('058001', 'SAMSUL BAKRIE', 'JL. MAYJEND SUNGKONO NO.122', 'KEDIRI', NULL),
  ('058002', 'ARIFIN MULYADI', 'JL. PANGSUD NO.55', 'BLITAR', NULL),
  ('058003', 'SHANTI OKTAVIANI', 'JL. YOS SUDARSO NO.12', 'PARE', NULL),
  ('058004', 'RUDI HARYONO', 'JL. PATTIMURA NO.22', 'TULUNGAGUNG', NULL),
  ('058006', 'IWAN SETIONO', 'JL. NGAGEL JAYA TENGAH NO.123', 'SURABAYA', NULL),
  ('058007', 'RATNA SETYONINGSIH', 'JL. BANJAR MELATI No.2', 'PASURUAN', NULL);