Advertisement
Guest User

Insert data

a guest
Feb 21st, 2019
216
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
  1. CREATE 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.  
  8. ALTER TABLE `siswa`
  9.  ADD PRIMARY KEY (`id_siswa`);
  10.  
  11. ALTER TABLE `siswa`
  12. MODIFY `id_siswa` int(4) NOT NULL AUTO_INCREMENT;
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement