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
In this video, Percona Solution Engineer Dimitri Vanoverbeke discusses why you want to use at least three nodes in a database cluster.
To discuss how Percona Consulting can help with your design and architecture needs for your database and infras…
In this video, Percona Solution Engineer Rick Golba discuss how (and why) you implement high availability in a database environment.
To discuss how Percona Consulting can help with your design and architecture needs for your database and infrastr…