Tutorial Membuka kembali Database yang telah tersimpan
Membuka kembali Database yang telah tersimpan merupakan hal penting yang perlu kita ketahui supaya saat kita bisa membuka database yang sudah pernah kita simpan sebelum.
Microsoft Windows [Version 6.1.7600]
Copyright (c) 2009 Microsoft Corporation. All rights reserved.
C:\Users\nasib>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-max-debug
Type 'help;' or '\h' for help. Type '\c' to clear the buffer.
mysql> show databases;
+---------------------+
| Database |
+---------------------+
| Biodata |
| Buku |
| DBPenjualan |
| Pedagang |
| STMIK |
| Siswa |
| budidarma |
| laptop |
| mahasiswa |
| mysql |
| penggajian_Karyawan |
| penjualancmd |
| perpustakaan |
| perpustakaan1 |
| pilly |
| test |
+---------------------+
16 rows in set (0.00 sec)
mysql> use DBPenjualan;
Database changed
mysql> show tables;
+-----------------------+
| Tables_in_DBPenjualan |
+-----------------------+
| barang |
| konsumen |
| login |
+-----------------------+
3 rows in set (0.00 sec)
mysql> desc barang;
+---------+-------------+------+-----+---------+-------+
| Field | Type | Null | Key | Default | Extra |
+---------+-------------+------+-----+---------+-------+
| kode_b | varchar(8) | YES | | NULL | |
| nama_b | varchar(20) | YES | | NULL | |
| jenis | varchar(20) | YES | | NULL | |
| stok | int(11) | YES | | NULL | |
| harga_b | double | YES | | NULL | |
+---------+-------------+------+-----+---------+-------+
5 rows in set (0.05 sec)
mysql> desc konsumen;
+---------------+-------------+------+-----+---------+-------+
| Field | Type | Null | Key | Default | Extra |
+---------------+-------------+------+-----+---------+-------+
| kode_k | varchar(8) | YES | | NULL | |
| nama_k | varchar(30) | YES | | NULL | |
| jenis_kelamin | varchar(15) | YES | | NULL | |
| alamat | varchar(50) | YES | | NULL | |
| no_telp | varchar(13) | YES | | NULL | |
+---------------+-------------+------+-----+---------+-------+
5 rows in set (0.09 sec)
mysql> desc login;
+-------+-------------+------+-----+---------+-------+
| Field | Type | Null | Key | Default | Extra |
+-------+-------------+------+-----+---------+-------+
| user | varchar(20) | YES | | NULL | |
| pass | varchar(20) | YES | | NULL | |
+-------+-------------+------+-----+---------+-------+
2 rows in set (0.05 sec)
mysql> select * from barang;
+--------+-----------+------------+------+---------+
| kode_b | nama_b | jenis | stok | harga_b |
+--------+-----------+------------+------+---------+
| B002 | TV | Elektronik | 2 | 1000000 |
| B001 | Speaker | Elektronik | 2 | 200000 |
| B003 | Kabel | Elektronik | 3 | 100000 |
| B005 | Mouse | Elektronik | 2 | 100000 |
| B006 | Prossesor | Electronik | 2 | 200000 |
| B004 | Magicom | Elektronik | 12 | 120000 |
+--------+-----------+------------+------+---------+
6 rows in set (0.04 sec)
mysql> select * from konsumen;
+--------+--------+---------------+---------------+--------------+
| kode_k | nama_k | jenis_kelamin | alamat | no_telp |
+--------+--------+---------------+---------------+--------------+
| N11 | Lucky | Laki-laki | Gang Bali | 082365812023 |
| N10 | Nasib | Laki-Lak | Simpang Limun | 082365812023 |
+--------+--------+---------------+---------------+--------------+
2 rows in set (0.00 sec)
mysql> select * from login;
+-------+--------+
| user | pass |
+-------+--------+
| nasib | marbun |
+-------+--------+
1 row in set (0.00 sec)
Semoga Artikel Membuka kembali Database yang telah tersimpan ini bermanfaat!!!
Microsoft Windows [Version 6.1.7600]
Copyright (c) 2009 Microsoft Corporation. All rights reserved.
C:\Users\nasib>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-max-debug
Type 'help;' or '\h' for help. Type '\c' to clear the buffer.
mysql> show databases;
+---------------------+
| Database |
+---------------------+
| Biodata |
| Buku |
| DBPenjualan |
| Pedagang |
| STMIK |
| Siswa |
| budidarma |
| laptop |
| mahasiswa |
| mysql |
| penggajian_Karyawan |
| penjualancmd |
| perpustakaan |
| perpustakaan1 |
| pilly |
| test |
+---------------------+
16 rows in set (0.00 sec)
mysql> use DBPenjualan;
Database changed
mysql> show tables;
+-----------------------+
| Tables_in_DBPenjualan |
+-----------------------+
| barang |
| konsumen |
| login |
+-----------------------+
3 rows in set (0.00 sec)
mysql> desc barang;
+---------+-------------+------+-----+---------+-------+
| Field | Type | Null | Key | Default | Extra |
+---------+-------------+------+-----+---------+-------+
| kode_b | varchar(8) | YES | | NULL | |
| nama_b | varchar(20) | YES | | NULL | |
| jenis | varchar(20) | YES | | NULL | |
| stok | int(11) | YES | | NULL | |
| harga_b | double | YES | | NULL | |
+---------+-------------+------+-----+---------+-------+
5 rows in set (0.05 sec)
mysql> desc konsumen;
+---------------+-------------+------+-----+---------+-------+
| Field | Type | Null | Key | Default | Extra |
+---------------+-------------+------+-----+---------+-------+
| kode_k | varchar(8) | YES | | NULL | |
| nama_k | varchar(30) | YES | | NULL | |
| jenis_kelamin | varchar(15) | YES | | NULL | |
| alamat | varchar(50) | YES | | NULL | |
| no_telp | varchar(13) | YES | | NULL | |
+---------------+-------------+------+-----+---------+-------+
5 rows in set (0.09 sec)
mysql> desc login;
+-------+-------------+------+-----+---------+-------+
| Field | Type | Null | Key | Default | Extra |
+-------+-------------+------+-----+---------+-------+
| user | varchar(20) | YES | | NULL | |
| pass | varchar(20) | YES | | NULL | |
+-------+-------------+------+-----+---------+-------+
2 rows in set (0.05 sec)
mysql> select * from barang;
+--------+-----------+------------+------+---------+
| kode_b | nama_b | jenis | stok | harga_b |
+--------+-----------+------------+------+---------+
| B002 | TV | Elektronik | 2 | 1000000 |
| B001 | Speaker | Elektronik | 2 | 200000 |
| B003 | Kabel | Elektronik | 3 | 100000 |
| B005 | Mouse | Elektronik | 2 | 100000 |
| B006 | Prossesor | Electronik | 2 | 200000 |
| B004 | Magicom | Elektronik | 12 | 120000 |
+--------+-----------+------------+------+---------+
6 rows in set (0.04 sec)
mysql> select * from konsumen;
+--------+--------+---------------+---------------+--------------+
| kode_k | nama_k | jenis_kelamin | alamat | no_telp |
+--------+--------+---------------+---------------+--------------+
| N11 | Lucky | Laki-laki | Gang Bali | 082365812023 |
| N10 | Nasib | Laki-Lak | Simpang Limun | 082365812023 |
+--------+--------+---------------+---------------+--------------+
2 rows in set (0.00 sec)
mysql> select * from login;
+-------+--------+
| user | pass |
+-------+--------+
| nasib | marbun |
+-------+--------+
1 row in set (0.00 sec)
Semoga Artikel Membuka kembali Database yang telah tersimpan ini bermanfaat!!!