[sqlite] sqlite in shell loop

[Daniel Wolny]

Hi,
Is possible to use sqlite in shell for loop?

eg.
#!/bin/sh

for i in `sqlite db "SELECT smt FROM db"`
do
      echo "$i" DUPA
done

I want to act sqlite like any other command in for loop, i mean one
record from db as a one iteration, above will display:

first1 first2
second1 second2 DUPA

I want something like this:
first 1 first2 DUPA
second1 second2 DUPA

Thanks in advance
_______________________________________________
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users