Contoh progam MySql

I.                                   Soal

1. Create tabel buku deng an kolom :
- ID_BUKU
- JUDUL_BUKU
- PENGARANG
- PENERBIT
- TAHUN_TERBIT
- HARGA_BUKU


2. Stlah trbntuk tabel buku, insert dg 50 data


3. Lakukan query brikut :


- trbntuk tabel buku,

        - insert dg 50 data

- tampilkn data buku dg hrga d bwah 50rb

- tmpilkn data bku dg hrga antara 30rb-50rb

- tmpilkn data bku dg jdul yg berawal "A"

- tmpilkn dta bku dg hrga yg sdah d dskon 5rb

- tmpilkn dta bku kolom ID_BUKU dg tahun yg sma

II.  Jawaban

TABEL I

CREATE TABLE BUKU (

ID_BUKU VARCHAR (20) PRIMARY KEY,

JUDUL_BUKU VARCHAR (20),

PENGARANG VARCHAR (20),

PENERBIT VARCHAR (20),

TAHUN_TERBIT VARCHAR (20),

HARGA_BUKU VARCHAR (20));

SELECT*FROM BUKU;

SHOW TABLES;

TABEL II

CREATE TABLE BUKU (

ID_BUKU VARCHAR (30) PRIMARY KEY,

JUDUL_BUKU VARCHAR (30),

PENGARANG VARCHAR (30),

PENERBIT VARCHAR (30),

TAHUN_TERBIT VARCHAR (30),

HARGA_BUKU VARCHAR (30));

SELECT*FROM BUKU;

INSERT INTO BUKU VALUES ('101','BONEKA','ROJIUN','AIRLANGGI','2010','90.000');

INSERT INTO BUKU VALUES ('102','POCONG','GHOZALI','AIRLANGGI','2010','90.000');

INSERT INTO BUKU VALUES ('103','DARAH','HENDRAWAN','AIRLANGGI','2010','70.000');

INSERT INTO BUKU VALUES ('104','GURITA','RAHMANUR','AIRLANGGI','2010','90.000');

INSERT INTO BUKU VALUES ('105','GORILA','RURIANTO','AIRLANGGI','2010','90.000');

INSERT INTO BUKU VALUES ('106','MATA','ANDREAN','AIRLANGGI','2010','50.000');

INSERT INTO BUKU VALUES ('107','MAMA','BAHARY','AIRLANGGI','2010','50.000');

INSERT INTO BUKU VALUES ('108','PAPA','ROJIUN','AIRLANGGI','2009','50.000');

INSERT INTO BUKU VALUES ('109','PAPA2','ROJIUN','AIRLANGGI','2010','50.000');

INSERT INTO BUKU VALUES ('110','PAPA3','ROJIUN','AIRLANGGI','2011','50.000');

INSERT INTO BUKU VALUES ('111','KUMISKU','ROJIUN','AIRLANGGI','2000','50.000');

INSERT INTO BUKU VALUES ('112','KUMISKU2','ROJIUN','AIRLANGGI','2001','50.000');

INSERT INTO BUKU VALUES ('113','KUMISKU3','ROJIUN','AIRLANGGI','2002','50.000');

INSERT INTO BUKU VALUES ('114','KUMISKU4','ROJIUN','AIRLANGGI','2003','50.000');

INSERT INTO BUKU VALUES ('115','KUMISKU5','ROJIUN','AIRLANGGI','2004','50.000');

INSERT INTO BUKU VALUES ('116','KUMISKU6','ROJIUN','AIRLANGGI','2005','50.000');

INSERT INTO BUKU VALUES ('117','KUMISKU7','ROJIUN','AIRLANGGI','2006','50.000');

INSERT INTO BUKU VALUES ('118','KUMISKU8','ROJIUN','AIRLANGGI','2009','50.000');

INSERT INTO BUKU VALUES ('119','KUMISKU9','ROJIUN','AIRLANGGI','2010','50.000');

INSERT INTO BUKU VALUES ('120','NERAKA','AHMADI','AIRLANGGI','2000','50.000');

INSERT INTO BUKU VALUES ('121','NERAKA2','AHMADI','AIRLANGGI','2001','50.000');

