User Profile

Collapse

Profile Sidebar

Collapse
nhatto
nhatto
Last Activity: Nov 12 '09, 03:19 PM
Joined: Nov 11 '09
Location:
  •  
  • Time
  • Show
  • Source
Clear All
new posts
  • nhatto
    replied to Comparing Two Tables and Deleting duplicate
    in MySQL
    Found why

    I found why this is the error :

    the reason was the Collation were not matching for both fields..

    got it fixed.. and it worked beautifully

    thank you so much !
    See more | Go to post

      Leave a comment:

    • nhatto
      replied to Comparing Two Tables and Deleting duplicate
      in MySQL
      Keep getting an error

      Hello,

      Thank you for your response

      when i try to run the query, I keep getting the following error:

      #1267 - Illegal mix of collations (latin1_swedish _ci,IMPLICIT) and (armscii8_bin,I MPLICIT) for operation '='

      I have no clue what that means? any idea?
      See more | Go to post

        Leave a comment:

      • nhatto
        started a topic Comparing Two Tables and Deleting duplicate
        in MySQL

        Comparing Two Tables and Deleting duplicate

        Hello

        I have Two Tables ( Table A and Table B)

        Table A has one field : email
        Table B has three Fields : First name, Last name , email

        I want to check if the email in Table B is found in Table A, And if it is , then I want to delete the row ( First name, Last name , email ) from Table B that has that email.

        any help is really appreciated and thank you in advance!
        See more | Go to post
        No activity results to display
        Show More
        Working...