MySQL: Add Autoincrement Field?
| From: | Jeff Oien | Date: | Sat, 17 Feb 2001 01:10:08 +0000 |
| Subject: | MySQL: Add Autoincrement Field? | ||
| References: | 1 | Groups: | php.general |
| Request: | Send a blank email to php-general+get-40274@lists.php.net to get a copy of this message | ||
I have an existing database from a flat file that I
imported into a MySQL table. Some of the title
fields are duplicates - songs with the same name
from different song books. So if I want to delete
a record by title, I'll end up deleting all songs with
that title. Is there a way I can add a unique id field
and have it automatically generate a unique number to
each record? Hope that made sense.
Jeff Oien