defining primary key after table creation
| User, date | Message |
|---|---|
|
Written by landisd
6 years ago Category: General 7 posts since Sun, 06 May 07 |
How do I, using Heidi, define a field as a primary key after the table has already been created. Thanks Dan Landis |
|
Written by siMKin
6 years ago 104 posts since Sun, 01 Apr 07 |
right click any of the column-names and choose the option 'manage indexes' see also: http://www.heidisql.com/forum/viewtopic.php?t=228 |
|
Written by rando
6 years ago 1 posts since Sat, 29 Sep 07 |
Same problem. I have created a new field which I first want to be the primary key and then autoincrement field. When I try to set the field as primary key, I get twice an error message data truncated for column 'my field' at row 1. What is wrong? |
|
Written by jan
6 years ago 14 posts since Wed, 15 Aug 07 |
just remember, that the primary-key is unique. so when you want to add this key, the data in this row has to be unique. select id, count(*) from table group by id having count(*) <> 1 gives you all your dups. the primary-key has nothing to do with the auto-increment. but you can only set the auto-increment to an primary-column. so first, add the new column, then change/add the primary key to this column and then edit the column and set the auto-increment. |
|
Please login to leave a reply, or register at first. |