BbtwzaHz

1CREATE TABLE IF NOT EXISTS `mahasiswa` (
2  `id_mahasiswa` int(50) NOT NULL AUTO_INCREMENT,
3  `nama` text COLLATE latin1_general_ci NOT NULL,
4  `jenis_kelamin` text COLLATE latin1_general_ci NOT NULL,
5  `alamat` text COLLATE latin1_general_ci NOT NULL,
6  `telepon` text COLLATE latin1_general_ci NOT NULL,
7  PRIMARY KEY (`id_mahasiswa`)
8) ENGINE=MyISAM  DEFAULT CHARSET=latin1 COLLATE=latin1_general_ci AUTO_INCREMENT=100001 ;