The latest articles on DEV Community by Abdullah al Noman (@noman73). https://dev.to/noman73 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%2F466110%2Ff6888a64-c57a-4b9c-b28c-b8ae9f98d49b.jpeg https://dev.to/noman73 en Abdullah al Noman Wed, 09 Sep 2020 08:05:02 +0000 https://dev.to/noman73/how-to-set-null-when-find-dupplicate-value-in-mysql-32k0 https://dev.to/noman73/how-to-set-null-when-find-dupplicate-value-in-mysql-32k0 <div class="ltag__stackexchange--container"> <div class="ltag__stackexchange--title-container"> <div class="ltag__stackexchange--title"> <h1> <img src="https://res.cloudinary.com/practicaldev/image/fetch/s--pTF_nE4a--/c_limit%2Cf_auto%2Cfl_progressive%2Cq_auto%2Cw_880/https://practicaldev-herokuapp-com.freetls.fastly.net/assets/stackoverflow-logo-b42691ae545e4810b105ee957979a853a696085e67e43ee14c5699cf3e890fb4.svg" alt=""> <a href="https://stackoverflow.com/questions/63803888/how-to-set-null-when-find-dupplicate-value-in-mysql" rel="noopener noreferrer"> how to set null when find dupplicate value in mysql </a> </h1> <div class="ltag__stackexchange--post-metadata"> <span>Sep 9 '20</span> <span>Comments: 1</span> <span>Answers: 1</span> </div> </div> <a class="ltag__stackexchange--score-container" href="https://stackoverflow.com/questions/63803888/how-to-set-null-when-find-dupplicate-value-in-mysql" rel="noopener noreferrer"> <img src="https://res.cloudinary.com/practicaldev/image/fetch/s--5MiFESHx--/c_limit%2Cf_auto%2Cfl_progressive%2Cq_auto%2Cw_880/https://practicaldev-herokuapp-com.freetls.fastly.net/assets/stackexchange-arrow-up-eff2e2849e67d156181d258e38802c0b57fa011f74164a7f97675ca3b6ab756b.svg" alt=""> <div class="ltag__stackexchange--score-number"> 0 </div> <img src="https://res.cloudinary.com/practicaldev/image/fetch/s--Rk_a5QFN--/c_limit%2Cf_auto%2Cfl_progressive%2Cq_auto%2Cw_880/https://practicaldev-herokuapp-com.freetls.fastly.net/assets/stackexchange-arrow-down-4349fac0dd932d284fab7e4dd9846f19a3710558efde0d2dfd05897f3eeb9aba.svg" alt=""> </a> </div> <div class="ltag__stackexchange--body"> <p>i have join the table like this</p> <pre><code>+--------------+----------------------+------------+-------------+ | sales.cus_id | customers.name |sales.qty |sales.price | +--------------+----------------------+------------+-------------+ | 1 | jamal | 20 | 26 | +--------------+----------------------+------------+-------------+ | 1 | jamal | 30 | 40 | +--------------+----------------------+------------+-------------+ | 1 | jamal | 25 | 50 | +--------------+----------------------+------------+-------------+ | 1 | jamal</code></pre>… </div> <div class="ltag__stackexchange--btn--container"> <a href="https://stackoverflow.com/questions/63803888/how-to-set-null-when-find-dupplicate-value-in-mysql" rel="noopener noreferrer">Open Full Question</a> </div> </div> sql mysql database