Re^7: Increment DB using Perl

Replies are listed 'Best First'.
Re^8: Increment DB using Perl by Anonymous Monk on Mar 08, 2005 at 17:01 UTC
ID is the name of the row to be updated and variable $newid should be the new id number to be inserted into the database table, so every time in the while loop the first row should be inserted with a 0 and all the rest of the rows should get incremented values 1 for the second row 2 for the third row until the end of the rows on the table.	[reply]
Re^9: Increment DB using Perl by jZed (Prior) on Mar 08, 2005 at 17:04 UTC
> ID is the name of the row No, it is the name of a column which identifies the row. So you want something like UPDATE request SET ID=$newid WHERE ID = XXX Again, you haven't told us enough information to know what XXX is.	[reply]
Re^10: Increment DB using Perl by Anonymous Monk on Mar 08, 2005 at 17:13 UTC
Sorry, there isn't any XXX value the code that I have that does the update is the one here `$sql2 = "UPDATE request SET ID='$new_id'";` [download] And no primary key	[reply] [d/l]
Re^11: Increment DB using Perl by jZed (Prior) on Mar 08, 2005 at 17:16 UTC
Re^11: Increment DB using Perl by RazorbladeBidet (Friar) on Mar 08, 2005 at 17:36 UTC
Re^9: Increment DB using Perl by Joost (Canon) on Mar 08, 2005 at 17:03 UTC
Are there any other columns in the table that are unique? Like a primary key? It'll get REALLY messy if there aren't. "What should it profit a man, if he should win a flame war, yet lose his cool?"	[reply]