create data base xampp dengan commandcom/cmd!

masuk direcktory xampp:

hingga menjadi c:\xampp -=> c:\xampp\cd mysql\ entar.. kosongin password enter lagi

kemudian create database

create database "yang dimaui"

contoh

create database mahasiwa;

kemudian membuat tabel: 

caranya: 

create table tMahasiswa(

                nim varchar(20)primary key not null,

                nama varchar(200),

                mpassword varchar(10),

                sks numeric,

                IPK varchar (10),

                semster varchar (100),

                fakultas varchar(200),

                )

create table tMatakuliah(

                kode_matakuliah varchar(20)primary key not null,

                nama_takuliah varchar(300),

                SKSA numeric,

                SKSB numeric,

                )

create table tKelas(

                kode_kelas varchar(20),

                kode_matakuliah varchar(20)primary key not null,

                NIP varchar(20),

                tempat varchar(100),

                kapasitas numeric,

                hari varchar(50),

                jam char(20),

                )

create table tDosen(

                NIP varchar(20)primary key not null,

                nama varchar(200),

                )

create table tKst(

                ID numeric primary key not null,

                NIM varchar(20),

                kode_matakuliah varchar(20),

                kode_kelas varchar(20),

                status varchar(20),

                )

create table tDosen(

                NIP varchar(20)primary key not null,

                nama varchar(200),

                )

create table tKst(

                ID numeric primary key not null,

                NIM varchar(20),

                kode_matakuliah varchar(20),

                kode_kelas varchar(20),

                status varchar(20),

                )

Kemudian mengisi tabel-nya.. caranya:

Untuk Mengisi Tabel Matakuliah:

insert into tMatakuliah values('IT611','Pemrograman Aplikasi Mobile 1',3,4)

insert into tMatakuliah values('IT306','Rekayasa Perangkat Lunak',3,4)

insert into tMatakuliah values('IT518','Oracle Administration',3,4)

insert into tMatakuliah values('IT605','XML',3,4)

select * from tMatakuliah

Untuk Mengisi Tabel Dosen:

insert into tDosen values(67521,'Hendro Steven T, S.Kom.')

insert into tDosen values(67555,'Hendry, M.Kom.')

insert into tDosen values(67512,'Irwan Sembiring, S.T, M.Kom.')

insert into tDosen values(67507,'Wiwin Sulistyo, ST., M.Kom.')  

select * from tDosen

Untuk mengisi tabel Kelas:

insert into tKelas values('IT306','IT306C',67002,'F109',40,'Rabu','7-9')

insert into tKelas values('IT604','IT604A',67555,'Lab E201A',39,'Kamis','14-17')

insert into tKelas values('IT605','IT605C',67999,'F203',40,'Jumat','7-9')

insert into tKelas values('IT611','IT611A',67532,'Lab E250',35,'Selasa','13-16')

select * from tKelas

Untuk Mengisi Tabel Mahasiswa:

insert into tMahasiswa values(672008601,'James Bond',672008601,19,'3.8','SEMESTER 2 TA 2011 - 2012','Teknologi Informasi - Teknik Informatika')

insert into tMahasiswa values(672009097,'Paris Hilton',672009097,8,'3.9','SEMESTER 2 TA 2011 - 2012','Teknologi Informasi - Teknik Informatika')

insert into tMahasiswa values(672009101,'Lucy Liu',672009101,19,'3.8','SEMESTER 2 TA 2011 - 2012','Teknologi Informasi - Teknik Informatika')

select * from tMahasiswa

Untuk Mengisi Tabel Kst:

insert into tKst values(20585,672009097,'IT507','IT507B','B')

insert into tKst values(20588,672009097,'IT518','IT518A','B')

insert into tKst values(20601,672009097,'IT101','IT101A','B')

insert into tKst values(20602,672009097,'IT604','IT604A','B')

select * from tKst

untuk "select * form *" untuk menampilkan data: