August 6th, 2000, 03:13 PM
Join Date: Jun 2000
Time spent in forums: < 1 sec
Reputation Power: 14
I have this problem that's starting to get on my nerv. I am going to add a new column to my table called topics, but they keep giving me the error "ERROR 1062: Duplicate entry '4' for key 2"
The table format is as followed.
topic_id | int(11) | | PRI
parent_id | int(11) | | MUL
root_id | int(11) | YES |
name | varchar(255) | | MUL
description | text | YES |
create_dt | timestamp(14) | YES |
modify_dt | timestamp(14) | YES |
author | varchar(255) | YES |
author_host | varchar(255) | YES |
and I gave the following command :
alter table topics add posts integer;
Can someone pls help me out?
Thanks in advance.