cdVza7N6

1CREATE TABLE IF NOT EXISTS `daftar_paket` (
2  `id` int(5) NOT NULL,
3  `kode_paket` varchar(4) NOT NULL,
4  `nama_paket` varchar(20) NOT NULL,
5  `harga` int(10) NOT NULL,
6  `keterangan` varchar(40) NOT NULL,
7  `jadwal` varchar(20) NOT NULL,
8  `pengajar` varchar(10) NOT NULL
9) ENGINE=InnoDB DEFAULT CHARSET=utf8;
10
11INSERT INTO `daftar_paket` (`id`, `kode_paket`, `nama_paket`, `harga`, `keterangan`, `jadwal`, `pengajar`) VALUES
12(1, 'A001', 'Bash Scripting', 50000, 'Bash Scripting Pengenalan dan Dasar', 'Senin-Rabu', 'Gorgom'),
13(2, 'A002', 'PHP MySQL', 75000, 'Belajar PHP sampai mahir', 'Kamis-Jumat', 'Gorgom'),
14(3, 'A003', 'NodeJS', 100000, 'Belajar NodeJS sampai jago', 'Sabtu-Minggu', 'Gorgom'),
15(4, 'A004', 'Python', 125000, 'Belajar Python sampai handal', 'Selasa-Kamis', 'Gorgom'),
16(5, 'A005', 'Go', 115000, 'Belajar Go sampai jumpa', 'Rabu-Jumat', 'Gorgom');
17
18ALTER TABLE `daftar_paket`
19  ADD PRIMARY KEY (`id`);
20
21ALTER TABLE `daftar_paket`
22MODIFY `id` int(5) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=6;