Belajar membuat database di mysql

Belajar database dasar
Langkah-lankgkah

1.klik start,ketik CMD dikotak dialog start tersebut lalu enter
  kemudian muncul text seperti dibawah ini

  Microsoft Windows [Version 6.1.7600]
  Copyright (c) 2009 Microsoft Corporation.  All rights reserved.

2.Aktifkan mysql-D!
  Dengan cara:
  -klik start
  -Allprogram
  -Phptraid
  -MYSQL
  -Klik sekali aja Mysql-D

 Baru lanjutkan membuat database tadi, ikuti cara dibawah ini


C:\Users\AFRISAL>CD\

C:\>CD APACHE/MYSQL/BIN

C:\apache\mysql\bin>MYSQL.EXE
Welcome to the MySQL monitor.  Commands end with ; or \g.
Your MySQL connection id is 1 to server version: 3.23.47-max-debug

Type 'help;' or '\h' for help. Type '\c' to clear the buffer.

mysql> SHOW DATABASES;
+----------+
| Database |
+----------+
| mysql    |
| test     |
+----------+
2 rows in set (0.00 sec)

mysql> create database dbmahasiswa;
Query OK, 1 row affected (0.01 sec)

mysql> use dbmahasiswa;
Database changed
mysql> create table mahasiswa(
    -> npm varchar(20),
    -> nama varchar(20),
    -> alamat varchar(30),
    -> tgl int,
    -> bulan int,
    -> tahun int,
    -> jk char(9),
    -> jurusan char(9));
Query OK, 0 rows affected (0.02 sec)

mysql> desc mahasiswa;t
+---------+-------------+------+-----+---------+-------+
| Field   | Type        | Null | Key | Default | Extra |
+---------+-------------+------+-----+---------+-------+
| npm     | varchar(20) | YES  |     | NULL    |       |
| nama    | varchar(20) | YES  |     | NULL    |       |
| alamat  | varchar(30) | YES  |     | NULL    |       |
| tgl     | int(11)     | YES  |     | NULL    |       |
| bulan   | int(11)     | YES  |     | NULL    |       |
| tahun   | int(11)     | YES  |     | NULL    |       |
| jk      | varchar(9)  | YES  |     | NULL    |       |
| jurusan | varchar(9)  | YES  |     | NULL    |       |
+---------+-------------+------+-----+---------+-------+
8 rows in set (0.01 sec)

mysql> insert into mahasiswa values
    -> ('13110707','Apotes','JL.SMRAJA',4,4,1994,'LAKI-LAKI','TI');
Query OK, 1 row affected (0.00 sec)

mysql> SELECT * FROM MAHASISWA;
+----------+------------+-----------+------+-------+-------+-----------+--------
-+
| npm      | nama       | alamat    | tgl  | bulan | tahun | jk        | jurusan
 |
+----------+------------+-----------+------+-------+-------+-----------+--------
-+
| 13110707| Restu | JL.Palang Merah |   17|    08 |  1993 | LAKI-LAKI | TEkNIK INFORMATIKA
 |
+----------+------------+-----------+------+-------+-------+-----------+--------
-+
1 row in set (0.00 sec)

mysql>