Hemanth's Scribes
web

Insert into mysql DB from text files

Author Photo

Hemanth HM

· 1 min read · .md
#!/bin/bash
#==================================================================
#          FILE:  insertDb.sh
#         USAGE:  ./insert.sh
#   DESCRIPTION:  Illustration of inserting data from text to DB
#        AUTHOR:  Hemanth H.M, hemanth.hm@gmail.com
#       VERSION:  1.0
#       CREATED:  03/06/2010 12:30:36 AM IST
#==================================================================
# Example scenario: assume a list with words and meanings with space
# as IFS, or two files with words in one and meanings in the other.
# sed -e 's/ /#/' list | awk -F "#" '{print $1}' > words
# sed -e 's/ /#/' list | awk -F "#" '{print $2}' > means

while read f1 <&7
do
  read f2 <&8
  mysql -uroot -proot dict <<< "insert into words values ('$f1','$f2');"
  # dict is the table
done 7<words 8<means
#bash#mysql#linux
Author Photo

About Hemanth HM

Hemanth HM is a Sr. Machine Learning Manager at PayPal, Google Developer Expert, TC39 delegate, FOSS advocate, and community leader with a passion for programming, AI, and open-source contributions.

100%