Membuat Database Praktek: Laporan 1 Basisdata 2 Putri Sakinah Mi 2B 1101091008

Download as docx, pdf, or txt
Download as docx, pdf, or txt
You are on page 1of 14

[Pick the date]

[LAPORAN 1 BASISDATA 2 PUTRI SAKINAH MI 2B 1101091008 ]

PERTEMUAN II PRAKTEK BASIS DATA 2 28-09-2012


PUTRI SAKINAH MI 2B
1. Membuat database praktek
mysql> create database praktek;
Query OK, 1 row affected (0.01 sec)
mysql> use praktek;
Query OK, 1 row affected (0.01 sec)
Database changed (dan database pun berganti menjadi database praktek)
mysql> show tables;
Empty set (0.00 sec)
mysql> drop database praktek
Query OK, 0 rows affected(0.00 sec)

mysql> show databases;


+--------------------+
| Database

+--------------------+
| information_schema |
| latihan1

| latihan2

| mysql

+--------------------+
4 rows in set (0.00 sec)
mysql> use mysql;
Database changed
mysql> show tables;

[LAPORAN 1 BASISDATA 2 PUTRI SAKINAH MI 2B 1101091008 ]

[Pick the date]


+---------------------------+
| Tables_in_mysql

+---------------------------+
| columns_priv

| db

| func

| help_category

| help_keyword

| help_relation

| help_topic

| host

| proc

| procs_priv

| tables_priv

| time_zone

| time_zone_leap_second

| time_zone_name

| time_zone_transition

| time_zone_transition_type |
| user

+---------------------------+
17 rows in set (0.00 sec)

mysql> select * from user;


+-----------+------+----------+-------------+-------------+-------------+-------

[Pick the date]

[LAPORAN 1 BASISDATA 2 PUTRI SAKINAH MI 2B 1101091008 ]

------+-------------+-----------+-------------+---------------+--------------+----------+------------+-----------------+------------+------------+-------------+------------+-----------------------+------------------+--------------+----------------+------------------+------------------+----------------+--------------------+--------------------+------------------+----------+------------+------------+--------------+---------------+-------------+-----------------+---------------------+
| Host

| User | Password | Select_priv | Insert_priv | Update_priv | Delete

_priv | Create_priv | Drop_priv | Reload_priv | Shutdown_priv | Process_priv | F


ile_priv | Grant_priv | References_priv | Index_priv | Alter_priv | Show_db_priv
| Super_priv | Create_tmp_table_priv | Lock_tables_priv | Execute_priv | Repl_s
lave_priv | Repl_client_priv | Create_view_priv | Show_view_priv | Create_routin
e_priv | Alter_routine_priv | Create_user_priv | ssl_type | ssl_cipher | x509_is
suer | x509_subject | max_questions | max_updates | max_connections | max_user_c
onnections |
+-----------+------+----------+-------------+-------------+-------------+------------+-------------+-----------+-------------+---------------+--------------+----------+------------+-----------------+------------+------------+-------------+------------+-----------------------+------------------+--------------+----------------+------------------+------------------+----------------+--------------------+--------------------+------------------+----------+------------+------------+--------------+---------------+-------------+-----------------+---------------------+
| localhost | root |
|Y

|Y

|Y
|Y

|Y
|Y

|Y
|Y

|Y
|Y

[Pick the date]


|Y
|Y

|Y

|Y

|Y
|Y
|Y

[LAPORAN 1 BASISDATA 2 PUTRI SAKINAH MI 2B 1101091008 ]


|Y

|Y

|Y

|Y

|Y

|Y

|
0|

|Y

0|

|Y
|Y

|
0|

0|
+-----------+------+----------+-------------+-------------+-------------+------------+-------------+-----------+-------------+---------------+--------------+----------+------------+-----------------+------------+------------+-------------+------------+-----------------------+------------------+--------------+----------------+------------------+------------------+----------------+--------------------+--------------------+------------------+----------+------------+------------+--------------+---------------+-------------+-----------------+---------------------+
1 row in set (0.00 sec)
2. Membuat sebuah Tabel. Terdapat beberapa perintah yaitu :
*Membuat database praktek
*Membuat tabel mahasiswa dengan struktur
-nobp varchar(15) pknn,nama varchar(30) nn);
*Membuat tabel film dengan struktur
- IdFilm char 5 primary key not null
- Judul fil varchar 30 not null
Membuat tabel karyawan
- IdKaryawan char 5 pk nn
- Nama varchar 30 nn
- Alamat varchar 50 nn
- Bagian varchar 30 nn
mysql> create database praktek;
Query OK, 1 row affected (0.02 sec)

[LAPORAN 1 BASISDATA 2 PUTRI SAKINAH MI 2B 1101091008 ]

[Pick the date]

