Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations strongm on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Search results for query: *

  1. martinkaeser

    MySQL Query for incrementing field from duplicates in database

    Hi Feherke you gave me the right idea und the understanding. WITH cte AS (SELECT ID, ROW_NUMBER() OVER w proofNr_correct FROM korrektur_copy WINDOW w AS (PARTITION BY auftrag)) UPDATE korrektur_copy JOIN cte ON cte.ID = korrektur_copy.ID SET korrektur_copy.proofNr = cte.proofNr_correct WHERE...
  2. martinkaeser

    MySQL Query for incrementing field from duplicates in database

    First of all thank you feherke. And sorry about my late answer: I had a bad toothache [evil] I adopted your example to: WITH cte AS (SELECT ID, ROW_NUMBER() OVER w proofNr_correct FROM korrektur_copy WINDOW w AS (PARTITION BY ID)) UPDATE korrektur_copy JOIN cte ON cte.ID = korrektur_copy.ID SET...
  3. martinkaeser

    MySQL Query for incrementing field from duplicates in database

    First, hi to all I've the following problem: I have in an existing MySQL-DB duplicates of records and i need to increment the column "proofNr" n+1 for every entry. Please refer the last row in the following resultset. mysql> SELECT * FROM `korrektur` WHERE `auftrag`= 140802...

Part and Inventory Search

Back
Top