- select song,singer,remark,movie from movie_song_v2 where singer<>’-’ and id>310 into outfile ‘/var/lib/mysql-files/1_3_origin.txt’;
- 找出歌手不存在的数据,删除&,找出以\来分隔的多个歌手
- 将、替换为,
awk -F'\t' '{print $1"\t"$1"\t""{\"singer\":\""$2"\",\"remark\":\""$3"\",\"television\":\""$4"\"}"}' 1_3_origin.txt > movie_song_1_3.txt