Pemrograman MySQL

create database "201553014"

use "201553014"

create table Barang

(kdbrg varchar (10) primary key,

nmbrg varchar (50),

jnsbrg varchar (20),

harga int,

jumlah int)

select*from Barang

insert into barang

values ('001', 'indomie', 'mie instan', 2000, 50)

insert into barang

values ('002', 'sunsilk', 'shampo', 14000, 100)

insert into barang

values ('003', 'pepsodent', 'pasta gigi', 7000, 75)

insert into barang

values ('004', 'La Light', 'rokok', 18000, 200)

insert into barang

values ('005', 'SGM 3', 'Susu Bayi', 75000, 150)

 

1. tampilkan yg namanya indomie

select*from Barang where nmbrg='indomie'

2. tampilkan yg jenisnya shampo

select*from Barang where jnsbrg='shampo'

3. tampilkan yg harganya 18.000

select*from Barang where harga='18000'

4. tampilkan yg jumlahnya 150

select*from Barang where jumlah='150'

5. tampilkan yg jenisnya susu

select*from Barang where jnsbrg like'%susu%'

6. tampilkan yg namanya sunsilk & pepsodent

select*from Barang where nmbrg='sunsilk' or nmbrg='pepsodent'

7. tampilkan yg namanya la light & SGM 3

select*from Barang where nmbrg='La light' or nmbrg='sgm 3'

8. tampilkan yg harganya 2000 & 75000

select*from Barang where harga='2000' or harga='75000'

9. tampilkan yg jumlahnya 100 atau 200

select*from Barang where jumlah='100' or jumlah='200'

10. tampilkan yg namanya indomie & jumlahnya 75

select*from Barang where nmbrg='indomie' or jumlah='75'