· 9 years ago · Jan 21, 2017, 03:40 AM
1-- phpMyAdmin SQL Dump
2-- version 4.1.6
3-- http://www.phpmyadmin.net
4--
5-- Host: 127.0.0.1
6-- Generation Time: 21 Jan 2017 pada 04.35
7-- Versi Server: 5.6.16
8-- PHP Version: 5.5.9
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_db`
21--
22
23-- --------------------------------------------------------
24
25--
26-- Struktur dari tabel `tabel_saya`
27--
28
29CREATE TABLE IF NOT EXISTS `tabel_saya` (
30 `nim` int(8) NOT NULL AUTO_INCREMENT,
31 `nama` varchar(25) NOT NULL,
32 `Alamat` text NOT NULL,
33 `no_telepon` decimal(12,0) NOT NULL,
34 `foto` varchar(30) NOT NULL,
35 PRIMARY KEY (`nim`)
36) ENGINE=InnoDB DEFAULT CHARSET=utf8 AUTO_INCREMENT=10410574 ;
37
38--
39-- Dumping data untuk tabel `tabel_saya`
40--
41
42INSERT INTO `tabel_saya` (`nim`, `nama`, `Alamat`, `no_telepon`, `foto`) VALUES
43(10410511, 'Dandi', 'Jakarta', '8566567487', ''),
44(10410517, 'Halfawi', 'Bogor', '8577567487', ''),
45(10410573, 'Lusi', 'Tangerang', '2134543222', '');
46
47/*!40101 SET CHARACTER_SET_CLIENT=@OLD_CHARACTER_SET_CLIENT */;
48/*!40101 SET CHARACTER_SET_RESULTS=@OLD_CHARACTER_SET_RESULTS */;
49/*!40101 SET COLLATION_CONNECTION=@OLD_COLLATION_CONNECTION */;