[BoF]____________________________________
#!/bin/bash
DEV=/dev/ttyUSB0
INDEX=`mysql -N -u root -ptoor -e 'use akutest;select no from testserial order by no desc limit 1;'`;
cat /dev/ttyUSB0 | while read DATA; do
if [[ -n $DATA ]];then
let INDEX=INDEX+1;
mysql -N -u root -ptoor -e "use akutest;insert into testserial(no,value) values($INDEX,\"$DATA\")";
#echo "$INDEX - $DATA";
fi
done
-------------------------------------------------------------