#!/bin/bash
user=“root”
password=“123456”
host=“172.16.7.59”
IFS="t"
cat dir_finally.txt | while read id name
do
mysql -u"
u
s
e
r
"
−
p
"
user" -p"
user"−p"password" -h"
h
o
s
t
"
−
e
"
I
N
S
E
R
T
I
N
T
O
t
e
s
t
.
p
h
o
t
o
d
i
r
（
d
i
r
,
n
a
m
e
)
v
a
l
u
e
s
(
′
host" -e "INSERT INTO test.photo_dir（dir,name) values('
host"−e"INSERTINTOtest.photodir（dir,name)values(′id’,’$name’)"
done
