Membuat Database di Command Prompt dengan MySQL
Karna aku masih diberikan umur panjang hingga saat ini kuingin berbagi sedikit cara pembuatan Database dengan Mysql di Command Prompt, kali ini pembahasannya pembuatan Database Laptop. tapi sebelumnya pastikan MySQL-D diklik terlebih dahulu dan Apachenya diStart. setelah itu
silahkan mengaktifkan Command Promtpnya yah sobat...
kalau perintah diatas sudah dilaksanakan, mulailah mengikuti langkah-langkah pembuatan databasenya
seperti langkah-langkah dibawah ini :
Microsoft Windows [Version 6.1.7601]
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 4 to server version: 3.23.47-max-debug
Type 'help;' or '\h' for help. Type '\c' to clear the buffer.
mysql> create database laptop;
Query OK, 1 row affected (0.00 sec)
mysql> show databases;
+---------------------+
| Database |
+---------------------+
| Biodata |
| budidarma |
| laptop |
| mahasiswa |
| penggajian_Karyawan |
| penjualan1 |
| perpustakaan |
| test |
+---------------------+
11 rows in set (0.00 sec)
mysql> use laptop;
Database changed
mysql> create table barang(
-> kode varchar(5),
-> merek varchar(12),
-> satuan varchar(10),
-> harga double);
Query OK, 0 rows affected (0.04 sec)
mysql> desc barang;
+--------+-------------+------+-----+---------+-------+
| Field | Type | Null | Key | Default | Extra |
+--------+-------------+------+-----+---------+-------+
| kode | varchar(5) | YES | | NULL | |
| merek | varchar(12) | YES | | NULL | |
| satuan | varchar(10) | YES | | NULL | |
| harga | double | YES | | NULL | |
+--------+-------------+------+-----+---------+-------+
4 rows in set (0.00 sec)
mysql> insert into barang
-> (kode,merek,satuan,harga)
-> values
-> ("B100","Acer","Unit","4000000"),
-> ("C100","Toshiba","Unit","4500000"),
-> ("D100","Lenovo","Unit","3500000"),
-> ("E100","Suzuki","Unit","1200000");
Query OK, 4 rows affected (0.00 sec)
Records: 4 Duplicates: 0 Warnings: 0
mysql> select*from barang;
+------+---------+--------+---------+
| kode | merek | satuan | harga |
+------+---------+--------+---------+
| B100 | Acer | Unit | 4000000 |
| C100 | Toshiba | Unit | 4500000 |
| D100 | Lenovo | Unit | 3500000 |
| E100 | Suzuki | Unit | 1200000 |
+------+---------+--------+---------+
4 rows in set (0.03 sec)
Ups, selesai sudah pembuatan Databasenya, semoga bermanfaat yah......!!!
Selamat mencoba.
silahkan mengaktifkan Command Promtpnya yah sobat...
kalau perintah diatas sudah dilaksanakan, mulailah mengikuti langkah-langkah pembuatan databasenya
seperti langkah-langkah dibawah ini :
Microsoft Windows [Version 6.1.7601]
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 4 to server version: 3.23.47-max-debug
Type 'help;' or '\h' for help. Type '\c' to clear the buffer.
mysql> create database laptop;
Query OK, 1 row affected (0.00 sec)
mysql> show databases;
+---------------------+
| Database |
+---------------------+
| Biodata |
| budidarma |
| laptop |
| mahasiswa |
| penggajian_Karyawan |
| penjualan1 |
| perpustakaan |
| test |
+---------------------+
11 rows in set (0.00 sec)
mysql> use laptop;
Database changed
mysql> create table barang(
-> kode varchar(5),
-> merek varchar(12),
-> satuan varchar(10),
-> harga double);
Query OK, 0 rows affected (0.04 sec)
mysql> desc barang;
+--------+-------------+------+-----+---------+-------+
| Field | Type | Null | Key | Default | Extra |
+--------+-------------+------+-----+---------+-------+
| kode | varchar(5) | YES | | NULL | |
| merek | varchar(12) | YES | | NULL | |
| satuan | varchar(10) | YES | | NULL | |
| harga | double | YES | | NULL | |
+--------+-------------+------+-----+---------+-------+
4 rows in set (0.00 sec)
mysql> insert into barang
-> (kode,merek,satuan,harga)
-> values
-> ("B100","Acer","Unit","4000000"),
-> ("C100","Toshiba","Unit","4500000"),
-> ("D100","Lenovo","Unit","3500000"),
-> ("E100","Suzuki","Unit","1200000");
Query OK, 4 rows affected (0.00 sec)
Records: 4 Duplicates: 0 Warnings: 0
mysql> select*from barang;
+------+---------+--------+---------+
| kode | merek | satuan | harga |
+------+---------+--------+---------+
| B100 | Acer | Unit | 4000000 |
| C100 | Toshiba | Unit | 4500000 |
| D100 | Lenovo | Unit | 3500000 |
| E100 | Suzuki | Unit | 1200000 |
+------+---------+--------+---------+
4 rows in set (0.03 sec)
Ups, selesai sudah pembuatan Databasenya, semoga bermanfaat yah......!!!
Selamat mencoba.
0 Response to "Membuat Database di Command Prompt dengan MySQL"
Post a Comment