Раздел диска при двойной загрузке Ubuntu 14.04 на Windows 10

awkрешение:

awk -F, '{ printf("update systemx.thetable set username=\047%s\047,password=\047%s\047,
           payment=\047paid\047,paidDate=\047%s\047,token=\047init\047 
           where username=\047%s\047;\n",$2,$3,$4,$1) }' file

Вывод:

update systemx.thetable set username='paidUser1',password='paidPasswd1',payment='paid',paidDate='paidDate1',token='init' where username='trialuser1';
update systemx.thetable set username='paidUser2',password='paidPasswd2',payment='paid',paidDate='paidDate2',token='init' where username='trialuser2';
update systemx.thetable set username='paidUser3',password='paidPasswd3',payment='paid',paidDate='paidDate3',token='init' where username='trialuser3';
update systemx.thetable set username='paidUser4',password='paidPasswd4',payment='paid',paidDate='paidDate4',token='init' where username='trialuser4';
update systemx.thetable set username='paidUser5',password='paidPasswd5',payment='paid',paidDate='paidDate5',token='init' where username='trialuser5';
1
08.11.2015, 07:19
0 ответов

Теги

Похожие вопросы