Scribd
Unggah
32 tayangan4 halaman

Panduan Penggunaan XAMPP di Windows

Diunggah oleh

The Nightmare
Hak Cipta
© All Rights Reserved
Kami menangani hak cipta konten dengan serius. Jika Anda merasa konten ini milik Anda, ajukan klaim di sini.
Format Tersedia
Unduh sebagai TXT, PDF, TXT atau baca online di Scribd
32 tayangan4 halaman

Panduan Penggunaan XAMPP di Windows

Diunggah oleh

The Nightmare
Hak Cipta
© All Rights Reserved
Kami menangani hak cipta konten dengan serius. Jika Anda merasa konten ini milik Anda, ajukan klaim di sini.
Format Tersedia
Unduh sebagai TXT, PDF, TXT atau baca online di Scribd

Setting environment for using XAMPP for Windows.

USER@AKATSUKI-SENPAI c:\xampp
# cd mysql

USER@AKATSUKI-SENPAI c:\xampp\mysql
# mysql-u root
'mysql-u' is not recognized as an internal or external command,
operable program or batch file.

USER@AKATSUKI-SENPAI c:\xampp\mysql
# mysql -u root

mysql> show databases;


+--------------------+
| Database |
+--------------------+
| information_schema |
| absensisiswa |
| admin-kun |
| anime |
| biodata |
| crud_uas |
| db_barang |
| db_inventori |
| db_toko |
| dbbuku |
| dbsiswa |
| mvc_master |
| mysql |
| pendaftaranpramuka |
| performance_schema |
| perpustakaan |
| ppdbdftrn |
| ppdblgn |
| registrasi |
| sekolah2 |
| test |
| toko_online |
| webauth |
+--------------------+
23 rows in set (0.00 sec)

mysql> create database market;


Query OK, 1 row affected (0.01 sec)

mysql> use market;


Database changed
mysql> create table daftar(
-> No integer not null,
-> Nama varchar(255) not null,
-> Tipe varchar(255) not null,
-> Harga integer not null,
-> Jmlh integer not null,
-> primary key(No)
-> );
Query OK, 0 rows affected (0.02 sec)

mysql> INSERT INTO daftar (No,Nama,Tipe,Harga,Jmlh) VALUES


-> (1,'Rinso','Sabun cuci',1000,30),
-> (2,'Tango','Makanan',2000,50),
-> (3,'Aqua','Minuman',3000,100),
-> (4,'Lampu','Elektronik',32000,20);
Query OK, 4 rows affected (0.00 sec)
Records: 4 Duplicates: 0 Warnings: 0

mysql> create table terjual(


-> No integer not null,
-> Nama varchar(255) not null,
-> Tipe varchar(255) not null,
-> Hasil integer not null,
-> Jmlh_terjual integer not null,
-> primary key(No)
-> );
Query OK, 0 rows affected (0.01 sec)

mysql> INSERT INTO terjual (No,Nama,Tipe,Hasil,Jmlh_terjual) VALUES


-> (1,'Rinso','Sabun cuci',10000,10),
-> (2,'Tango','Makanan',40000,20),
-> (3,'Aqua','Minuman',150000,50),
-> (4,'Lampu','Elektronik',128000,4);
Query OK, 4 rows affected (0.00 sec)
Records: 4 Duplicates: 0 Warnings: 0

mysql> create table stok(


-> No integer not null,
-> Nama varchar(255) not null,
-> Tipe varchar(255) not null,
-> Harga integer not null,
-> Sisa integer not null,
-> primary key(No)
-> );
Query OK, 0 rows affected (0.01 sec)

mysql> INSERT INTO stok (No,Nama,Tipe,Harga,sisa) VALUES


-> (1,'Rinso','Sabun cuci',1000,20),
-> (2,'Tango','Makanan',2000,30),
-> (3,'Aqua','Minuman',3000,50),
-> (4,'Lampu','Elektronik',32000,16);
Query OK, 4 rows affected (0.00 sec)
Records: 4 Duplicates: 0 Warnings: 0

mysql> SELECT
->[Link],
->[Link],
->[Link],
->[Link],
->[Link],
->[Link],
->terjual.`Jmlh_terjual`,
->[Link]
->FROM
->daftar
->LEFT JOIN
->terjual ON [Link] = [Link] AND [Link] = [Link] AND
[Link] = [Link]
->LEFT JOIN
->stok ON [Link] = [Link] AND [Link] = [Link] AND [Link] =
[Link];
+----+-------+------------+-------+------+--------+--------------+------+
| No | Nama | Tipe | Harga | Jmlh | Hasil | Jmlh_terjual | Sisa |
+----+-------+------------+-------+------+--------+--------------+------+
| 1 | Rinso | Sabun cuci | 1000 | 30 | 10000 | 10 | 20 |
| 2 | Tango | Makanan | 2000 | 50 | 40000 | 20 | 30 |
| 3 | Aqua | Minuman | 3000 | 100 | 150000 | 50 | 50 |
| 4 | Lampu | Elektronik | 32000 | 20 | 128000 | 4 | 16 |
+----+-------+------------+-------+------+--------+--------------+------+
4 rows in set (0.01 sec)

