SQL Random Queries

person shubham sharmafolder_openMy-SQLlocal_offerMySQLaccess_time November 18, 2017

Finding duplicate values in a SQL table

MySQL

SELECT name, email, COUNT(*) FROM users GROUP BY name, email HAVING COUNT(*) > 1

1 2 3 4 5 6 7 8

SELECT     name, email, COUNT(*) FROM     users GROUP BY     name, email HAVING     COUNT(*) > 1

 

MySQL Update Column from other column in same table

MySQL

UPDATE bjp_users JOIN bjp_mla ON bjp_mla.constituency = bjp_users.username SET bjp_users.c_no = bjp_mla.c_no

1 2 3 4 5 6 7

UPDATE    bjp_users    JOIN       bjp_mla       ON bjp_mla.constituency = bjp_users.username SET    bjp_users.c_no = bjp_mla.c_no