Sabtu, 03 Agustus 2013

PHP Indonesia - Facebook: OOT Mindahin 2000 record data lebih :v INSERT IN...

PHP Indonesia - Facebook
PHP Indonesia is a community for everyone that loves PHP. Our focus is in the PHP world but our topics encompass the entire LAMP stack. Topics include PHP coding, to memcached handling, db optimizations, server stack, web server tuning, code deploying, hosting options and much much more. Youtube Channel : http://www.youtube.com/user/OurPHPIndonesia Twitter : @php_indonesia NOTE: Rules for Wall posting: https://www.facebook.com/groups/35688476100/doc/10151597056316101/ Daftar Keanggotaan : http://www.facebook.com/groups/35688476100/doc/10150671770741101/ 
OOT Mindahin 2000 record data lebih :v INSERT IN...
Aug 3rd 2013, 22:54, by Muhammad Saleh Hafizh Fajri

Muhammad Saleh Hafizh Fajri 10:54pm Aug 3
OOT
Mindahin 2000 record data lebih :v

INSERT INTO `barang`
(`namaBarang`, `idKategoriBarang`, `idSatuanBarang`, `idSupplier`, `barcode`, `qtyMinimum`, `qtyMaximum`, `hargaBeli`, `hargaJual`)
SELECT `mstbarang`.`Nama`, `kategori_barang`.`idKategoriBarang`, `satuan_barang`.`idSatuanBarang`, `supplier`.`idSupplier`, `mstbarang`.`Kode`, `mstbarang`.`QtyMin`, `mstbarang`.`QtyMax`, `mstbarang`.`Hrg_BeliDsr`, `mstbarang`.`Hrg_Jual` FROM `mstbarang`
LEFT JOIN `kategori_barang`
ON `mstbarang`.`No_Kategori`=`kategori_barang`.`idtemp`
LEFT JOIN `supplier`
ON `mstbarang`.`Spl`=`supplier`.`namaSupplier`
LEFT JOIN `satuan_barang`
ON `satuan_barang`.`namaSatuanBarang`=`mstbarang`.`Satuan`

wakakaka

Cahya Dsn 11:00pm Aug 3
denormalisasi >.<

You are receiving this email because you subscribed to this feed at blogtrottr.com.

If you no longer wish to receive these emails, you can unsubscribe from this feed, or manage all your subscriptions

Tidak ada komentar:

Posting Komentar