Write SQL query for TreeView

Hello. I have rich experience in Python, MyQSL. You can know my skills once you see my profile. I am 100% sure to satisfy your requirements and if you hire me, I will provide you good results. I promise you 100% guaranteed project as a senior and full-stack developer. Regards.

Hello there! how are you doing? Can you please provide more details about the project? if the project is fairly paid I can build you a small part of it as form of a demo, afterwards you'll decide if you should hire me or not so don't hesitate to contact me even though you might not be planing to hire me, I don't mind helping Regards Nadhir.B

Hi, I have a good experience in SQL and Database Programming, etc... But I doesn't have lot of reviews in freelancer for these relevant skills. But I confirm you I can write MySql query for TreeView query very well. Also if you want to negotiate budget and days I agree with it. Regards, Zajjith

Hi there, I am a PHP developer having more than 4+ years of experience Magento.I am providing services in website design and development in (PHP/WordPress/Codeigniter/Laravel/Joomla/Magento/Drupal) Technaologies. My Expertise - • Language : PHP • Design : Photoshop, PSD to HTML • Frontend tool: HTML,bootstrap,CSS • Backend tool: MYSQL • Open sources CMS like wordpress MAGENTO. • PHP frameworks like CI, Laravel. • Payment gateways, Social media integration We will be very happy to work with you on your project. we will meet all your requirements & deadlines also provided you the best result as your expectations. Thanks

Hi There is the way to me. If you hire me, I will make class-isleaf structure. In other words, we need to make a table with class-isleaf hierarchy. <id, title, class, isleaf> If then, you will use it easily without self-function. I have 14+ years of experiences in MySQL and data structure. Please hire me. Thanks Regarding my skill, please check following query SELECT id, GROUP_CONCAT(res SEPARATOR ' ' ) AS result FROM (SELECT id, field1, lowcase, CONCAT(UPPER(SUBSTR(lowcase,1,1)),SUBSTR(lowcase,2, LENGTH(lowcase)-1)) res FROM( SELECT id, SUBSTRING_INDEX( SUBSTRING_INDEX(field1, ' ', n), ' ', -1 ) AS field1, LOWER(SUBSTRING_INDEX( SUBSTRING_INDEX(field1, ' ', n), ' ', -1 )) lowcase FROM tablea JOIN (SELECT 1 AS n UNION SELECT 2 AS n UNION SELECT 3 AS n UNION SELECT 4 AS n UNION SELECT 5 AS n UNION SELECT 6 AS n UNION SELECT 7 AS n UNION SELECT 8 AS n UNION SELECT 9 AS n UNION SELECT 10 AS n) numbers ON CHAR_LENGTH(field1) - CHAR_LENGTH(REPLACE(field1, ' ', '')) >= n - 1) tbl ORDER BY id ) tblB GROUP BY id

Hello I am a professional PHP developer with over 5 years of intensive experience in web development. You can find my substantial experience below: - Python - PHP (Pure / MVC / Object Oriented) - HTML5 / CSS3 / Bootstrap / Javascript / jQuery. - Laravel 5+. - DB (MySQL, Firebase). - Writing clean and modular code. - Git, Github. Apart from the above, I will make sure to provide you with updates on a daily basis so you can review work and send me feedback accordingly. I am available to start the project immediately. I am waiting for your response. regards, Heba