Ads were blocked - no problem. But keep in mind that developing HeidiSQL, user support and hosting takes time and money. You may want to send a donation instead.

Error Updating Id from a table

Hev's profile image Hev posted 3 months ago in Running SQL scripts Permalink

Hello everyone. I have a question because I'm trying to do a massive update of the Id from a table. This is the code.

SET @number=10000; UPDATE MyTable SET nId = @number+1;

It's a very simple code... I know. I'm just trying to update the Id starting with the number 10000 The problem is that I'm getting error because of duplicates on my primary key. It might be easy to fix it but I'm just starting with Heidi. I hope someone can inspire me... Hope everyone have a nice day! PD: Sorry for my bad english.

Please login to leave a reply, or register at first.




Ads were blocked - no problem. But keep in mind that developing HeidiSQL, user support and hosting takes time and money. You may want to send a donation instead.