Perintah SQL

mysql> \T mti.txt;      {membuat folder file}

mysql> create database SDM; {membuat data base SDM}

mysql> show databases; {menampilkan folder data base yang dimiliki}

mysql> use SDM;      {menggunakan data base SDM}

mysql> create table         {perintah membuat table}

mysql> create table pegawai (nip char(3) primary key,nama char(30),gol char(2));

mysql> insert into pegawai values ('783','Beni','2A');   {contoh masukan data pegawai}

mysql> select * from pegawai;   { menampilkan table pegawai}

mysql> create table gaji (gol char(2) primary key,gapok bigint(10),

    -> tnj_fungsi bigint(10),tnj_str bigint(10),tnj_klr bigint(10),

    -> transport bigint(10));

mysql> insert into gaji values ('2A',1000,100,50,5,10);   {contoh masukan data gaji}

mysql> select * from gaji; { menampilkan table gaji}

mysql> update pegawai set gol='4C',nama='Titi' where nip='201';

mysql> delete from pegawai where nama='Adi';

mysql> select pegawai.nip,pegawai.nama,gaji.gapok from pegawai inner join

    -> gaji on pegawai.gol=gaji.gol;

mysql> select pegawai.nip,pegawai.nama,(gaji.gapok + gaji.tnj_fungsi +

    -> gaji.tnj_str + gaji.tnj_klr + gaji.transport) from pegawai inner join

    -> gaji on pegawai.gol=gaji.gol;

mysql> select pegawai.nip,pegawai.nama,(gaji.gapok + gaji.tnj_fungsi +

    -> gaji.tnj_str + gaji.tnj_klr + gaji.transport) as total_gaji from pegawai

    -> inner join gaji on pegawai.gol=gaji.gol;

mysql> select sum(gaji.gapok + gaji.tnj_fungsi + gaji.tnj_str + gaji.tnj_klr +

    -> gaji.transport) as seluruh from pegawai inner join gaji on pegawai.gol=

    -> gaji.gol;

mysql> select min(gaji.gapok + gaji.tnj_fungsi + gaji.tnj_str + gaji.tnj_klr +

    -> gaji.transport) as terendah from pegawai inner join gaji on pegawai.gol=

    -> gaji.gol;

mysql> insert into pegawai values ('999','Heni','4C');   {menambahkan data pegawai}

mysql> select pegawai.gol,count(nip) as jml_pegawai from pegawai

    -> group by pegawai.gol;

mysql> alter table pegawai add progdi char(3); {menambahkan field pada tabel pegawai}

mysql> alter table pegawai change progdi program char(5); {mengubah nama field }

mysql> alter table pegawai drop program;

mysql> select * from pegawai order by nip;       {mengurutkan nip}