Latest ads

එක පැකේජ් එකයි මාසෙටම Unlimited Internet. තාමත් DATA CARD දාන්න සල්ලි වියදම් කරනවද? අඩුම මිලට අපෙන්.
- sayuru bandara
- Updated: Tuesday at 12:30 PM
Ad icon
ඉන්ටර්නෙට් එකෙන් හරියටම සල්ලි හොයන්න සහ Success වෙන්න කැමතිද? 🚀 (E-Money & Success Stories)
- siri sumana
- Updated: Saturday at 11:44 PM
Gemini AI PRO 18 months Offer
- Hawaka
- Updated: May 27, 2026
Ad icon
koko account
- DasunEranga
- Updated: May 27, 2026
Ad icon
koko account
- DasunEranga
- Updated: May 27, 2026

Reply to thread

Message: <blockquote data-quote="Ayeshlive" data-source="post: 19848561" data-attributes="member: 363439"><p>MySQL wala "key" kiyala field name ekak thiyenna widihak na eka reserved keyword ekak nisa. </p><p></p><p>Mama red colour eken danne oyage thiyena tables and fields. </p><p></p><p>SELECT m.<span style="color: Red">mail</span>, m.<span style="color: Red">member_id</span>, fn.<span style="color: Red">value</span> AS first_name, ln.<span style="color: Red">value</span> AS last_name FROM <span style="color: SeaGreen">members</span> m LEFT JOIN <span style="color: SeaGreen">member_meta_data</span> fn ON fn.<span style="color: Red">member_id</span> = m.<span style="color: Red">member_id</span> AND fn.<span style="color: Red">key </span>= <span style="color: Magenta">first_name</span> LEFT JOIN <span style="color: SeaGreen">member_meta_data</span> ln ON ln.<span style="color: Red">member_id</span> = m.<span style="color: Red">member_id</span> AND ln.<span style="color: Red">key </span>= <span style="color: Magenta">last_name</span></p><p>purple colour eken thiyenne table eke thiyena data. </p><p>red colour eken tiyuenne table field names. </p><p>green colour eken thiyenne table names.</p></blockquote><p></p>

Verification: Hata thunen beduwama keeyada? (60 bedeema thuna)

Top Bottom