I am interested in how I add an id field to a table and make it auto
Basically at the moment I have a link table with groups_members
I am changing this to a membership table
I could delete groups_members and create memberships however, this
would mean losing all the data that already exists in the table. (NOT
GOOD) instead I would like the id field to auto increment and the
title and position fields to be default "".
Does anyone know how to do this? I had one idea. Save all the current
records in array, delete old table recreate new table reinsert all
data. Is there an easier way!!