· 9 years ago · Nov 24, 2016, 02:54 AM
1-- phpMyAdmin SQL Dump
2-- version 3.1.3.1
3-- http://www.phpmyadmin.net
4--
5-- Host: localhost
6-- Generation Time: Nov 24, 2016 at 09:48 AM
7-- Server version: 5.1.33
8-- PHP Version: 5.2.9
9
10SET SQL_MODE="NO_AUTO_VALUE_ON_ZERO";
11
12--
13-- Database: `rs2`
14--
15
16-- --------------------------------------------------------
17
18--
19-- Table structure for table `data`
20--
21
22CREATE TABLE IF NOT EXISTS `data` (
23 `id` int(11) NOT NULL AUTO_INCREMENT,
24 `nama` varchar(20) NOT NULL,
25 `jumlah` int(11) NOT NULL,
26 PRIMARY KEY (`id`)
27) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=6 ;
28
29--
30-- Dumping data for table `data`
31--
32
33INSERT INTO `data` (`id`, `nama`, `jumlah`) VALUES
34(1, 'buku', 10),
35(2, 'tas', 5),
36(3, 'pensil', 10),
37(4, 'penggaris', 3),
38(5, 'penghapus', 10);