upz

create database contoh;
use contoh;
create table test (id int (150) primary key,indo varchar (50) unique, inggris varchar(100),tanggal date);
insert into test (id,indo,inggris,tanggal) values (1,"go","pergi","2011-01-13");
insert into test (id,indo,inggris,tanggal) values (2,"home","rumah","2011-01-14");
select * from test where tanggal ='2011-01-14';

> where
contoh:
database --> contoh;
table --> test;
colume --> (id,inggris,indon,tanggal) values (1,"go","pergi","tahun-bulan-tanggal";

select * from test where id < 2 ;

bacaan nya :
-----------
> and
> or