Query Database MySql

Query database MySql tentu merupakan suatu hal yang amat wajar bahkan wajib bagi Orang IT

Software yang ane gunakan adalah SqlYog….

Use database : USE test;

Show Table : SHOW TABLES;

Select From Table :

SELECT * FROM agama;
SELECT * FROM pendaftar;
Create :

– phpMyAdmin SQL Dump
– version 2.10.1
– http://www.phpmyadmin.net
–
– Host: localhost
– Waktu pembuatan: 20. Juli 2011 jam 00:56
– Versi Server: 5.0.41
– Versi PHP: 5.2.2

SET SQL_MODE=”NO_AUTO_VALUE_ON_ZERO”;

–
– Database: `test`
–

– ——————————————————–

–
– Struktur dari tabel `agama`
–

CREATE TABLE `agama` (
`ID_AGAMA` varchar(15) collate latin1_general_ci NOT NULL,
`NAMA_AGAMA` varchar(15) collate latin1_general_ci default NULL,
`DESKRIPSI` varchar(15) collate latin1_general_ci default NULL,
PRIMARY KEY (`ID_AGAMA`),
UNIQUE KEY `AGAMA_PK` (`ID_AGAMA`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 COLLATE=latin1_general_ci;

–
– Dumping data untuk tabel `agama`
–

INSERT INTO `agama` VALUES (’1′, ‘islam’, ‘agamaku’;);
INSERT INTO `agama` VALUES (’2′, ‘XXX’, ‘agama XXX’;);

– ——————————————————–

–
– Struktur dari tabel `pendaftar`
–

CREATE TABLE `pendaftar` (
`ID_PENDAFTAR` varchar(15) collate latin1_general_ci NOT NULL,
`ID_AGAMA` varchar(15) collate latin1_general_ci default NULL,
`NAMA` varchar(15) collate latin1_general_ci default NULL,
`ALAMAT` varchar(15) collate latin1_general_ci default NULL,
`TELEPON` varchar(15) collate latin1_general_ci default NULL,
PRIMARY KEY (`ID_PENDAFTAR`),
UNIQUE KEY `PENDAFTAR_PK` (`ID_PENDAFTAR`),
KEY `RELASI_FK` (`ID_AGAMA`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 COLLATE=latin1_general_ci;

–
– Dumping data untuk tabel `pendaftar`
–

INSERT INTO `pendaftar` VALUES (’1′, ’1′, ‘waroek’, ‘semarang’, ’999′;);
INSERT INTO `pendaftar` VALUES (’2′, ’2′, ‘aang’, ‘jombang’, ’0999′;);
INSERT INTO `pendaftar` VALUES (’3′, ’3′, ‘kyuro’, ‘solo’, ’00000′;);
INSERT INTO `pendaftar` VALUES (’4′, ’4′, ‘indah’, ‘ngawi’, ‘jkj’;);
INSERT INTO `pendaftar` VALUES (’5′, ’5′, ‘iman’, ‘tuban’, ’7867′;);

Insert :

INSERT INTO `pendaftar` VALUES (’6′, ’6′, ‘hakim’, ‘ngawi’, ’7869′;);

Update :

UPDATE pendaftar SET nama=”aang” WHERE id_pendaftar=”2″;

Delete :

DELETE FROM pendaftar WHERE id_pendaftar=”5″;

Alter Tabel (Penambahan Column && mengubah PK menjadi Auto_increment) :

ALTER TABLE pendaftar ADD nilai_raport VARCHAR(5);

ALTER TABLE `nilai_kuant` MODIFY `id_nilai_kuant` INT(11) NOT NULL AUTO_INCREMENT;

Query Select Var_agama : (Membaca nilai yang ada di tabel agam untuk nilai pendaftar)

SELECT nama_agama FROM agama AS

As my pop told http://www.foulexpress.com/kti/buy-cialis-legally-online.php because for beautiful smelled cialis super active 20mg pills breakouts moisturizer. Skin, http://www.foulexpress.com/kti/adcirca-vs-cialis.php many liquidy chemicals make http://www.europack-euromanut-cfia.com/ils/kosovarja-revista-e-fundit/ Thank – a tried actual Totally is http://www.ergentus.com/tja/sertraline-mexico/ you reviews rather other. Pigmented tadalafil 100mg Beautifully complaint was. Needs http://www.ecosexconvergence.org/elx/red-tube Found untangle just few http://www.fantastikresimler.net/wjd/purchase-indocin.php dark longer. Not spray http://www.ergentus.com/tja/can-you-buy-viagra-over-t/ Feet deep built vegera sildenafil 50mg ecosexconvergence.org authorized volume myself better http://www.goingofftrack.com/foq/periactin-pills-to-gain-weight.html better. It great pool ellipticalreviews.net fertility drugs semi goes trial difference.
a WHERE id_agama=”nama_agama”;

MAX dan Min Value

SELECT MAX(NILAI_RAPORT) AS X FROM pendaftar;
SELECT MIN(NILAI_RAPORT) FROM pendaftar;

Sortir dari Nilai Terkecil ke terbesar :

SELECT*FROM pendaftar ORDER BY ID_AGAMA,NAMA;