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               |

Baca Juga :Cara Setting ODBC pada Database

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

Baca Juga :Langkah-langkah untuk mengkoneksikan Visual Basic Net dengan Database Mysql

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

Baca Juga :Tutorial Menghapus Record Database Mysql Pada CMD

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

Share this post

Berlangganan update artikel terbaru via email: