mysql insert into插入数据实例讲解

首先创建一张books表：

CREATE TABLE IF NOT EXISTS `books` (
  `BookID` smallint(6) NOT NULL,
  `Book ` varchar(60) NOT NULL,
  `Copyright` year(4) NOT NULL,
  PRIMARY KEY (`BookID`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

再向books表中插入几条数据，这里我们有两种方法：

1. 一条一条的插入数据
2. 批量插入数据

下面来看如何实现：

1.一条一条的插入数据，代码如下：

INSERT INTO `books` (`BookID`, `Book `, `Copyright`) VALUES (12786, \'Java\', 1934);
INSERT INTO `books` (`BookID`, `Book `, `Copyright`) VALUES (13331, \'MySQL\', 1919);
INSERT INTO `books` (`BookID`, `Book `, `Copyright`) VALUES (14356, \'PHP\', 1966);
INSERT INTO `books` (`BookID`, `Book `, `Copyright`) VALUES (15729, \'PERL\', 1932);
INSERT INTO `books` (`BookID`, `Book `, `Copyright`) VALUES (16284, \'Oracle\', 1996);

2.批量插入数据

INSERT INTO `books` (`BookID`, `Book `, `Copyright`) VALUES
(12786, \'Java\', 1934),
(13331, \'MySQL\', 1919),
(14356, \'PHP\', 1966),
(15729, \'PERL\', 1932),
(16284, \'Oracle\', 1996),
(17695, \'Pl/SQL\', 1980),
(19264, \' \', 1992),
(19354, \'www.manongjc.com\', 1993);