Pmner4aA

1-- phpMyAdmin SQL Dump
2-- version 4.4.3
3-- http://www.phpmyadmin.net
4--
5-- Host: localhost
6-- Generation Time: Dec 01, 2018 at 05:55 AM
7-- Server version: 5.6.24
8-- PHP Version: 5.6.8
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: `belajar_nonreg`
21--
22
23-- --------------------------------------------------------
24
25--
26-- Table structure for table `mahasiswa`
27--
28
29CREATE TABLE IF NOT EXISTS `mahasiswa` (
30  `nim` varchar(20) NOT NULL,
31  `nama` varchar(200) NOT NULL,
32  `alamat` varchar(500) NOT NULL
33) ENGINE=InnoDB DEFAULT CHARSET=latin1;
34
35--
36-- Dumping data for table `mahasiswa`
37--
38
39INSERT INTO `mahasiswa` (`nim`, `nama`, `alamat`) VALUES
40('12040713', 'budi saputra', 'Banjarmasin'),
41('13040714', 'Nisa Munajat', 'Banjarmasin');
42
43--
44-- Indexes for dumped tables
45--
46
47--
48-- Indexes for table `mahasiswa`
49--
50ALTER TABLE `mahasiswa`
51  ADD PRIMARY KEY (`nim`);
52
53/*!40101 SET CHARACTER_SET_CLIENT=@OLD_CHARACTER_SET_CLIENT */;
54/*!40101 SET CHARACTER_SET_RESULTS=@OLD_CHARACTER_SET_RESULTS */;
55/*!40101 SET COLLATION_CONNECTION=@OLD_COLLATION_CONNECTION */;