· 9 years ago · Nov 03, 2016, 12:04 AM
1-- phpMyAdmin SQL Dump
2-- version 4.5.1
3-- http://www.phpmyadmin.net
4--
5-- Host: 127.0.0.1
6-- Generation Time: Oct 18, 2016 at 08:38 AM
7-- Server version: 10.1.10-MariaDB
8-- PHP Version: 5.6.19
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
29DROP TABLE IF EXISTS `mahasiswa`;
30CREATE TABLE `mahasiswa` (
31 `id` int(11) NOT NULL,
32 `nim` varchar(20) NOT NULL,
33 `nama` varchar(30) NOT NULL,
34 `tempat_lahir` varchar(30) NOT NULL,
35 `tanggal_lahir` date NOT NULL,
36 `jenis_kelamin` enum('Laki-laki','Perempuan') NOT NULL,
37 `agama` varchar(20) NOT NULL,
38 `alamat` varchar(100) NOT NULL,
39 `no_telepon` varchar(12) NOT NULL
40) ENGINE=InnoDB DEFAULT CHARSET=latin1;
41
42--
43-- Dumping data for table `mahasiswa`
44--
45
46INSERT INTO `mahasiswa` (`id`, `nim`, `nama`, `tempat_lahir`, `tanggal_lahir`, `jenis_kelamin`, `agama`, `alamat`, `no_telepon`) VALUES
47(1, '16001', 'Danang Kusuma', 'Bandar Lampung', '1990-02-01', 'Laki-laki', 'Islam', 'Jalan Gatot Subroto No. 10, Bandar Lampung', '085758857775'),
48(2, '16002', 'Isyana Sarasvati', 'Jakarta', '1993-05-02', 'Perempuan', 'Islam', 'Jalan Pagar Alam No. 15, Kedaton, Bandar Lampung', '085789892909'),
49(3, '16003', 'Indra Styawantoro', 'Purbolinggo', '1991-05-15', 'Laki-laki', 'Islam', 'Perum Griya Gedung Meneng Blok C2 No. 2, Rajabasa, Bandar Lampung', '085669919769'),
50(4, '16004', 'Maudy Ayunda', 'Jakarta', '1994-12-19', 'Perempuan', 'Islam', 'Jalan Radin Intan No. 77, Tanjung Karang, Bandar Lampung', '089977955772'),
51(5, '16005', 'Valentino Rossi', 'Metro', '1979-03-16', 'Laki-laki', 'Islam', 'Jalan Zaenal Abidin Pagaralam No. 1, Bandar Lampung', '081922919212'),
52(6, '16006', 'Raisa Andriana', 'Jakarta', '1990-06-06', 'Perempuan', 'Islam', 'Jalan Yos Sudarso No. 135, Bandar Lampung', '081388955767'),
53(7, '16007', 'Cristiano Ronaldo', 'Teluk Betung', '1986-02-25', 'Laki-laki', 'Islam', 'Jalan Teuku Umar No. 52, Kedaton Bandar Lampung', '081269962201'),
54(8, '16008', 'M Muzaqi', '', '0000-00-00', '', '', '', ''),
55(9, '099023022', 'Nia Ramadhani', 'Jakarta', '1996-02-01', 'Perempuan', 'Islam', 'Cengkareng Barat', '12345678'),
56(10, '109209381', 'Frienly Faisal', '', '0000-00-00', 'Laki-laki', '', '', '');
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=11;
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 */;