mysql数据转换脚本（追加数据）详解

获取地址：

1	https://www.kaike.plus/upload/root/mysql/mysql_zuhe.sh
2	https://www.kaike.plus/upload/root/index.html

脚本功能：
将一张完整的数据表进行组合转换后输出到终端；
用户粘贴即可使用
注意：使用时数据需要保存至同一目录下 data文件中；执行后脚本的最终结果会存放至/tmp/mysql/zh/z2（未改动脚本类容）
执行效果：

cat <<a >data
+----+-------------+------+
| id | name        | age  |
+----+-------------+------+
|  1 | tom         |   20 |
|  2 | jerry       |   23 |
|  3 | wangqing    |   25 |
|  4 | sean        |   28 |
|  5 | zhangshan   |   26 |
|  6 | zhangshan   |   20 |
|  7 | lisi        | NULL |
|  8 | chenshuo    |   10 |
|  9 | wangwu      |    3 |
| 10 | qiuyi       |   15 |
| 11 | qiuxiaotian |   20 |
+----+-------------+------+
a
wget https://www.kaike.plus/upload/root/mysql/mysql_zuhe.sh
sh mysql_zuhe.sh
----------------------------------------------
|****请选择需要组合的数据(会按照循序组合)****|
----------------------------------------------
        1.[id]
        2.[name]
        3.[age] 
请输入数字、如2413：231
('tom','20','1'),('jerry','23','2'),('wangqing','25','3'),('sean','28','4'),('zhangshan','26','5'),('zhangshan','20','6'),('lisi','NULL','7')
,('chenshuo','10','8'),('wangwu','3','9'),('qiuyi','15','10'),('qiuxiaotian','20','11')
[root@kkd zz]# 
[root@kkd zz]# cat /tmp/mysql/zh/z2 
('tom','20','1')
('jerry','23','2')
('wangqing','25','3')
('sean','28','4')
('zhangshan','26','5')
('zhangshan','20','6')
('lisi','NULL','7')
('chenshuo','10','8')
('wangwu','3','9')
('qiuyi','15','10')
('qiuxiaotian','20','11')
[root@kkd zz]#