listing LA MYSQL pert1

LISTING PROGRAM :

cd..

cd xampp

cd mysql

cd bin

mysql –u root –p

create database cahyoPm1_database;

show databases;

use cahyoPm1_database;

create table mhs(NPM varchar(10) not null primary key, NAMA varchar(30) not null,KELAS varchar(5));

show tables;

desc mhs;

select * from mhs;

alter table mhs add (alamat varchar(30));

desc mhs;

alter table mhs modify NAMA varchar(50);

desc mhs;

alter table mhs drop klas;

desc mhs;