· 8 years ago · May 25, 2018, 07:30 AM
1
2CREATE TABLE IF NOT EXISTS `mahasiswa` (
3 `id_mahasiswa` int(50) NOT NULL AUTO_INCREMENT,
4 `nama` text COLLATE latin1_general_ci NOT NULL,
5 `jenis_kelamin` text COLLATE latin1_general_ci NOT NULL,
6 `alamat` text COLLATE latin1_general_ci NOT NULL,
7 `telepon` text COLLATE latin1_general_ci NOT NULL,
8 PRIMARY KEY (`id_mahasiswa`)
9) ENGINE=MyISAM DEFAULT CHARSET=latin1 COLLATE=latin1_general_ci AUTO_INCREMENT=100001 ;