mysql - phpMyAdmin #1062 - key '' 的重复条目 'PRIMARY'

Question

我在做作业时遇到了一些麻烦，有人可以帮我吗

我需要做什么来解决这个问题，我不断收到 #1062 错误消息

-- phpMyAdmin SQL Dump
-- version 4.2.9.1
-- http://www.phpmyadmin.net
--
-- Host: localhost
-- Generation Time: March 04, 2015 at 15:00
-- Server version: 5.6.22-log
-- PHP Version: 5.5.15-pl0-gentoo

SET SQL_MODE = "NO_AUTO_VALUE_ON_ZERO";
SET time_zone = "+00:00";


/*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */;
/*!40101 SET @OLD_CHARACTER_SET_RESULTS=@@CHARACTER_SET_RESULTS */;
/*!40101 SET @OLD_COLLATION_CONNECTION=@@COLLATION_CONNECTION */;
/*!40101 SET NAMES utf8 */;

--
-- Database: `mydb1931`
--

-- --------------------------------------------------------

--
-- Table structure for table `Present Cast`
--

CREATE TABLE IF NOT EXISTS `Present Cast` (
  `Character` varchar(100),
  `Actor(s)` varchar(100),
  `Duration` varchar(100)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

--
-- Dumping data for table `Present Cast`
--

INSERT INTO `Present Cast` (`Character`, `Actor(s)`, `Duration`) VALUES
('Tony Hutchinson', 'Nick Pickard', '1995-'),
('Cindy Cunningham', 'Stephanie Waring', '1995-2001, 2002'),
(NULL, 'Laura Crossley', '2004, 2008-'),
('Jack Osborne', 'Jimmy McKenna', '1996-'),
('Darren Osborne', 'Ashley Taylor Dawson', '1996-97, 1999-2000'),
(NULL, 'Adam Booth', '2003-'),
('Holly Cunningham', 'Amanda Clapham', '1997-2001'),
(NULL, 'Wallis Day', '2002, 2004'),
(NULL, 'Lydia Waters', '2008-10'),
(NULL, 'Karis Sharkey', '2012-'),
('Tom Cunningham', 'Ellis Hollins', '1999-'),
('Frankie Osborne', 'Helena Pearson', '2002-'),
('Nancy Hayton', 'Jessica Fox', '2006-'),
('Ste Hay', 'Kieron Richardson', '2006-'),
('Mercedes McQueen', ' Jennifer Metcalfe', '2006-'),
('Myra McQueen', 'Nicole Barber-Lane', '2006-'),
('John Paul McQueen', 'James Sutton', '2006-08, 2012-'),
('Charlie Dean', 'Charlie Beham', '2006-'),
(NULL, 'Joshua McConville', NULL),
('Leah Barnes', 'Ela-May Dermican', Null),
(NULL, 'Jessica Croft-Lane', '2007-'),
(NULL, 'Magic Hurst', NULL),
('Nana McQueen', 'Diane Langton', '2007-09, 2012-'),
('Harry Thompson', 'Parry Glasspool', NULL),
(NULL, 'Harrison George Rhodes','2007-09, 2015-'),
(NULL, 'Daniel Seymour', NULL),
('Theresa McQueen', 'Jorgie Porter', '2008-'),
('Lucas Hay', 'William Hall', NULL),
(NULL, 'Reuben Thwaites', '2009-'),
(NULL, 'Jude Hawley', NULL),
('Sinead O Connor', 'Stephanie Davis', '2010-'),
('Diane O Connor', 'Alex Fletcher', '2010-'),
('Esther Bloom', 'Jazmine Franks', '2011-'),
('Dirk Savage', 'David Kennedy', '2011-'),
('Phoebe McQueen', 'Mandip Gill', '2012-'),
('Maxine Minniver', 'Nikki Sanderson', '2012-'),
('Sienna Blake', 'Anna Passey', '2012-'),
('Patrick Blake', 'Jeremy Sheffield', '2012-'),
('Robbie Roscoe', 'Charlie Wernham', '2013-'),
('Trevor Royle', 'Greg Wood', '2013-'),
('Freddie Roscoe', 'Charlie Clapham', '2013-'),
('Jason Roscoe', 'Alfi Browne-Sykes', '2013-'),
('Joe Roscoe', 'Ayden Callaghan', '2013-'),
('Ziggy Roscoe', 'Fabrizio Santino', '2013-'),
('Lindsey Butterfield', 'Sophie Austin', '2013-'),
('Peri Lomax', ' Ruby O Donnell', '2013-'),
('Tegan Lomax', 'Jessica Ellis', '2013-'),
('Leela Lomax', 'Kirsty-Leigh Port', '2013-'),
('Grace Black', 'Tamara Wall', '2013-'),
('Nico Blake', 'Persephone Swales-Dawson', '2014-'),
('Cameron Campbell', 'Cameron Moore', '2014-'),
('Kim Butterfield', 'Daisy Wood-Davis', '2014-'),
('Dr. Charles Savage', 'Andrew David Grennough', '2014-'),
('Lockie camobell', 'Nick Rhys', '2014-'),
('Porsche McQueen', 'Twinnie Lee Moore', '2014-'),
('Celine McQueen', 'Sarah George', '2014-'),
('Dylan Jenkins', 'James Fletcher', '2015-'),
('Cleo McQueen', 'Nadine Mulkerrin', '2015-');

-- --------------------------------------------------------
--
-- Indexes for table `Present Cast`
--
 ALTER TABLE `Present Cast`
 ADD PRIMARY KEY (`Character`);

/*!40101 SET CHARACTER_SET_CLIENT=@OLD_CHARACTER_SET_CLIENT */;
/*!40101 SET CHARACTER_SET_RESULTS=@OLD_CHARACTER_SET_RESULTS */;
/*!40101 SET COLLATION_CONNECTION=@OLD_COLLATION_CONNECTION */;

我不断收到一条错误消息，内容为

#1062 - Duplicate entry '' for key 'PRIMARY'

感谢任何提供帮助的人:)

Answer 1

字符列值至少在两行中使用 NULL，并且您将表的主键设置为字符列。

根据定义，如果某列是主键，则该列的值必须对于所有行都是唯一的。

要解决此问题，您需要为当前其字符列值具有 NULL 值的每一行设置唯一的字符值。