Example: To load username from /etc/passwd into a database table.
awk -F: '{print $1}' /etc/passwd > passwd_txt
cat passwd_txt | while read username; do echo "insert into {TABLE} (USERNAME,GROUPNAME,PRIORITY) values (""'$username'"", 'acct', 0);" >> users.sql; done;
No comments:
Post a Comment