· 7 years ago · Feb 21, 2019, 05:24 PM
1CREATE TABLE IF NOT EXISTS `siswa` (
2`id_siswa` int(4) NOT NULL,
3 `nama_siswa` varchar(50) NOT NULL,
4 `usia_siswa` varchar(5) NOT NULL ,
5 `kelas_siswa` varchar(4) NOT NULL
6) ENGINE=InnoDB DEFAULT CHARSET=latin1 AUTO_INCREMENT=1 ;
7
8ALTER TABLE `siswa`
9 ADD PRIMARY KEY (`id_siswa`);
10
11ALTER TABLE `siswa`
12MODIFY `id_siswa` int(4) NOT NULL AUTO_INCREMENT;