MySql将一个表的数据复制到另外一张表

MySql将一个表的数据复制到另外一张表（表结构相同）同一个库中进行复制INSERT INTO book_copy SELECT * FROM book (全部复制);INSERT INTO book_copy SELECT DISTINCT * FROM book (不复制重複的);INSERT INTO book_copy SELECT * FROM book ORDER BY i...

猿梦之秃

11773人浏览 · 2019-05-15 17:59:51

猿梦之秃 · 2019-05-15 17:59:51 发布

MySql将一个表的数据复制到另外一张表（表结构相同）

同一个库中进行复制
INSERT INTO book_copy SELECT * FROM book (全部复制);
INSERT INTO book_copy SELECT DISTINCT * FROM book (不复制重複的);
INSERT INTO book_copy SELECT * FROM book ORDER BY id LIMIT 2 ;(复制前2条)
不同库中的表进行复制
INSERT INTO eval.report_class_parent_score_interval SELECT * FROM eval_back.report_class_parent_score_interval; *(全部复制)
同理。。