jHr098AT

1-- phpMyAdmin SQL Dump
2-- version 4.2.11
3-- http://www.phpmyadmin.net
4--
5-- Host: 127.0.0.1
6-- Generation Time: 26 Agu 2017 pada 07.47
7-- Versi Server: 5.6.21
8-- PHP Version: 5.6.3
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 utf8 */;
18
19--
20-- Database: `mahasiswa_db`
21--
22
23-- --------------------------------------------------------
24
25--
26-- Struktur dari tabel `mahasiswa`
27--
28
29CREATE TABLE IF NOT EXISTS `mahasiswa` (
30  `nim` int(11) NOT NULL,
31  `nama` varchar(50) NOT NULL,
32  `alamat` varchar(50) NOT NULL,
33  `telp` varchar(15) NOT NULL
34) ENGINE=InnoDB DEFAULT CHARSET=latin1;
35
36--
37-- Dumping data untuk tabel `mahasiswa`
38--
39
40INSERT INTO `mahasiswa` (`nim`, `nama`, `alamat`, `telp`) VALUES
41(1104411195, 'ALI AKBAR', 'PALOPO', '085396244441'),
42(1104411196, 'SULKIFLI', 'PALOPO', '098776336663'),
43(1104411198, 'SAINAL', 'KALIMANTAN', '085396234234'),
44(1104411209, 'HAMSIR ADI', 'MASAMBA', '081228111112');
45
46--
47-- Indexes for dumped tables
48--
49
50--
51-- Indexes for table `mahasiswa`
52--
53ALTER TABLE `mahasiswa`
54 ADD PRIMARY KEY (`nim`);
55
56/*!40101 SET CHARACTER_SET_CLIENT=@OLD_CHARACTER_SET_CLIENT */;
57/*!40101 SET CHARACTER_SET_RESULTS=@OLD_CHARACTER_SET_RESULTS */;
58/*!40101 SET COLLATION_CONNECTION=@OLD_COLLATION_CONNECTION */;