ElaKiri Community
Downloads
Go Back   ElaKiri Community > General > ElaKiri Talk!
Reload this Page MYSQL Query Help ~
Reply
 
Thread Tools
(#21)
Old
mcwolfe's Avatar
mcwolfe mcwolfe is offline
Senior Member
mcwolfe is a glorious beacon of lightmcwolfe is a glorious beacon of lightmcwolfe is a glorious beacon of lightmcwolfe is a glorious beacon of lightmcwolfe is a glorious beacon of lightmcwolfe is a glorious beacon of lightmcwolfe is a glorious beacon of lightmcwolfe is a glorious beacon of lightmcwolfe is a glorious beacon of lightmcwolfe is a glorious beacon of lightmcwolfe is a glorious beacon of light
 
Posts: 7,167
Join Date: Jul 2011
Location: හීන ලෝකය
04-21-2017, 05:43 PM

bump
Reply With Quote
(#22)
Old
Malinga's Avatar
Malinga Malinga is offline
Senior Member
Malinga is a glorious beacon of lightMalinga is a glorious beacon of lightMalinga is a glorious beacon of lightMalinga is a glorious beacon of lightMalinga is a glorious beacon of lightMalinga is a glorious beacon of lightMalinga is a glorious beacon of lightMalinga is a glorious beacon of lightMalinga is a glorious beacon of lightMalinga is a glorious beacon of lightMalinga is a glorious beacon of light
 
Posts: 50,954
Join Date: Jul 2006
04-21-2017, 06:04 PM

combobox එන්න ඕන කොයි විදියට ද? අනිත් එක ඒ තියෙන Empty fields එහෙම තියෙනව ද?
Reply With Quote
(#23)
Old
rock pora's Avatar
rock pora rock pora is offline
Senior Member
rock pora is a splendid one to beholdrock pora is a splendid one to beholdrock pora is a splendid one to beholdrock pora is a splendid one to beholdrock pora is a splendid one to beholdrock pora is a splendid one to beholdrock pora is a splendid one to beholdrock pora is a splendid one to beholdrock pora is a splendid one to beholdrock pora is a splendid one to beholdrock pora is a splendid one to behold
 
Posts: 11,388
Join Date: May 2011
Location: ###~.:::.සියනෑ කෝරළේ.::.~##
04-21-2017, 06:31 PM

bump
Reply With Quote
(#24)
Old
topkollek's Avatar
topkollek topkollek is offline
Senior Member
topkollek is just really nicetopkollek is just really nicetopkollek is just really nicetopkollek is just really nicetopkollek is just really nicetopkollek is just really nicetopkollek is just really nice
 
Posts: 5,206
Join Date: May 2014
04-21-2017, 06:42 PM

Quote:
Originally Posted by MihiCherub View Post
MYSQL
මචන්ල මට මෙන්න මේකට හොද විසදුමක් දියල්ලකො..

මගේ MYSQL DB එකෙන් data load කරගන්න ඕනෙ combobox එකකට. Products කියල table එකක් තියෙනව. මේ table එකෙ තියෙන main category and sub category වල distinct values load කරගන්න ඕනෙ.

තව warehouse කියල table එකක warehouse names ටික තියෙනව මේ names ටිකත් combobox එකකට load කරගන්න ඕනෙ. මේ ඔක්කොම තනි query එකකින් කරගන්න පුලුවන්ද?

දැනට කරන්නෙ query 3ක් යවල.

Code:
SELECT DISTINCT main_cat FROM products ORDER BY main_cat

SELECT DISTINCT sub_cat FROM products ORDER BY sub_cat

SELECT DISTINCT wh_name FROM warehouse ORDER BY wh_name
Code:
SELECT DISTINCT main_cat AS A FROM products 

UNION

SELECT DISTINCT sub_cat AS A FROM products 

UNION

SELECT DISTINCT wh_name AS A FROM warehouse

ORDER BY A
Reply With Quote
(#25)
Old
dildude's Avatar
dildude dildude is offline
Senior Member
dildude is a glorious beacon of lightdildude is a glorious beacon of lightdildude is a glorious beacon of lightdildude is a glorious beacon of lightdildude is a glorious beacon of lightdildude is a glorious beacon of lightdildude is a glorious beacon of lightdildude is a glorious beacon of lightdildude is a glorious beacon of lightdildude is a glorious beacon of lightdildude is a glorious beacon of light
 
Posts: 12,661
Join Date: May 2015
Location: 🅷🅴🅰V🅴🅽
04-21-2017, 06:57 PM

Quote:
Originally Posted by kolavari View Post
එහෙනම් ඔයාට කෙලවීගෙන යන්නේ
Kelweegena newei kelawila thiyenne ban.
Usa wala wage Nam godak companies orm thama yanne.
E hinda freelance waladi Nam awulak Na.
But mehe company uttawal wala business logic thiyenneth sql wala.
EPA wenawa
Reply With Quote
(#26)
Old
MihiCherub's Avatar
MihiCherub MihiCherub is offline
Senior Member
MihiCherub is a name known to allMihiCherub is a name known to allMihiCherub is a name known to allMihiCherub is a name known to allMihiCherub is a name known to allMihiCherub is a name known to allMihiCherub is a name known to allMihiCherub is a name known to allMihiCherub is a name known to allMihiCherub is a name known to allMihiCherub is a name known to all
 
Posts: 11,077
Join Date: Sep 2009
Location: No:██████, Gampaha
Send a message via Skype™ to MihiCherub
04-21-2017, 07:01 PM

Quote:
Originally Posted by kolavari View Post
Code:
SELECT main_cat as category FROM products UNION SELECT sub_cat  as category FROM products;
මේකේ performance ගැන නොදනිමි
Quote:
Originally Posted by topkollek View Post
Code:
SELECT DISTINCT main_cat AS A FROM products 

UNION

SELECT DISTINCT sub_cat AS A FROM products 

UNION

SELECT DISTINCT wh_name AS A FROM warehouse

ORDER BY A
me ahala thiyena prashne neme..
Reply With Quote
(#27)
Old
MihiCherub's Avatar
MihiCherub MihiCherub is offline
Senior Member
MihiCherub is a name known to allMihiCherub is a name known to allMihiCherub is a name known to allMihiCherub is a name known to allMihiCherub is a name known to allMihiCherub is a name known to allMihiCherub is a name known to allMihiCherub is a name known to allMihiCherub is a name known to allMihiCherub is a name known to allMihiCherub is a name known to all
 
Posts: 11,077
Join Date: Sep 2009
Location: No:██████, Gampaha
Send a message via Skype™ to MihiCherub
04-21-2017, 07:02 PM

Quote:
Originally Posted by Malinga View Post
combobox එන්න ඕන කොයි විදියට ද? අනිත් එක ඒ තියෙන Empty fields එහෙම තියෙනව ද?
Quote:
Originally Posted by u_make_me_sick_ View Post
ORM ekak use karanam wede goda daganna thibba cache karala.

oya records wala primary_key (table id) eka auto generate da neththam umbda decide karanne?
samahara ewa auto smahara ewa mama decide karanne..
Reply With Quote
(#28)
Old
topkollek's Avatar
topkollek topkollek is offline
Senior Member
topkollek is just really nicetopkollek is just really nicetopkollek is just really nicetopkollek is just really nicetopkollek is just really nicetopkollek is just really nicetopkollek is just really nice
 
Posts: 5,206
Join Date: May 2014
04-21-2017, 07:18 PM

Quote:
Originally Posted by MihiCherub View Post
me ahala thiyena prashne neme..
ai oken beri?
Reply With Quote
(#29)
Old
u_make_me_sick_'s Avatar
u_make_me_sick_ u_make_me_sick_ is offline
Senior Member
u_make_me_sick_ has a spectacular aura aboutu_make_me_sick_ has a spectacular aura aboutu_make_me_sick_ has a spectacular aura about
 
Posts: 5,241
Join Date: Oct 2011
04-21-2017, 07:49 PM

Quote:
Originally Posted by MihiCherub View Post
samahara ewa auto smahara ewa mama decide karanne..
primary key (table id) umba decide karananwam, db insert karanakota ( or after) ee record eka cache karapan, Cache karanna oni collection ekak widihata. mata pena hetiyata nam umbata hariyanne mem cache. install karannath lesiy,

hema insert query ekakata passe, ara cache eka update karapan aluth record ekath ekka, Cache update method eka synchronize karata kamak ne.

ehema karoth umbata aapahu DB record read kara kara inna oni ne, kelinma cache eken ganna puluwan, Its faster than reading from DB.

Last edited by u_make_me_sick_; 04-21-2017 at 07:50 PM.
Reply With Quote
(#30)
Old
MihiCherub's Avatar
MihiCherub MihiCherub is offline
Senior Member
MihiCherub is a name known to allMihiCherub is a name known to allMihiCherub is a name known to allMihiCherub is a name known to allMihiCherub is a name known to allMihiCherub is a name known to allMihiCherub is a name known to allMihiCherub is a name known to allMihiCherub is a name known to allMihiCherub is a name known to allMihiCherub is a name known to all
 
Posts: 11,077
Join Date: Sep 2009
Location: No:██████, Gampaha
Send a message via Skype™ to MihiCherub
04-21-2017, 08:09 PM

Quote:
Originally Posted by u_make_me_sick_ View Post
primary key (table id) umba decide karananwam, db insert karanakota ( or after) ee record eka cache karapan, Cache karanna oni collection ekak widihata. mata pena hetiyata nam umbata hariyanne mem cache. install karannath lesiy,

hema insert query ekakata passe, ara cache eka update karapan aluth record ekath ekka, Cache update method eka synchronize karata kamak ne.

ehema karoth umbata aapahu DB record read kara kara inna oni ne, kelinma cache eken ganna puluwan, Its faster than reading from DB.
mama me technology eka nam danne na.. multiple pc walin meka karanna puluwanda? local hoost neme db eka..
Reply With Quote
Reply

Bookmarks

Thread Tools

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off

Forum Jump



Copyright © 2006 - 2011 ElaKiri™ Beta2.Evo vBulletin, vBa iBproArcade Subdreamer I-Magic MKv

Page generated in 0.04912 seconds with 11 queries