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!!!

Berlangganan update artikel terbaru via email:

Tampilkan Komentar

Iklan Atas Artikel

Iklan Tengah Artikel 1

Iklan Tengah Artikel 2

Iklan Bawah Artikel