I have started using MySQL because I want to learn about something new and
to keep a database of my growing comic book collection, which would be handy
should something should ever happen to them. In doing this, I have started
to think of other ways to use MySQL, such as managing my CD collection
>You are 100% correct.
>
>Since MySQL does not support "cursors", I always
>put an auto_increment column in my tables for just
>this purpose.
>
>(This is what other DBMS' do, they just do it behind
>your back)
You're right. I use DBase IV at work and every record has an internal record
number.
>
I am new to MySQL and I have a test database that I am playing with. Through
an accident while playing around, I ended up with two identicle records in
the database. I did a filter to try and change just one of them but both
would come up, so I couldn't see how I was supposed to delete just one of