· 9 years ago · Nov 01, 2016, 04:24 PM
1-- phpMyAdmin SQL Dump
2-- version 4.4.12
3-- http://www.phpmyadmin.net
4--
5-- Host: 127.0.0.1
6-- Generation Time: Nov 01, 2016 at 05:18 PM
7-- Server version: 5.6.25
8-- PHP Version: 5.6.11
9
10SET SQL_MODE = "NO_AUTO_VALUE_ON_ZERO";
11SET time_zone = "+00:00";
12
13
14/*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */;
15/*!40101 SET @OLD_CHARACTER_SET_RESULTS=@@CHARACTER_SET_RESULTS */;
16/*!40101 SET @OLD_COLLATION_CONNECTION=@@COLLATION_CONNECTION */;
17/*!40101 SET NAMES utf8mb4 */;
18
19--
20-- Database: `crud_oop`
21--
22
23-- --------------------------------------------------------
24
25--
26-- Table structure for table `mahasiswa`
27--
28
29CREATE TABLE IF NOT EXISTS `mahasiswa` (
30 `id` int(11) NOT NULL,
31 `nim` varchar(20) NOT NULL,
32 `nama` varchar(30) NOT NULL,
33 `tempat_lahir` varchar(30) NOT NULL,
34 `tanggal_lahir` date NOT NULL,
35 `jenis_kelamin` enum('Laki-laki','Perempuan') NOT NULL,
36 `agama` varchar(20) NOT NULL,
37 `alamat` varchar(100) NOT NULL,
38 `no_telepon` varchar(12) NOT NULL
39) ENGINE=InnoDB AUTO_INCREMENT=12 DEFAULT CHARSET=latin1;
40
41--
42-- Dumping data for table `mahasiswa`
43--
44
45INSERT INTO `mahasiswa` (`id`, `nim`, `nama`, `tempat_lahir`, `tanggal_lahir`, `jenis_kelamin`, `agama`, `alamat`, `no_telepon`) VALUES
46(1, '16001', 'Danang Kusuma', 'Bandar Lampung', '1990-02-01', 'Laki-laki', 'Islam', 'Jalan Gatot Subroto No. 10, Bandar Lampung', '085758857775'),
47(2, '16002', 'Isyana Sarasvati', 'Jakarta', '1993-05-02', 'Perempuan', 'Islam', 'Jalan Pagar Alam No. 15, Kedaton, Bandar Lampung', '085789892909'),
48(3, '16003', 'Indra Styawantoro', 'Purbolinggo', '1991-05-15', 'Laki-laki', 'Islam', 'Perum Griya Gedung Meneng Blok C2 No. 2, Rajabasa, Bandar Lampung', '085669919769'),
49(4, '16004', 'Maudy Ayunda', 'Jakarta', '1994-12-19', 'Perempuan', 'Islam', 'Jalan Radin Intan No. 77, Tanjung Karang, Bandar Lampung', '089977955772'),
50(5, '16005', 'Valentino Rossi', 'Metro', '1979-03-16', 'Laki-laki', 'Islam', 'Jalan Zaenal Abidin Pagaralam No. 1, Bandar Lampung', '081922919212'),
51(6, '16006', 'Raisa Andriana', 'Jakarta', '1990-06-06', 'Perempuan', 'Islam', 'Jalan Yos Sudarso No. 135, Bandar Lampung', '081388955767'),
52(7, '16007', 'Cristiano Ronaldo', 'Teluk Betung', '1986-02-25', 'Laki-laki', 'Islam', 'Jalan Teuku Umar No. 52, Kedaton Bandar Lampung', '081269962201'),
53(8, '16008', 'M Muzaqi', '', '0000-00-00', '', '', '', ''),
54(9, '099023022', 'Nia Ramadhani', 'Jakarta', '1996-02-01', 'Perempuan', 'Islam', 'Cengkareng Barat', '12345678'),
55(10, '109209381', 'Frienly Faisal', '', '0000-00-00', 'Laki-laki', '', '', ''),
56(11, '14090013', 'rizal', 'tegal', '0000-00-00', 'Laki-laki', 'islam', 'ds. bangun galih', '085786652577');
57
58--
59-- Indexes for dumped tables
60--
61
62--
63-- Indexes for table `mahasiswa`
64--
65ALTER TABLE `mahasiswa`
66 ADD PRIMARY KEY (`id`);
67
68--
69-- AUTO_INCREMENT for dumped tables
70--
71
72--
73-- AUTO_INCREMENT for table `mahasiswa`
74--
75ALTER TABLE `mahasiswa`
76 MODIFY `id` int(11) NOT NULL AUTO_INCREMENT,AUTO_INCREMENT=12;
77/*!40101 SET CHARACTER_SET_CLIENT=@OLD_CHARACTER_SET_CLIENT */;
78/*!40101 SET CHARACTER_SET_RESULTS=@OLD_CHARACTER_SET_RESULTS */;
79/*!40101 SET COLLATION_CONNECTION=@OLD_COLLATION_CONNECTION */;