第八章shell操作数据库

1、处理如下文本中的数据，将数据插入到mkysql数据库
1010    jerry   1991-12-12  male
1011    jerry   1991-12-12  male
1012    jerry   1991-12-12  male
1013    jerry   1991-12-12  male
1014    jerry   1991-12-12  male
1015    jerry   1991-12-12  male
1016    jerry   1991-12-12  male
1017    jerry   1991-12-12  male


#!/bin/bash
#

user="dbuser"
password="123456"
host="192.168.184.132"


msql_conn="mysql -u"$user" -p"$passwd" -h"$host""

cat data.txt | while read id name birth sex
do
         if[$id -gt 1014];then
         $mysql_conn -e "Insert Into school.student1 values('$id','$name','$birth','$sex')"
     fi
done

需求2：将如下所示的数据插入到mysql数据库

2012|hao|1989-12-21|male
2012|hao|1989-12-21|male
2012|hao|1989-12-21|male
2012|hao|1989-12-21|male
2012|hao|1989-12-21|male



#!/bin/bash
#

user="dbuser"
password="123456"
host="192.168.184.132"

IFS="|"

cat data.txt | while read id name birth sex
do 
    mysql -u"$user" -p"$passwd" -h"$host" -e "Insert Into school.student1 values('$id','$name','$birth','$sex')"
done