At 12:03 AM 4/22/2010, Aveek Misra wrote:
I have a InnoDB table which contains columns named 'cluster' and 'file'
('cluster' + 'file' is a primary key). I want to add a new column that
tracks the revision number of a file for a given cluster and a file. The
situation is tailor made for a MyIsam table where I can add a new Auto
Increment column as a secondary column in a multiple column index. How can
I get the same behavior in an InnoDB table? Given below is a view of how
the records will look like
--------------------------------------------------------
| Cluster | File | Rev |
--------------------------------------------------------
| clusterA | fileA | 1 |
--------------------------------------------------------
| clusterA | fileA | 2 |
---------------------------------------------------------
| clusterB | fileA | 1 |
--------------------------------------------------------
| clusterB | fileB | 1 |
--------------------------------------------------------
Aveek,
You should be able to add an autoincrement field to a compound key if
the autoinc field is the first field of the compound key. This probably
doesn't help you though.
Mike
Thanks
Aveek
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/mysql?unsub=mo...@fastmail.fm
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/mysql?unsub=arch...@jab.org
