PHP SEDERHANA

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

C:\Users\user>cd\apache\mysql\bin

C:\apache\mysql\bin>mysql
Welcome to the MySQL monitor.  Commands end with ; or \g.
Your MySQL connection id is 5 to server version: 3.23.47-nt


Type 'help;' or '\h' for help. Type '\c' to clear the buffer.
mysql> show databases;
Empty set (0.00 sec)

mysql> create database yuyun;
Query OK, 1 row affected (0.00 sec)

mysql> use yuyun
Database changed

mysql> create table mahasiswa
    -> ( npm varchar (10),
    -> nama varchar (20),
    -> alamat varchar (40) );
Query OK, 0 rows affected (0.03 sec)

mysql> desc mahasiswa;
+--------+-------------+------+-----+---------+-------+
| Field  | Type        | Null | Key | Default | Extra |
+--------+-------------+------+-----+---------+-------+
| npm    | varchar(10) | YES  |     | NULL    |       |
| nama   | varchar(20) | YES  |     | NULL    |       |
| alamat | varchar(40) | YES  |     | NULL    |       |
+--------+-------------+------+-----+---------+-------+
3 rows in set (0.02 sec)

mysql> alter table mahasiswa
    -> add jenis_kelamin varchar (10) after nama;
Query OK, 0 rows affected (0.01 sec)
Records: 0  Duplicates: 0  Warnings: 0

mysql> desc mahasiswa;
+---------------+-------------+------+-----+---------+-------+
| Field         | Type        | Null | Key | Default | Extra |
+---------------+-------------+------+-----+---------+-------+
| npm           | varchar(10) | YES  |     | NULL    |       |
| nama          | varchar(20) | YES  |     | NULL    |       |
| jenis_kelamin | varchar(10) | YES  |     | NULL    |       |
| alamat        | varchar(40) | YES  |     | NULL    |       |
+---------------+-------------+------+-----+---------+-------+
4 rows in set (0.00 sec)

mysql> alter table mahasiswa
    -> add jurusan varchar (20);
Query OK, 0 rows affected (0.01 sec)
Records: 0  Duplicates: 0  Warnings: 0

mysql> desc mahasiswa
    -> ;
+---------------+-------------+------+-----+---------+-------+
| Field         | Type        | Null | Key | Default | Extra |
+---------------+-------------+------+-----+---------+-------+
| npm           | varchar(10) | YES  |     | NULL    |       |
| nama          | varchar(20) | YES  |     | NULL    |       |
| jenis_kelamin | varchar(10) | YES  |     | NULL    |       |
| alamat        | varchar(40) | YES  |     | NULL    |       |
| jurusan       | varchar(20) | YES  |     | NULL    |       |
+---------------+-------------+------+-----+---------+-------+
5 rows in set (0.00 sec)

mysql> alter table mahasiswa;
Query OK, 0 rows affected (0.02 sec)
Records: 0  Duplicates: 0  Warnings: 0

mysql> alter table mahasiswa
    -> change jenis_kelamin jenkel varchar(10);
Query OK, 0 rows affected (0.03 sec)
Records: 0  Duplicates: 0  Warnings: 0

mysql> desc mahasiswa;
+---------+-------------+------+-----+---------+-------+
| Field   | Type        | Null | Key | Default | Extra |
+---------+-------------+------+-----+---------+-------+
| npm     | varchar(10) | YES  |     | NULL    |       |
| nama    | varchar(20) | YES  |     | NULL    |       |
| jenkel  | varchar(10) | YES  |     | NULL    |       |
| alamat  | varchar(40) | YES  |     | NULL    |       |
| jurusan | varchar(20) | YES  |     | NULL    |       |
+---------+-------------+------+-----+---------+-------+
5 rows in set (0.00 sec)

mysql> alter table mahasiswa
    -> modify jenkel varchar (1);
Query OK, 0 rows affected (0.01 sec)
Records: 0  Duplicates: 0  Warnings: 0

mysql> alter table mahasiswa
    -> rename MAHASISWA;
Query OK, 0 rows affected (0.01 sec)
Records: 0  Duplicates: 0  Warnings: 0

mysql> desc mahasiswa;
+---------+-------------+------+-----+---------+-------+
| Field   | Type        | Null | Key | Default | Extra |
+---------+-------------+------+-----+---------+-------+
| npm     | varchar(10) | YES  |     | NULL    |       |
| nama    | varchar(20) | YES  |     | NULL    |       |
| jenkel  | char(1)     | YES  |     | NULL    |       |
| alamat  | varchar(40) | YES  |     | NULL    |       |
| jurusan | varchar(20) | YES  |     | NULL    |       |
+---------+-------------+------+-----+---------+-------+
5 rows in set (0.01 sec)


mysql> desc mahasiswa;
+---------+-------------+------+-----+---------+-------+
| Field   | Type        | Null | Key | Default | Extra |
+---------+-------------+------+-----+---------+-------+
| npm     | varchar(10) | YES  |     | NULL    |       |
| nama    | varchar(20) | YES  |     | NULL    |       |
| jenkel  | char(1)     | YES  |     | NULL    |       |
| alamat  | varchar(40) | YES  |     | NULL    |       |
| jurusan | varchar(20) | YES  |     | NULL    |       |
+---------+-------------+------+-----+---------+-------+
5 rows in set (0.01 sec)

mysql> drop table mahasiswa;
Query OK, 0 rows affected (0.01 sec)

mysql> show table mahasiswa;
ERROR 1064: You have an error in your SQL syntax near 'mahasiswa' at line 1

mysql> drop database yuyun;
Query OK, 0 rows affected (0.00 sec)


mysql> use yuyun
Database changed
mysql> insert into mahasiswa values
    -> ('12110320','Yuyun Purnomo','L','Nias','Teknik Informatika'),
    -> ('12122130','Sulasmi Sitorus','P','Medan','Sistem Informasi');
Query OK, 2 rows affected (0.04 sec)
Records: 2  Duplicates: 0  Warnings: 0

mysql> select*from mahasiswa;
+----------+-----------------+--------+--------+--------------------+
| npm      | nama            | jenkel | alamat | jurusan            |
+----------+-----------------+--------+--------+--------------------+
| 12110320 | Yuyun Purnomo   | L      | Nias   | Teknik Informatika |
| 12122130 | Sulasmi Sitorus | P      | Medan  | Sistem Informasi   |
+----------+-----------------+--------+--------+--------------------+
2 rows in set (0.07 sec)

mysql> insert into mahasiswa ( npm, nama, jenkel) values
    -> ('12113221','Pagas Ryijul','L'),
    -> ('12111222','Rina Syammil','P');
Query OK, 2 rows affected (0.01 sec)
Records: 2  Duplicates: 0  Warnings: 0

mysql> select*from mahasiswa;
+----------+-----------------+--------+--------+--------------------+
| npm      | nama            | jenkel | alamat | jurusan            |
+----------+-----------------+--------+--------+--------------------+
| 12110320 | Yuyun Purnomo   | L      | Nias   | Teknik Informatika |
| 12122130 | Sulasmi Sitorus | P      | Medan  | Sistem Informasi   |
| 12113221 | Pagas Ryijul    | L      | NULL   | NULL               |
| 12111222 | Rina Syammil    | P      | NULL   | NULL               |
+----------+-----------------+--------+--------+--------------------+
4 rows in set (0.00 sec)

mysql>