mysql快速添加百万条记录的语句

原文链接

//书籍 
INSERT INTO tbl_cp_bookchapter_history (type,book_id,chapter_id,ctime)  
SELECT '11', id, null, now() 
FROM tbl_cp_book  
//章节 
INSERT INTO tbl_cp_bookchapter_history (type,book_id,chapter_id,ctime)  
SELECT '21', book_id, id, now() 
FROM tbl_cp_chapter  

//一本书的初始化，若book_id=100 
INSERT INTO tbl_cp_bookchapter_history (type,book_id,chapter_id,ctime)  
SELECT '11', '100', null, now() 
FROM tbl_cp_book  

INSERT INTO tbl_cp_bookchapter_history (type,book_id,chapter_id,ctime)  
SELECT '21', '100', id, now() 
FROM tbl_cp_chapter where book_id = '100'