MySQL Forums
Forum List  »  MySQL Query Browser

how to make short time for select
Posted by: andre gunawan
Date: August 26, 2012 11:01PM

how to make short time when i'm doing select rows with many tables for selected (there are concate and substring)
in example:

SELECT dpo.tanggal, dpo.bukti, dpo.qtyminta, dpo.qtybeli, dpo.nosppb, nomorsppb, tpo.supplier, tpo.nopo, CASE WHEN (tpo.supplier = 'CASH') THEN sup.supplier ELSE sup.nama END AS namasupp, CONCAT(dpo.bukti,'-', SUBSTRING(dpo.nosppb, 3, 4), '/', LEFT(dpo.nosppb, 2), '/',RIGHT(dpo.periode, 4)) as npo FROM dtlpo dpo, trnpo tpo, supplier sup WHERE tpo.bukti = dpo.bukti AND tpo.periode = dpo.periode and sup.supplier = tpo.supplier

in my case there are 40029 rows selected...

Options: ReplyQuote

Written By
how to make short time for select
August 26, 2012 11:01PM

Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.