Hello all, I am new to mySQL and currently having some difficulties on changing fields data.

I am importing data from flat text database and the ID number field has some duplicates which will screw my data up.
Is there any query to be run to change or make a new ID numbers for my table?

Thank you for any help.

rgds

__________________________
SantanaBlank

Not as a part of MySQLman, no. However, it would be easy to write a few lines of code, in perl, that will change each field in your text file.

Cheers

- wil

For example...if your text file is like.....

ID|Bla......

You could do:

As my assistant is about to show you ;-)

Good job I came back to the thread to read your message.....I missed $i++;