深圳网站制作业务咨询
0755-61603557
赵先生：13714247375
0755-61603557
赵先生：13714247375
1
2
3
4
5
6
7
8
9
10
11
|
CREATE TABLE `books` (`id` INT(11) NOT NULL AUTO_INCREMENT,`name` VARCHAR(200) NOT NULL,PRIMARY KEY (`id`),UNIQUE KEY `NewIndex1` (`name`)) ENGINE=InnoDB DEFAULT CHARSET=utf8; |
1
|
INSERT IGNORE INTO books (name) VALUES (MySQL Manual) |
1
|
INSERT INTO books (name) VALUES (MySQL Manual) ON duplicate KEY UPDATE id = id |
1
|
INSERT INTO books (name) SELECT MySQL Manual FROM dual WHERE NOT EXISTS (SELECT id FROM books WHERE id = 1) |
1
|
REPLACE INTO books SELECT 1, MySQL Manual FROM books |
