Untuk memulai program ini terlebih dahulu kita membuat database seperti berikut:
namun sebelumnya aktipkan dahulu apache triad,mysql:
caranya :
klik prog - pilih php - start apache - mysql D-NT.
Microsoft Windows [Version 6.1.7600]
Copyright (c) 2009 Microsoft Corporation. All rights reserved.
C:\Users\MASDA>cd\
C:\>cd apache\mysql\bin
C:\apache\mysql\bin>mysql
Welcome to the MySQL monitor. Commands end with ; or \g.
Your MySQL connection id is 2 to server version: 3.23.47-nt
Type 'help;' or '\h' for help. Type '\c' to clear the buffer.
mysql> create database MASDA TOKO;
ERROR 1064: You have an error in your SQL syntax near 'TOKO' at line 1
mysql> create database TOKOMASDA;
Query OK, 1 row affected (0.00 sec)
mysql> use TOKOMASDA;
Database changed
mysql> show databases;
+--------------+
| Database |
+--------------+
| DBPenggajian |
| TOKOMASDA |
| Tugas |
| jual |
| masda |
| masdau |
| masdauli |
| mysql |
| test |
+--------------+
9 rows in set (0.00 sec)
mysql> create table produk(KdPRODUK Varchar(5),Nama varchar(50),Satuan varchar(1
0),jumlah DOUBLE);
Query OK, 0 rows affected (0.00 sec)
mysql> DESC produk;
+----------+-------------+------+-----+---------+-------+
| Field | Type | Null | Key | Default | Extra |
+----------+-------------+------+-----+---------+-------+
| KdPRODUK | varchar(5) | YES | | NULL | |
| Nama | varchar(50) | YES | | NULL | |
| Satuan | varchar(10) | YES | | NULL | |
| jumlah | double | YES | | NULL | |
+----------+-------------+------+-----+---------+-------+
4 rows in set (0.02 sec)
mysql> create table Pelanggan(KdPelanggan Varchar(5),Nama varchar(50),Alamat var
char(80),telp varchar(15));
Query OK, 0 rows affected (0.00 sec)
mysql> desc pelanggan;
+-------------+-------------+------+-----+---------+-------+
| Field | Type | Null | Key | Default | Extra |
+-------------+-------------+------+-----+---------+-------+
| KdPelanggan | varchar(5) | YES | | NULL | |
| Nama | varchar(50) | YES | | NULL | |
| Alamat | varchar(80) | YES | | NULL | |
| telp | varchar(15) | YES | | NULL | |
+-------------+-------------+------+-----+---------+-------+
4 rows in set (0.00 sec)
mysql> create table Penjualan(NoBukti Varchar(5),Tanggal date,KdPelanggan varcha
r(5),KdProduk varchar(5),jumlah double);
Query OK, 0 rows affected (0.00 sec)
mysql> desc penjualan;
+-------------+------------+------+-----+---------+-------+
| Field | Type | Null | Key | Default | Extra |
+-------------+------------+------+-----+---------+-------+
| NoBukti | varchar(5) | YES | | NULL | |
| Tanggal | date | YES | | NULL | |
| KdPelanggan | varchar(5) | YES | | NULL | |
| KdProduk | varchar(5) | YES | | NULL | |
| jumlah | double | YES | | NULL | |
+-------------+------------+------+-----+---------+-------+
5 rows in set (0.00 sec)
mysql> insert into Produk values('M10','MEJA','BIJI','2'),('M11','KURSI','SET','
6'),('M12','BUKU','LUSIN','2'),('M13','PULPEN','LUSIN','3'),('M14','ROOL','BIJI'
,'6'),('M15','BAJU','LUSIN','1'),('M16','CELANA','LUSIN','5'),('M17','SEPATU','P
ASANG','4');
Query OK, 8 rows affected (0.00 sec)
Records: 8 Duplicates: 0 Warnings: 0
mysql> insert into Produk values('M18','LEMARI','BUAH','3'),('M19','KIPAS','BUAH
','4'),('M20','LAPTOP','BUAH','1');
Query OK, 3 rows affected (0.01 sec)
Records: 3 Duplicates: 0 Warnings: 0
mysql> select*from produk;
+----------+--------+--------+--------+
| KdPRODUK | Nama | Satuan | jumlah |
+----------+--------+--------+--------+
| M10 | MEJA | BIJI | 2 |
| M11 | KURSI | SET | 6 |
| M12 | BUKU | LUSIN | 2 |
| M13 | PULPEN | LUSIN | 3 |
| M14 | ROOL | BIJI | 6 |
| M15 | BAJU | LUSIN | 1 |
| M16 | CELANA | LUSIN | 5 |
| M17 | SEPATU | PASANG | 4 |
| M18 | LEMARI | BUAH | 3 |
| M19 | KIPAS | BUAH | 4 |
| M20 | LAPTOP | BUAH | 1 |
+----------+--------+--------+--------+
11 rows in set (0.00 sec)
mysql> desc penjualan;
+-------------+------------+------+-----+---------+-------+
| Field | Type | Null | Key | Default | Extra |
+-------------+------------+------+-----+---------+-------+
| NoBukti | varchar(5) | YES | | NULL | |
| Tanggal | date | YES | | NULL | |
| KdPelanggan | varchar(5) | YES | | NULL | |
| KdProduk | varchar(5) | YES | | NULL | |
| jumlah | double | YES | | NULL | |
+-------------+------------+------+-----+---------+-------+
5 rows in set (0.02 sec)
mysql> alter table penjualan change KdProduk KdPRODUK varchar(5);
Query OK, 0 rows affected (0.03 sec)
Records: 0 Duplicates: 0 Warnings: 0
mysql> desc penjualan;
+-------------+------------+------+-----+---------+-------+
| Field | Type | Null | Key | Default | Extra |
+-------------+------------+------+-----+---------+-------+
| NoBukti | varchar(5) | YES | | NULL | |
| Tanggal | date | YES | | NULL | |
| KdPelanggan | varchar(5) | YES | | NULL | |
| KdPRODUK | varchar(5) | YES | | NULL | |
| jumlah | double | YES | | NULL | |
+-------------+------------+------+-----+---------+-------+
5 rows in set (0.00 sec)
mysql> insert into pelanggan values('D1','MASDAULI','AMPLAS','082168875508'),('D
2','SUSI','AMPLAS','0821688XXX'),('D3','NURSANAH','AMPLAS','082168XXX'),('D4','S
ONIA','PAKAM','08527572XXX'),('D5','DENNI','JL.SAUDARA','081361XXX');
Query OK, 5 rows affected (0.00 sec)
Records: 5 Duplicates: 0 Warnings: 0
mysql> insert into pelanggan values('D6','TIKA','KASIH','082165XX'),('D7','MEI',
'SAUDARA','081376XXX'),('D8','DORLIN','DELI','08371XXX'),('D9','ASEAN','DELITUA'
,'081370XXX'),('D10','IRVAN','MENTENG','082165XXX');
Query OK, 5 rows affected (0.00 sec)
Records: 5 Duplicates: 0 Warnings: 0
mysql> select*from Pelanggan;
+-------------+----------+------------+--------------+
| KdPelanggan | Nama | Alamat | telp |
+-------------+----------+------------+--------------+
| D1 | MASDAULI | AMPLAS | 082168875508 |
| D2 | SUSI | AMPLAS | 0821688XXX |
| D3 | NURSANAH | AMPLAS | 082168XXX |
| D4 | SONIA | PAKAM | 08527572XXX |
| D5 | DENNI | JL.SAUDARA | 081361XXX |
| D6 | TIKA | KASIH | 082165XX |
| D7 | MEI | SAUDARA | 081376XXX |
| D8 | DORLIN | DELI | 08371XXX |
| D9 | ASEAN | DELITUA | 081370XXX |
| D10 | IRVAN | MENTENG | 082165XXX |
+-------------+----------+------------+--------------+
10 rows in set (0.00 sec)
mysql> insert into penjualan values('001','10/02/2011','D1','M10','2'),('002','1
1/02/2011','D2','M11','6'),('003','12/02/2011','D3','M12','2'),('004','13/02/201
1','D4','M13','3'),('005','14/02/2011','D5','M14','6'),('006','15/02/2011','D6',
'M15','1');
Query OK, 6 rows affected (0.00 sec)
Records: 6 Duplicates: 0 Warnings: 0
mysql> insert into penjualan values('007','16/02/2011','D7','M16','5'),('008','1
7/02/2011','D8','M17','5'),('009','18/02/2011','D9','M18','4'),('010','19/02/201
1','D10','M19','3');
Query OK, 4 rows affected (0.00 sec)
Records: 4 Duplicates: 0 Warnings: 0
mysql> select*from Penjualan;
+---------+------------+-------------+----------+--------+
| NoBukti | Tanggal | KdPelanggan | KdPRODUK | jumlah |
+---------+------------+-------------+----------+--------+
| 001 | 2010-02-20 | D1 | M10 | 2 |
| 002 | 2011-02-20 | D2 | M11 | 6 |
| 003 | 2012-02-20 | D3 | M12 | 2 |
| 004 | 2013-02-20 | D4 | M13 | 3 |
| 005 | 2014-02-20 | D5 | M14 | 6 |
| 006 | 2015-02-20 | D6 | M15 | 1 |
| 007 | 2016-02-20 | D7 | M16 | 5 |
| 008 | 2017-02-20 | D8 | M17 | 5 |
| 009 | 2018-02-20 | D9 | M18 | 4 |
| 010 | 2019-02-20 | D10 | M19 | 3 |
+---------+------------+-------------+----------+--------+
10 rows in set (0.00 sec)
mysql>