mysql> select *from daftar;


+----+-------+------------+-------+------+
| No | Nama | Tipe | Harga | Jmlh |
+----+-------+------------+-------+------+
| 1 | Rinso | Sabun cuci | 1000 | 30 |
| 2 | Tango | Makanan | 2000 | 50 |
| 3 | Aqua | Minuman | 3000 | 100 |
| 4 | Lampu | Elektronik | 32000 | 20 |
+----+-------+------------+-------+------+
4 rows in set (0.00 sec)

mysql> select *from terjual;


+----+-------+------------+--------+--------------+
| No | Nama | Tipe | Hasil | Jmlh_terjual |
+----+-------+------------+--------+--------------+
| 1 | Rinso | Sabun cuci | 10000 | 10 |
| 2 | Tango | Makanan | 40000 | 20 |
| 3 | Aqua | Minuman | 150000 | 50 |
| 4 | Lampu | Elektronik | 128000 | 4 |
+----+-------+------------+--------+--------------+
4 rows in set (0.00 sec)

mysql> select *from stok;


+----+-------+------------+-------+------+
| No | Nama | Tipe | Harga | Sisa |
+----+-------+------------+-------+------+
| 1 | Rinso | Sabun cuci | 1000 | 20 |
| 2 | Tango | Makanan | 2000 | 30 |
| 3 | Aqua | Minuman | 3000 | 50 |
| 4 | Lampu | Elektronik | 32000 | 16 |
+----+-------+------------+-------+------+
4 rows in set (0.01 sec)

mysql> INSERT INTO daftar (No, Nama, Tipe, Harga, Jmlh)


-> VALUES (5, 'Oreo', 'Makanan', 1500, 40);
Query OK, 1 row affected (0.01 sec)

mysql> INSERT INTO terjual (No, Nama, Tipe, Hasil, Jmlh_terjual)


-> VALUES (5, 'Oreo', 'Makanan', 45000, 30);
Query OK, 1 row affected (0.01 sec)

mysql> INSERT INTO stok (No, Nama, Tipe, Harga, Sisa)


-> VALUES (5, 'Oreo', 'Makanan', 1500, 10);
Query OK, 1 row affected (0.01 sec)

mysql> select *from daftar;


+----+-------+------------+-------+------+
| No | Nama | Tipe | Harga | Jmlh |
+----+-------+------------+-------+------+
| 1 | Rinso | Sabun cuci | 1000 | 30 |
| 2 | Tango | Makanan | 2000 | 50 |
| 3 | Aqua | Minuman | 3000 | 100 |
| 4 | Lampu | Elektronik | 32000 | 20 |
| 5 | Oreo | Makanan | 1500 | 40 |
+----+-------+------------+-------+------+
5 rows in set (0.01 sec)

mysql> select *from terjual;


+----+-------+------------+--------+--------------+
| No | Nama | Tipe | Hasil | Jmlh_terjual |
+----+-------+------------+--------+--------------+
| 1 | Rinso | Sabun cuci | 10000 | 10 |
| 2 | Tango | Makanan | 40000 | 20 |
| 3 | Aqua | Minuman | 150000 | 50 |
| 4 | Lampu | Elektronik | 128000 | 4 |
| 5 | Oreo | Makanan | 45000 | 30 |
+----+-------+------------+--------+--------------+
5 rows in set (0.00 sec)

mysql> select *from stok;


+----+-------+------------+-------+------+
| No | Nama | Tipe | Harga | Sisa |
+----+-------+------------+-------+------+
| 1 | Rinso | Sabun cuci | 1000 | 20 |
| 2 | Tango | Makanan | 2000 | 30 |
| 3 | Aqua | Minuman | 3000 | 50 |
| 4 | Lampu | Elektronik | 32000 | 16 |
| 5 | Oreo | Makanan | 1500 | 10 |
+----+-------+------------+-------+------+
5 rows in set (0.00 sec)
mysql> SELECT
-> [Link],
-> [Link],
-> [Link],
-> [Link],
-> [Link],
-> [Link],
-> terjual.`Jmlh_terjual`,
-> [Link]
-> FROM
-> daftar
-> LEFT JOIN
-> terjual ON [Link] = [Link] AND [Link] = [Link] AND
[Link] = [Link]
-> LEFT JOIN
-> stok ON [Link] = [Link] AND [Link] = [Link] AND [Link] =
[Link];

Anda mungkin juga menyukai