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!
Recent content by 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...- martinkaeser
- Post #5
- Forum: MySQL
-
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...- martinkaeser
- Post #3
- Forum: MySQL
-
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...- martinkaeser
- Thread
- Replies: 4
- Forum: MySQL
