shell excel导入mysql_mysql用shell建100多字段表并导入

excel列超过160多个，导入时报错，把excel第一行另存为逗号分隔的csv文件，用shell建表

vim createTable.sh

#!/bin/sh

str="CA6430M,HMC6432,HMC6433E,HMC6433EE3A,HMC6433A4M0,HMC6433C3M0,HMC6433C4M0,HMC6434A3M0,HMC6434A4M0,HMC6440A4T0,HMC6445B3,HMC6445B4,HMC6445E4M0,HMC6446B4M0,HMC6446C4M0,HMC6446D4M0,HMC6446E4M0,HMC6446F4M0,HMC7000EVM0,HMC7132A4H0,HMC7133C4H0,HMC7133A4H0,HMC7134B4S0,HMC7134C4S0,HMA7150DA4F,HMA7150DA4W,HMA7150DB4W,HMA7150DA4AW,HMA7150DB4BW,HMA7150DC4AW,HMA7150DC4F,HMC7151A4H0,HMC7151B4H0,HMC7151C4H0,HMC7151D4H0,HMC7152A4H0,HMC7152C4H0,HMC7154B4S0,HMC7154C4S0,HMC7160A3S0,HMC7160A4S0,HMC7160B3S0,HMC7160B3S1,HMC7160B4S0,HMC7160B4S1,HMC7160C3S0,HMC7161,HMC7161E3,HMC7161E3A,HMC7161E3B,HMC7161B,HMC7161BE3A,HMC7161BE3B,HMC7162A,HMC7162AE3,HMC7162AE3A,HMC7162AE3B,HMC7163,HMC7163E3A,HMC7163A3S1,HMC7163A4S0,HMC7164B3S0,HMC7164B4S0,HMC7164D4S0,HMC7164E4S0,HMC7165A4S0,HMC7165A4S1,HMC7165D4S1,HMC7165E4S1,HMC7165F3H0,HMC7165F4H0,HMC