Tabel Mahasiswa
mysql> create table mahasiswa (nobp varchar(15) primary key not null,nama varcha
r(30) not null);
Query OK, 0 rows affected (0.03 sec)
Tabel Film
mysql> create table film (id_film varchar(5) primary key not null,judul varchar(
30) not null, aktor varchar(30) not null);
Query OK, 0 rows affected (0.06 sec)
Tabel Karyawan
mysql> create table karyawan(idkaryawan char(5) primary key not null,nama varcha
r(30) not null,alamat varchar(50) not null,bagian varchar(30) not null);
Query OK, 0 rows affected (0.08 sec)

Show tables
mysql> show tables;
+---------------------------+
| Tables_in_mysql

+---------------------------+
| columns_priv

| db

| film

| func

| help_category

| help_keyword

| help_relation

| help_topic
| host

|
|

[LAPORAN 1 BASISDATA 2 PUTRI SAKINAH MI 2B 1101091008 ]

[Pick the date]


| karyawan

| mahasiswa
| proc

|
|

| procs_priv

| tables_priv

| time_zone

| time_zone_leap_second

| time_zone_name

| time_zone_transition

| time_zone_transition_type |
| user

+---------------------------+
20 rows in set (0.00 sec)

[Pick the date]

[LAPORAN 1 BASISDATA 2 PUTRI SAKINAH MI 2B 1101091008 ]

3. Melihat struktur sebuah tabel


Menggunakan ketentuan :
- Desc namatabel;
- Describe namatabel;
- Show columns from namatabel;
Tabel Mahasiswa
mysql> desc mahasiswa;
+-------+-------------+------+-----+---------+-------+
| Field | Type

| Null | Key | Default | Extra |

+-------+-------------+------+-----+---------+-------+
| nobp | varchar(15) | NO | PRI |
| nama | varchar(30) | NO |

|
|

|
|

+-------+-------------+------+-----+---------+-------+
2 rows in set (0.00 sec)

mysql> describe mahasiswa;


+-------+-------------+------+-----+---------+-------+
| Field | Type

| Null | Key | Default | Extra |

+-------+-------------+------+-----+---------+-------+
| nobp | varchar(15) | NO | PRI |
| nama | varchar(30) | NO |

|
|

+-------+-------------+------+-----+---------+-------+
2 rows in set (0.02 sec)

|
|

[Pick the date]

[LAPORAN 1 BASISDATA 2 PUTRI SAKINAH MI 2B 1101091008 ]

mysql> show columns from mahasiswa;


+-------+-------------+------+-----+---------+-------+
| Field | Type

| Null | Key | Default | Extra |

+-------+-------------+------+-----+---------+-------+
| nobp | varchar(15) | NO | PRI |
| nama | varchar(30) | NO |

|
|

+-------+-------------+------+-----+---------+-------+
2 rows in set (0.00 sec)

|
|

[Pick the date]

[LAPORAN 1 BASISDATA 2 PUTRI SAKINAH MI 2B 1101091008 ]

Tabel Film
mysql> desc film;
+---------+-------------+------+-----+---------+-------+
| Field | Type

| Null | Key | Default | Extra |

+---------+-------------+------+-----+---------+-------+
| id_film | varchar(5) | NO | PRI |

| judul | varchar(30) | NO |

| aktor | varchar(30) | NO |

+---------+-------------+------+-----+---------+-------+
3 rows in set (0.00 sec)

mysql> describe film;


+---------+-------------+------+-----+---------+-------+
| Field | Type

| Null | Key | Default | Extra |

+---------+-------------+------+-----+---------+-------+
| id_film | varchar(5) | NO | PRI |

| judul | varchar(30) | NO |

| aktor | varchar(30) | NO |

+---------+-------------+------+-----+---------+-------+
3 rows in set (0.00 sec)

[Pick the date]

[LAPORAN 1 BASISDATA 2 PUTRI SAKINAH MI 2B 1101091008 ]

mysql> show columns from film;


+---------+-------------+------+-----+---------+-------+
| Field | Type

| Null | Key | Default | Extra |

+---------+-------------+------+-----+---------+-------+
| id_film | varchar(5) | NO | PRI |

| judul | varchar(30) | NO |

| aktor | varchar(30) | NO |

+---------+-------------+------+-----+---------+-------+
3 rows in set (0.00 sec)

Tabel Karyawan
mysql> desc karyawan;
+------------+-------------+------+-----+---------+-------+
| Field

| Type

| Null | Key | Default | Extra |

+------------+-------------+------+-----+---------+-------+
| idkaryawan | char(5)

| NO | PRI |

| nama

| varchar(30) | NO |

| alamat

| varchar(50) | NO |

| bagian

| varchar(30) | NO |

+------------+-------------+------+-----+---------+-------+
4 rows in set (0.00 sec)

[Pick the date]

[LAPORAN 1 BASISDATA 2 PUTRI SAKINAH MI 2B 1101091008 ]

mysql> describe karyawan;


+------------+-------------+------+-----+---------+-------+
| Field

| Type

| Null | Key | Default | Extra |

+------------+-------------+------+-----+---------+-------+
| idkaryawan | char(5)

| NO | PRI |

| nama

| varchar(30) | NO |

| alamat

| varchar(50) | NO |

| bagian

| varchar(30) | NO |

