22 January 2011

LINUX - Loading data into database table

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:

Wordpress - Local installation in Vmware

If you're interested in exploring website design with WordPress, this guide will help you set up a WordPress instance on your local mach...