I am trying to convert the output of
ps awux
into 11 fields with the headers eliminated and then importing that output into an existing table in SQL.
2 Answers
for line in $(ps auwx | sed -e 's/\ \+/\",\"/g'); do
echo "insert into tbl_name values(\"$line\")";
done | mysql
-
have to be more careful when the command column contains whitespaceglenn jackman– glenn jackman2015-11-10 18:56:00 +00:00Commented Nov 10, 2015 at 18:56
-
@glennjackman Yup...that would break things, wouldn't it. Short of a messy
awkscript you're probably going to have to break this out into a real scripting language.David King– David King2015-11-10 19:01:27 +00:00Commented Nov 10, 2015 at 19:01 -
Also, don't read lines with "for": mywiki.wooledge.org/DontReadLinesWithForglenn jackman– glenn jackman2015-11-10 19:06:43 +00:00Commented Nov 10, 2015 at 19:06
You can remove the first line with sed 1d
You can create the values list with
sql=$(
echo "$line" | sed "
s/'/''/g
s/[[:space:]]\+/','/ # 1
s/[[:space:]]\+/','/ # 2
s/[[:space:]]\+/','/ # 3
s/[[:space:]]\+/','/ # 4
s/[[:space:]]\+/','/ # 5
s/[[:space:]]\+/','/ # 6
s/[[:space:]]\+/','/ # 7
s/[[:space:]]\+/','/ # 8
s/[[:space:]]\+/','/ # 9
s/[[:space:]]\+/','/ # 10
s/^/INSERT INTO table_name VALUES ('/
s/$/');/
"
)
answered Nov 10, 2015 at 19:04
