Aplikasi Basis Data - Pertemuan 11

===========================================

Pertemuan 11: Data Definition Language

===========================================

*ini bagian awalnya

- d:

- cd/xampp/mysql/bin

- mysql -u root -p

- tunggu sampe ada tulisan "enter passsword:", pencet enter.

*1: bikin database namanya db_mysql

- show databases;

- create database db_mysql;

- show databases;

*2: bikin table tb_biodata

- use db_mysql;

- create table tb_biodata(nim char(10),nama varchar(25),telp varchar(15));

- desc tb_biodata;

*3: nambahin nim jadi primary key

- alter table tb_biodata add primary key (nim);

- desc tb_biodata;

*4: nambahin alamat

- alter table tb_biodata add alamat varchar(30) after telp;

- desc tb_biodata;

*5: ubah telp --> telepon

- alter table tb_biodata change telp telepon varchar(30);

- desc tb_biodata;

*6: ubah tb_biodata --> biodata

- rename table tb_biodata to biodata;

- desc biodata;

*7: hapus alamat

- alter table biodata drop column alamat;

- desc biodata;

*8: bikin table nilai

- create table nilai(nim char(5),nil_abs varchar(3),nil_tgs int(3),nil_uts int(3),nil_uas int(3));

- alter table nilai add primary key (nim);

- desc nilai;

*9: ubah nim 5 --> 10

- alter table nilai change nim nim char(10);

-  desc nilai;

*10: ubah nil_abs varchar --> integer

- alter table nilai change nil_abs nil_abs int(3);

- desc nilai;

===========================================

Name: Harsan Febrian

NIM: 12140650

Class: 12.2C.11

===========================================