shell管道的使用

  1 #!/bin/bash
  2 sqlite3 contact.db << !
  3 drop table contact;
  4 create table contact (
  5     name   char(32),
  6     address char(32)
  7     );
  8 insert into contact(address,name) values("jiangshang","wuxi");
  9 !
 10 echo 'select *from contact;'|sqlite3 contact.db|awk 'BEGIN{FS="|"} {print "N    ame",$1,"Address",$2}' ;
~ 

 

#!/bin/bash
echo "select * from contact ;" | sqlite3 contact.db | awk '
BEGIN { FS="|" ;OFS=",";}
{print "\""$1"\"","\""$2"\"";}
'

#"test","test"
#"ddd","ddd"