12 / 2 页

论坛徽章:: 0

11楼 [报告]

发表于 2015-07-31 11:01 |只看该作者

回各位，我想要做的是把这个txt文件中，用shell取第二行每一列的值，然后在mysql库里建bbbc的表，表内的列名就是txt第二行里LV NAME，LPs，PPs，DISTRIBUTION，MOUNT POINT，然后再读下面的数据，写入对应的列中，想得到的数据库bbbc表的样子是：
列名：LV NAME LPs PPs DISTRIBUTION MOUNT POINT
第一行：hd10opt 32 32 28..00..04..00..00 /opt

实战分享：从技术角度谈机器学习入门| 【大话IT】RadonDB低门槛向MySQL集群下战书 | ChinaUnix打赏功能已上线！ | 新一代分布式关系型数据库RadonDB知多少？

tuyajie

家境小康

论坛徽章:: 7

12楼 [报告]

发表于 2015-07-31 11:19 |只看该作者

本帖最后由 tuyajie 于 2015-07-31 11:25 编辑

sed '1d' test | sed 's/^[^,]*,[^,]*,//' | awk 'BEGIN{getline;print "create table yourTableName ("$1" String,"$2" String,"$3" String,"$4" String,"$5" String,);"}{print "insert into yourTableName values (\""$1"\",\""$2"\",\""$3"\",\""$4"\",\""$5"\");"}'
create table yourTableName (LV String,NAME String,LPs String,PPs String,DISTRIBUTION String,);
insert into yourTableName values ("hd10opt","32","32","28..00..04..00..00","/opt");
insert into yourTableName values ("hd2","71","71","00..04..31..36..00","/usr");
insert into yourTableName values ("hd9var","84","84","00..46..38..00..00","/var");
insert into yourTableName values ("hd3","80","80","00..00..80..00..00","/tmp");
insert into yourTableName values ("hd1","1","1","00..00..01..00..00","/home");
insert into yourTableName values ("hd5","1","1","01..00..00..00..00","N/A");
insert into yourTableName values ("hd6","11","11","00..04..00..00..07","N/A");
insert into yourTableName values ("hd8","1","1","00..00..01..00..00","N/A");
insert into yourTableName values ("hd4","3","3","00..00..03..00..00","/");
insert into yourTableName values ("Plv_cicsregion","16","16","00..16..00..00..00","/var/cics_regions");
insert into yourTableName values ("Plv_cicsserver","8","8","08..00..00..00..00","/var/cics_servers");
insert into yourTableName values ("log_SFS_01","2","2","02..00..00..00..00","N/A");
insert into yourTableName values ("sfs_SFS_01","2","2","02..00..00..00..00","N/A");
insert into yourTableName values ("oralv","232","232","115..00..00..00..117","/u01");
insert into yourTableName values ("lg_dumplv","8","8","00..08..00..00..00","N/A");
insert into yourTableName values ("livedump","2","2","00..02..00..00..00","/var/adm/ras/livedump");
insert into yourTableName values ("fslv00","80","80","00..80..00..00..00","/software");
insert into yourTableName values ("waslv","160","160","04..00..00..124..32","/websphere");
insert into yourTableName values ("hd11admin","1","1","00..00..01..00..00","/admin");