;
;
Selasa, 08 Desember 2009
Perintah Dasar MYSQL
Posted on 18.04 by AssLab Community
1. MEMBUAT DATABASE
a. Mysql>create database jual;
b. Mysql>create database beli;
2. MENGGUNAKAN DATABASE
a. Mysql>Use jual;
3. MEMBUAT TABEL
a. Mysql>create table barang(kdbar char(4) not null primary key,
Nmbar varchar(30) not null, harga double);
b. Mysql>create table kasir(kdkasir char(3),nmkasir varchar(30),
Primary key(kdkasir));
4. MELIHAT STRUKTUR TABEL
a. Mysql>describe barang;
b. Desc kasir;
5. MELIHAT ISI DATABASE
a. Show tables from jual;
b. Show fields from jual.barang;
6. MENGISI TABEL
a. Insert into barang(kdbar,nmbar,harga)
Values(‘HP01’,’Nokia 3310’,1200000);
b. Insert into kasir values(‘ILM’,’Ilham’),(‘YDH’,’Yodha’)
7. MENAMPILKAN ISI TABEL
a. Menampilkan seluruh field
i. Mysql>select * from barang;
b. Menampilkan field tertentu
i. Mysql>Select nmbar distinc from barang;
c. Menampilkan beberapa field
i. Mysql>Select nmbar,harga from barang;
d. Mengurutkan data
i. Mysql>Select * from barang order by nmbar asc;
ii. Mysql>Select * from barang order by nmbar desc;
e. Menampilkan sesuai kriteria
i. Mysql>Select * from barang where kdbar=’HP01’;
ii. Mysql>Select * from barang where nmbar like ‘%nokia%’;
iii. Mysql>Select * from barang where harga>1200000;
iv. Mysql>Select * from barang where harga between 50000 and 1300000;
f. Fungsi Aggregate
i. Mysql>Select sum(harga) from barang;
ii. Mysql>Select sum(harga),avg(harga),min(harga),max(harga),count(harga) from barang;
iii. Mysql>Select sum(harga),nmbar from brg group by nmbar;
iv. Mysql>Select sum(harga),nmbar from brg group by nmbar having avg(harga) > 1200000;
8. MENAMBAHKAN FIELD BARU
a. Mysql>alter table barang add bonus varchar(10);
9. MERUBAH ISI TABEL
a. Mysql>update barang set bonus=’MMC 1GB’;
b. Mysql>update barang set bonus=’SD Card 2Gb’ where kdbar=’HP01’;
10. MERUBAH NAMA FIELD
a. Mysql>Alter table barang change harga hrg double;
11. MERUBAH TIPE DATA
a. Mysql>Alter table barang modify bonus varchar(30);
12. MENGHAPUS FIELD
a. Mysql>alter table barang drop bonus;
13. MERUBAH NAMA TABEL
a. Mysql>Alter table barang rename brg;
14. MENGHAPUS ISI TABEL
a. Mysql>Delete from brg where kdbar=’HP01’;
15. MENGHAPUS TABLE
a. Mysql>Drop table kasir;
16. MENGHAPUS DATABASE
a. Mysql>Drop database beli;
17. KELUAR DARI MYSQL
a. Mysql>quit;
b. Mysql>exit;
Langganan:
Posting Komentar (Atom)
No Response to "Perintah Dasar MYSQL"
Leave A Reply