How to see MySQL version?

If NULL: UPDATE table_nameSET empty_column = data_columnWHERE empty_column IS NULLIf it an empty string:UPDATE table_nameSET empty_column = data_columnWHERE empty_column = ''If it either:UPDATE table_nameSET empty_column = data_columnWHERE empty_column IS NULL OR...

SELECT generic, COUNT(generic)FROM medicine_detailsGROUP BY genericHAVING COUNT(generic) > 1;//generic = column name//medicine_details = table name

UPDATE tableB t1 INNER JOIN tableA t2 ON t1.id = t2.idSET t1.name = t2.name . UPDATE medicine_details t1 INNER JOIN tbl_drug_generic t2 ON t1.generic =...

To find a duplicate id run the following query: SELECT generic, COUNT(generic) FROM medicine_details WHERE generic_id BETWEEN 1 AND 1255 GROUP BY generic HAVING COUNT(generic) > 0