我的MySQL数据库中有一堆音乐数据,我需要将其复制到另一个MySQL,但只有选定的列(Artist、Song、Duration)。
MySQL 127.0.0.1-数据库Music
| Artist | Song | Duration | Location | Bitrate | Rating | Times Played |
------------------------------------------------------------------------------
| Bob | Song 1 | 11:06 | C:'b'1.mp3 | 160kbps | 5 | 132 |
| Jack | Song 7 | 0:06 | C:'j'7.mp3 | 160kbps | 2 | 10 |
| Mike | Song 3 | 3:06 | C:'m'3.mp3 | 128kbps | 4 | 150 |
| Mike | Song 5 | 5:06 | C:'m'5.mp3 | 128kbps | 1 | 222 |
| ------------------------------ 5000+ records ------------------------------|
SQLite 192.168.10.100-数据库Music
| Artist | Song | Duration |
------------------------------
| Bob | Song 1 | 11:06 |
| Mike | Song 3 | 3:06 |
| Mike | Song 5 | 5:06 |
|~~~~~~~ and so on... ~~~~~~~|
挑战在于复制Times Played
超过100+的三列,因此Jack
歌曲Song 7
不应该复制到新数据库中。
虽然我尝试将select
查询转储到database.sql
文件,并将其提供给SQLite,但每次都必须手动进行转储。相反,我需要一个可以每天CRON的PHP脚本。
基本方法:
INSERT INTO databese1.Music ( Artist , Song , Duration )
SELECT Artist , Song , Duration
FROM database2.Music
您将需要唯一地标识每个数据库