qaTzBpbz

1CREATE TABLE IF NOT EXISTS `siswa` (
2  `nis` varchar(12) NOT NULL,
3  `nama` varchar(50) NOT NULL,
4  `id_jenisklm` varchar(2) NOT NULL,
5  `id_kelas` varchar(5) NOT NULL,
6  `tmp_lahir` varchar(50) NOT NULL,
7  `tgl_lahir` date NOT NULL,
8  `foto` varchar(100) NOT NULL,
9  `alamat` text NOT NULL,
10  `no_telpon` varchar(12) NOT NULL,
11  `id_jurusan` varchar(4) NOT NULL,
12  `email` varchar(50) NOT NULL,
13  `username` varchar(30) NOT NULL,
14  `password` varchar(30) NOT NULL,
15  `level` varchar(10) NOT NULL,
16  PRIMARY KEY (`nis`)
17) ENGINE=MyISAM DEFAULT CHARSET=latin1;
18
19INSERT INTO `siswa` (`nis`, `nama`, `id_jenisklm`, `id_kelas`, `tmp_lahir`, `tgl_lahir`, `foto`, `alamat`, `no_telpon`, `id_jurusan`, `email`, `username`, `password`, `level`) VALUES
20('RSA1C116008', 'ALDI JONATA PRATAMA', 'L', '2019', 'BANGKO', '0000-00-00', '', 'MENDALO DARAT', '0812', 'KIM', 'aldi@mail.com', 'aldi', 'aldi', 'siswa');