Belajar database di Mysql

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

C:\Users\Restu Maduwu>cd\

C:\>cd apache/mysql/bin

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

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

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

mysql> uuse Hobby;
ERROR 1064: You have an error in your SQL syntax near 'uuse Hobby' at line 1
mysql> use Hobby;
Database changed
mysql> create table BPC(
    -> kode_D varchar(10),
    -> Nama_D varchar(20),
    -> Alamat varchar(50));
Query OK, 0 rows affected (0.00 sec)

mysql> desc BPC;
+--------+-------------+------+-----+---------+-------+
| Field  | Type        | Null | Key | Default | Extra |
+--------+-------------+------+-----+---------+-------+
| kode_D | varchar(10) | YES  |     | NULL    |       |
| Nama_D | varchar(20) | YES  |     | NULL    |       |
| Alamat | varchar(50) | YES  |     | NULL    |       |
+--------+-------------+------+-----+---------+-------+
3 rows in set (0.00 sec)

mysql> insert into BPC(kode_D,Nama_,
    -> insert into BPC(kode_D,Nama_D,Alamat) values('1001','Restu','Medan');
ERROR 1064: You have an error in your SQL syntax near 'insert into BPC(kode_D,Na
ma_D,Alamat) values('1001','Restu','Medan')' at line 2
mysql> insert into BPC(kode_D,Nama_D,Alamat) values('1001',Mita','Medan');
    '> insert into BPC(kode_D,Nama_D,Alamat) values('1001','Mita','Medan');
    '> insert into BPC(kode_D,Nama_D,Alamat)values('1001','Restu','Medan');
    '> ';
ERROR 1064: You have an error in your SQL syntax near '','Medan');
insert into BPC(kode_D,Nama_D,Alamat) values('1001','Mita','Medan');' at line 1
mysql> insert into BPC(kode_D,Nama_D,Alamat) values('1001','Restu','Medan');
Query OK, 1 row affected (0.00 sec)

mysql> selsect*from BPC;
ERROR 1064: You have an error in your SQL syntax near 'selsect*from BPC' at line
 1
mysql> select * from BPC;
+--------+--------+--------+
| kode_D | Nama_D | Alamat |
+--------+--------+--------+
| 1001   | Restu  | Medan  |
+--------+--------+--------+
1 row in set (0.00 sec)

mysql> update BPC set Nama_D='Halim'where kode_D='1001';
Query OK, 1 row affected (0.00 sec)
Rows matched: 1  Changed: 1  Warnings: 0

mysql> select*from BPC;
+--------+--------+--------+
| kode_D | Nama_D | Alamat |
+--------+--------+--------+
| 1001   | Halim  | Medan  |
+--------+--------+--------+
1 row in set (0.00 sec)

mysql> insert into BPC values('1002','Yogy',Medan'),('1003','Apotes','Medan');
    '> insert into BPC values('1002','Yogy','Medan'),('1003','Apotes','Medan');
    '> ';
ERROR 1064: You have an error in your SQL syntax near ''),('1003','Apotes','Meda
n');
insert into BPC values('1002','Yogy','Medan'),('10' at line 1
mysql> insert into BPC values('1002','Toni','Medan'),('1003','Tono','Medan');
Query OK, 2 rows affected (0.00 sec)
Records: 2  Duplicates: 0  Warnings: 0

mysql> select*from BPC;
+--------+--------+--------+
| kode_D | Nama_D | Alamat |
+--------+--------+--------+
| 1001   | Halim  | Medan  |
| 1002   | Toni   | Medan  |
| 1003   | Tono   | Medan  |
+--------+--------+--------+
3 rows in set (0.00 sec)

mysql> delete from BPC where kode_D='1003';
Query OK, 1 row affected (0.02 sec)

mysql> select*from BPC;
+--------+--------+--------+
| kode_D | Nama_D | Alamat |
+--------+--------+--------+
| 1001   | Halim  | Medan  |
| 1002   | Toni   | Medan  |
+--------+--------+--------+
2 rows in set (0.02 sec)

mysql> delete from BPC;
Query OK, 0 rows affected (0.00 sec)

mysql> select*from BPC;
Empty set (0.00 sec)

mysql> Alter table BPC add Telp varchar(12) after Alamat;
Query OK, 0 rows affected (0.05 sec)
Records: 0  Duplicates: 0  Warnings: 0

mysql> alter table BPC add Id varchar(5)first;
Query OK, 0 rows affected (0.00 sec)
Records: 0  Duplicates: 0  Warnings: 0

mysql> desc BPC;
+--------+-------------+------+-----+---------+-------+
| Field  | Type        | Null | Key | Default | Extra |
+--------+-------------+------+-----+---------+-------+
| Id     | varchar(5)  | YES  |     | NULL    |       |
| kode_D | varchar(10) | YES  |     | NULL    |       |
| Nama_D | varchar(20) | YES  |     | NULL    |       |
| Alamat | varchar(50) | YES  |     | NULL    |       |
| Telp   | varchar(12) | YES  |     | NULL    |       |
+--------+-------------+------+-----+---------+-------+
5 rows in set (0.00 sec)

mysql> alter table BPC Change Telp No_Telp varchar(12);
Query OK, 0 rows affected (0.01 sec)
Records: 0  Duplicates: 0  Warnings: 0

mysql> desc BPC;
+---------+-------------+------+-----+---------+-------+
| Field   | Type        | Null | Key | Default | Extra |
+---------+-------------+------+-----+---------+-------+
| Id      | varchar(5)  | YES  |     | NULL    |       |
| kode_D  | varchar(10) | YES  |     | NULL    |       |
| Nama_D  | varchar(20) | YES  |     | NULL    |       |
| Alamat  | varchar(50) | YES  |     | NULL    |       |
| No_Telp | varchar(12) | YES  |     | NULL    |       |
+---------+-------------+------+-----+---------+-------+
5 rows in set (0.01 sec)

mysql> Alter table BPC Drop No_Telp;
Query OK, 0 rows affected (0.02 sec)
Records: 0  Duplicates: 0  Warnings: 0

mysql> desc BPC;
+--------+-------------+------+-----+---------+-------+
| Field  | Type        | Null | Key | Default | Extra |
+--------+-------------+------+-----+---------+-------+
| Id     | varchar(5)  | YES  |     | NULL    |       |
| kode_D | varchar(10) | YES  |     | NULL    |       |
| Nama_D | varchar(20) | YES  |     | NULL    |       |
| Alamat | varchar(50) | YES  |     | NULL    |       |
+--------+-------------+------+-----+---------+-------+
4 rows in set (0.00 sec)

mysql>
mysql>