User Profile

Collapse

Profile Sidebar

Collapse
shivkumar1
shivkumar1
Last Activity: Sep 9 '19, 07:08 AM
Joined: May 16 '19
Location:
  •  
  • Time
  • Show
  • Source
Clear All
new posts
  • shivkumar1
    replied to Comparing Two Tables and Deleting duplicate
    in MySQL
    Code:
    DELETE a
FROM a  -- first table
INNER JOIN b -- second table
      ON b.ID = a.ID
      AND b.Name = a.Name
      AND b.Foo = a.Foo
      AND b.Bar = a.Bar
    That should do it... there is also CHECKSUM(*), but this only helps - you'd still need to check the actual values to preclude hash-conflicts.
    See more | Go to post
    Last edited by gits; Aug 19 '19, 09:56 AM. Reason: please use code tags

      Leave a comment:

    • shivkumar1
      replied to Should I start Php?
      in PHP
      You can become a full stack developer having learned PHP or Python programming language. If you interested in joining any training institute for PHP Course then it is very beneficial for you to learn a concept through live project based training otherwise you can also learn a basic concept through w3schools website which is good to learn basic concept step by step.
      See more | Go to post

        Leave a comment:

      • shivkumar1
        replied to Vba delete duplicated value in table
        in Access
        • Remove Duplicates Using Row_Number.
        • Remove Duplicates using self Join.
        • Remove Duplicates using group By
          Code:
          SELECT FirstName, LastName, MobileNo, COUNT(*) as CNT FROM CUSTOMER GROUP BY FirstName, LastName, MobileNo; HAVING COUNT(*) = 1
          .
        See more | Go to post
        Last edited by zmbd; May 16 '19, 10:26 AM. Reason: [z{sql/code/script must use the [CODE/] format}]

          Leave a comment:

        No activity results to display
        Show More
        Working...