09/05/10 21:11:34
#!/usr/bin/bash
sql()
{
mysql --user=root --password=password -e "USE jinji_kanri; $1"
}
o=$(sql "
SELECT
*
FROM
tbl_employee
WHERE
dpt_code <> 10;
")
echo "$o" | awk '$1 ~ /^104/{print}'
09/05/10 21:11:34
#!/usr/bin/bash
sql()
{
mysql --user=root --password=password -e "USE jinji_kanri; $1"
}
o=$(sql "
SELECT
*
FROM
tbl_employee
WHERE
dpt_code <> 10;
")
echo "$o" | awk '$1 ~ /^104/{print}'