|
Posted by --CELKO-- on 05/20/06 02:02
>> have table with 10-20 rows with field [sic] P6 which is empty [sic]. <<
You have NEVER written SQL before, have you? Columsn are not fields
and we have NULLs, not the empty spreadsheet cells you assume. TOTALLY
WRONG MINDSET!
>> I want to update numbers to P6 starting 1 and increasing by 1. <<
That is a SEQUENTAL MAGNETIC TAPE FILE and you are tryignto write
1950's code in SQL! It has northing whatsoever to do with RDBMS.
Tables have no ordering by definition. This is soooooo wrong ...
Navigation:
[Reply to this message]
|