Creating a Primary Key after table created
Posted on 2003-11-28
I am using PHPMyAdmin to administer my database and I am trying to add a primary key. The primary key did not come over in the conversion from Access to MySQL for some reason (used Access2MySQL program). When I attempt to add the primary key from PHPMyAdmin I get the error:
"#1171 - All parts of a PRIMARY KEY must be NOT NULL; If you need NULL in a key, use UNIQUE instead"
The problem is that there are no rows that have a null value in the column I am trying to declare as the primary key. When I do a SQL query that reads:
WHERE employee_id is NULL;
I get 0 rows returned. Anyone have any suggestions?
PS. The version of MySQL I am using is 3.23.53-max-nt ... if that makes any difference