Operasi Logika SQL

OPERASI  LOGIKA

Penerapan ke SQL

1.AND
          select*from nama_tabel where
          field=”data 1”AND field=”data 2”;
2.OR
          select*from nama_table where
          field=”data 1” or field 2=data 2”;
3.NOT
          select*from nama_table where
          field Not=”data 1”;

Operator Like,Not Like,Reqexp

Penerapan Ke SQL
1.Like
          select*from nama_tabel where
          field 1 like “r%”;
2.Not like
          select*from nama_tabel where
          field 1 not like “r %”;
3.Regexp
          select*from nama_tabel where
          field 1 regexp “r $”;

“Database Relayion”
          bentuk dasar SQL untuk proses relasi tabel pada database ;
=> select field1,tabel 1, field 2.tabel 1,field 1.tabel2,
      field2.tabel2,field_n,tabel_n from tabel 1.tabel2,
      tabel_n where field1,tabel 1AND field 1.tabel2
      =field_n.tabel_n;