Posted in mysql

How To Find Duplicate Values in MySQL

http://www.mysqltutorial.org/mysql-find-duplicate-values/ SELECT mem_name, COUNT(mem_name) FROM mem_password GROUP BY mem_name HAVING COUNT(mem_name) > 1       ***************************************************************************************************************** compare row number and value form two different…

Continue Reading... How To Find Duplicate Values in MySQL
Posted in mysql

Insert – Subquery returns more then 1 row

Insert – Subquery returns more then 1 row Reference: https://www.tek-tips.com/viewthread.cfm?qid=1557007   INSERT INTO mem_password ( `mem_name` , `password`, `hash_password`) SELECT mem_name , ‘No password’,’f8cf7801bd44f47bdf08e4ab122ab5bc’ FROM…

Continue Reading... Insert – Subquery returns more then 1 row
Posted in mysql

find id which are not available in other mysql table

find id which are not available in other mysql table   Select from one table where not in another Mysql: Select rows from a table…

Continue Reading... find id which are not available in other mysql table