Skip to content
Advertisement

How to Copy one table data to another table with 2 wherecondtion and an if condtion MYSQL

Actually i want to copy one tables data to another table. it has no unique id , the only relation between two are a “fra” number and a ‘pra’ number but both are not unique . but fra and pra (r concatenate ) is unique for each. and one table data is sex (customer table) and another is gender(new_customer table) the gender is Boolean, sex is string of m and f . how can i copy from customer table to new_customer table I tried these way

Any body to help me?

Advertisement

Answer

something like following, you can try.

User contributions licensed under: CC BY-SA
7 People found this is helpful
Advertisement