INSERT INTO BUKU VALUES ('122','NERAKA3','AHMADI','AIRLANGGI','2002','50.000');

INSERT INTO BUKU VALUES ('123','NERAKA4','AHMADI','AIRLANGGI','2003','50.000');

INSERT INTO BUKU VALUES ('124','NERAKA5','AHMADI','AIRLANGGI','2004','50.000');

INSERT INTO BUKU VALUES ('125','NERAKA6','AHMADI','AIRLANGGI','2005','50.000');

INSERT INTO BUKU VALUES ('126','NERAKA7','AHMADI','AIRLANGGI','2006','50.000');

INSERT INTO BUKU VALUES ('127','NERAKA8','AHMADI','AIRLANGGI','2008','50.000');

INSERT INTO BUKU VALUES ('128','NERAKA9','AHMADI','AIRLANGGI','2010','50.000');

INSERT INTO BUKU VALUES ('129','SURGAKU','ANDREAHIRATA','AIRLANGGI','2000','50.000');

INSERT INTO BUKU VALUES ('130','SURGAKU2','ANDREAHIRATA','AIRLANGGI','2001','50.000');

INSERT INTO BUKU VALUES ('131','SURGAKU3','ANDREAHIRATA','AIRLANGGI','2002','50.000');

INSERT INTO BUKU VALUES ('132','SURGAKU4','ANDREAHIRATA','AIRLANGGI','2003','50.000');

INSERT INTO BUKU VALUES ('133','SURGAKU5','ANDREAHIRATA','AIRLANGGI','2004','50.000');

INSERT INTO BUKU VALUES ('134','SURGAKU6','ANDREAHIRATA','AIRLANGGI','2005','50.000');

INSERT INTO BUKU VALUES ('135','SURGAKU7','ANDREAHIRATA','AIRLANGGI','2006','50.000');

INSERT INTO BUKU VALUES ('136','SURGAKU8','ANDREAHIRATA','AIRLANGGI','2007','50.000');

INSERT INTO BUKU VALUES ('137','SURGAKU9','ANDREAHIRATA','AIRLANGGI','2008','50.000');

INSERT INTO BUKU VALUES ('138','SURGAKU10','ANDREAHIRATA','AIRLANGGI','2009','50.000');

INSERT INTO BUKU VALUES ('139','SURGAKU11','ANDREAHIRATA','AIRLANGGI','2010','50.000');

INSERT INTO BUKU VALUES ('140','SURGAKU12','ANDREAHIRATA','AIRLANGGI','2011','50.000');

INSERT INTO BUKU VALUES ('141','SUARA','MUNIR','AIRLANGGI','2010','30.000');

INSERT INTO BUKU VALUES ('142','SUARA','MUNIR','AIRLANGGI','2011','30.000');

INSERT INTO BUKU VALUES ('143','KERAMAT','GHANI','AIRLANGGI','2000','40.000');

INSERT INTO BUKU VALUES ('144','KERAMAT2','GHANI','AIRLANGGI','2001','40.000');

INSERT INTO BUKU VALUES ('145','KERAMAT3','GHANI','AIRLANGGI','2002','40.000');

INSERT INTO BUKU VALUES ('146','KERAMAT4','GHANI','AIRLANGGI','2003','40.000');

INSERT INTO BUKU VALUES ('147','KERAMAT5','GHANI','AIRLANGGI','2004','40.000');

INSERT INTO BUKU VALUES ('148','KERAMAT6','GHANI','AIRLANGGI','2005','40.000');

INSERT INTO BUKU VALUES ('149','KERAMAT7','GHANI','AIRLANGGI','2006','40.000');

INSERT INTO BUKU VALUES ('150','KERAMAT8','GHANI','AIRLANGGI','2011','40.000');

SELECT*FROM BUKU;

TABEL III

select*from BUKU WHERE HARGA_BUKU BETWEEN 0 AND 49.000;

TABEL IV

select*from BUKU WHERE HARGA_BUKU BETWEEN 30.000 AND 50.000;

TABEL V

SELECT JUDUL_BUKU FROM BUKU WHERE 'A';

SELECT HARGA_BUKU - '5%';

SELECT*FROM BUKU WHERE TAHUN_TERBIT BETWEEN 2010 AND 2010;