Wednesday, 11 May 2016

Menambah dan Mengurangi Nilai Yang Sudah Ter-Insert / Tersedia ( ONE STATEMENT SQL UPDATE )

Posted on May 11, 2016 by Hasta Nurhusada

Gambar 1. Menambah dan Mengurangi Nilai Sebelumnya
Saat menggunakan database biasanya kita ingin merubah nilai dengan nilai yang berkaitan dangan nilai sebelumnya, contoh merubah stok barang, Berikut source code-ny: ( source code sesuai dengan ilustrasi Gambar 1 )




source code:
UPDATE tabel1 SET stok = stok+30 WHERE buah='anggur';
UPDATE tabel1 SET stok = stok-20 WHERE buah='melon';
UPDATE tabel1 SET stok = stok WHERE buah='apel';
UPDATE tabel1 SET stok = stok+100 WHERE buah='jeruk';
UPDATE tabel1 SET stok = stok WHERE buah='semangka';

Artikel Terkait Database ,Query SQL

Posted in , | 3 comments

3 comments:

  1. andreas5 July 2018 at 16:42

    terimakasih sudah share
    solder uap

    ReplyDelete
  2. TutikQomariah14 July 2018 at 21:31

    kalo yg insert pake POST method caranya gimana ya ?

    ReplyDelete
    Replies
    1. Hasta Nurhusada31 August 2018 at 09:46

      di sini ada https://www.w3schools.com/tags/ref_httpmethods.asp

      Delete

Subscribe to: Post Comments (Atom)