· 9 years ago · Nov 24, 2016, 03:56 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 10:54 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 `harga` int(11) NOT NULL,
26 `jumlah` int(11) NOT NULL,
27 PRIMARY KEY (`id`)
28) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=6 ;
29
30--
31-- Dumping data for table `data`
32--
33
34INSERT INTO `data` (`id`, `nama`, `harga`, `jumlah`) VALUES
35(1, 'buku', 5000, 2),
36(2, 'tas', 1500, 2),
37(3, 'pensil', 1000, 10),
38(4, 'penggaris', 2000, 5),
39(5, 'penghapus', 3000, 3);