+------------+-------------+------+-----+---------+-------+
4 rows in set (0.00 sec)

mysql> show columns from karyawan;


+------------+-------------+------+-----+---------+-------+
| Field

| Type

| Null | Key | Default | Extra |

+------------+-------------+------+-----+---------+-------+
| idkaryawan | char(5)

| NO | PRI |

| nama

| varchar(30) | NO |

| alamat

| varchar(50) | NO |

| bagian

| varchar(30) | NO |

+------------+-------------+------+-----+---------+-------+
4 rows in set (0.01 sec)

[Pick the date]

[LAPORAN 1 BASISDATA 2 PUTRI SAKINAH MI 2B 1101091008 ]

4. Menambahkan field baru pada tabel


Alter table namatabel add namafield tipedatafield;
- mysql> alter table film ADD kategorifilm varchar(20) not null;
Query OK, 0 rows affected (0.14 sec)
- mysql> alter table film ADD produser varchar(30) not null;
Query OK, 0 rows affected (0.11 sec)
Records: 0 Duplicates: 0 Warnings: 0
Untuk menggabungkan/menambahkan lebih dari 1 field caranya adalah dengan menggunakan
add.
mysql> alter table film add studio char(5) not null,add jumtempatduduk int not n
ull;
Query OK, 0 rows affected (0.13 sec)
Melihat kembali bentuk tabel yang sudah ditambahkan beberapa field
Tabel film
mysql> desc film;
+----------------+-------------+------+-----+---------+-------+
| Field
| Type
| Null | Key | Default | Extra |
+----------------+-------------+------+-----+---------+-------+
| id_film
| varchar(5) | NO | PRI |
|
|
| judul
| varchar(30) | NO | |
|
|
| aktor
| varchar(30) | NO | |
|
|
| kategorifilm | varchar(20) | NO | |
|
|
| produser
| varchar(30) | NO | |
|
|
| jumlahkeping | int(11) | NO | |
|
|
| studio
| char(5) | NO | |
|
|
| jumtempatduduk | int(11) | NO | |
|
|
+----------------+-------------+------+-----+---------+-------+
8 rows in set (0.00 sec)

[Pick the date]

[LAPORAN 1 BASISDATA 2 PUTRI SAKINAH MI 2B 1101091008 ]

Tabel mahasiswa
Melakukan penambahan field pada tabel mahasiswa
mysql> alter table mahasiswa add kelas char(5),add prodi varchar(30),add jurusan
varchar(30);
Query OK, 0 rows affected (0.11 sec)
Records: 0 Duplicates: 0 Warnings: 0

mysql> desc mahasiswa;


+---------+-------------+------+-----+---------+-------+
| Field | Type
| Null | Key | Default | Extra |
+---------+-------------+------+-----+---------+-------+
| nobp | varchar(15) | NO | PRI |
|
|
| nama | varchar(30) | NO | |
|
|
| kelas | char(5) | YES | | NULL |
|
| prodi | varchar(30) | YES | | NULL |
|
| jurusan | varchar(30) | YES | | NULL |
|
+---------+-------------+------+-----+---------+-------+
5 rows in set (0.00 sec)

Tabel Karyawan
Melakukan penambahan field pada tabel karyawan
mysql> alter table karyawan add tunjangananak float not null,add jumanak int not
null;
Query OK, 0 rows affected (0.13 sec)
Records: 0 Duplicates: 0 Warnings: 0
mysql> desc karyawan;
+---------------+-------------+------+-----+---------+-------+
| Field
| Type
| Null | Key | Default | Extra |
+---------------+-------------+------+-----+---------+-------+
| idkaryawan | char(5) | NO | PRI |
|
|
| nama
| varchar(30) | NO | |
|
|
| alamat
| varchar(50) | NO | |
|
|
| bagian
| varchar(30) | NO | |
|
|
| tunjangananak | float
| NO | |
|
|
| jumanak
| int(11) | NO | |
|
|

[Pick the date]

[LAPORAN 1 BASISDATA 2 PUTRI SAKINAH MI 2B 1101091008 ]

+---------------+-------------+------+-----+---------+-------+
6 rows in set (0.00 sec)

5. Mengubah field tabel yang sudah ada


Alter table namatabel change fieldlama fieldbaru tipedata
Mengganti prodi menjadi program studi pada tabel mahasiswa :
mysql> alter table mahasiswa change prodi programstudi varchar(30);
Query OK, 0 rows affected (0.11 sec)
Records: 0 Duplicates: 0 Warnings: 0

Mengganti nama menjadi namakaryawan pada tabel karyawan :


mysql> alter table karyawan change nama namakaryawan varchar(30) not null;
Query OK, 0 rows affected (0.08 sec)
Records: 0 Duplicates: 0 Warnings: 0

Mengganti jumlahkeping menjadi jumkeping pada tabel film :


mysql> alter table film change jumlahkeping jumkeping int not null;
Query OK, 0 rows affected (0.11 sec)
Records: 0 Duplicates: 0 Warnings: 0

You might also like