The latest articles on DEV Community by Nnaemeka (@codegenty). https://dev.to/codegenty https://media2.dev.to/dynamic/image/width=90,height=90,fit=cover,gravity=auto,format=auto/https:%2F%2Fdev-to-uploads.s3.amazonaws.com%2Fuploads%2Fuser%2Fprofile_image%2F246412%2Fc1cef1d3-14d4-4d27-8ed6-568ae0b6675c.jpg https://dev.to/codegenty en Nnaemeka Sat, 20 Jun 2020 23:02:23 +0000 https://dev.to/codegenty/how-to-fetch-data-from-mysql-table-and-insert-into-another-table-using-php-29kl https://dev.to/codegenty/how-to-fetch-data-from-mysql-table-and-insert-into-another-table-using-php-29kl <div class="ltag__stackexchange--container"> <div class="ltag__stackexchange--title-container"> <div class="ltag__stackexchange--title"> <div class="ltag__stackexchange--header"> <img src="https://res.cloudinary.com/practicaldev/image/fetch/s--AoTUKOcU--/c_limit%2Cf_auto%2Cfl_progressive%2Cq_auto%2Cw_800/https://dev.to/assets/stackoverflow-logo-b42691ae545e4810b105ee957979a853a696085e67e43ee14c5699cf3e890fb4.svg" alt=""> <a href="https://stackoverflow.com/questions/62492661/how-to-fetch-data-from-mysql-table-and-insert-into-another-table-using-php" rel="noopener noreferrer"> How to fetch data from mysql table and insert into another table using php? </a> </div> <div class="ltag__stackexchange--post-metadata"> <span>Jun 20 '20</span> <span>Comments: 3</span> <span>Answers: 1</span> </div> </div> <a class="ltag__stackexchange--score-container" href="https://stackoverflow.com/questions/62492661/how-to-fetch-data-from-mysql-table-and-insert-into-another-table-using-php" rel="noopener noreferrer"> <img src="https://res.cloudinary.com/practicaldev/image/fetch/s--oeieW07A--/c_limit%2Cf_auto%2Cfl_progressive%2Cq_auto%2Cw_800/https://dev.to/assets/stackexchange-arrow-up-eff2e2849e67d156181d258e38802c0b57fa011f74164a7f97675ca3b6ab756b.svg" alt=""> <div class="ltag__stackexchange--score-number"> -2 </div> <img src="https://res.cloudinary.com/practicaldev/image/fetch/s--h2-sXgSn--/c_limit%2Cf_auto%2Cfl_progressive%2Cq_auto%2Cw_800/https://dev.to/assets/stackexchange-arrow-down-4349fac0dd932d284fab7e4dd9846f19a3710558efde0d2dfd05897f3eeb9aba.svg" alt=""> </a> </div> <div class="ltag__stackexchange--body"> <p>Here is my sql query below</p> <pre><code>select Client, count(*) as Sales FROM sale_tbl GROUP BY Client </code></pre> <p>The query will fetch records like this</p> <pre><code>Client Sales John 5 Bob 4 Doe 5 </code></pre> <p>Now i want to insert this record into another table in the same database named data_tbl with three(3) columns…</p> </div> <div class="ltag__stackexchange--btn--container"> <a href="https://stackoverflow.com/questions/62492661/how-to-fetch-data-from-mysql-table-and-insert-into-another-table-using-php" class="ltag__stackexchange--btn" rel="noopener noreferrer">Open Full Question</a> </div> </div> php laravel database