How to use a bash script to write to a mysql table

Question

I'm using a bash script to pull data from online sources. Right now I just have it writing to a text file, but it would be better if the script could automatically put this data into mysql tables. How can this be done? Examples would be helpful.

Shiplu Mokaddim · Accepted Answer · 2012-01-26 23:07:53Z

3

Suppose you download a .csv file. which has header and have a database test in mysql.

Download the file first.

     wget http://domain.com/data.csv -O data.csv

Dump the data to mysql table tbl

     cat <<FINISH | mysql -uUSERNAME -pPASSWORD test
         LOAD DATA INFILE 'data.csv' INTO TABLE `tbl`
         FIELDS TERMINATED BY ',' ENCLOSED BY '"' 
         LINES TERMINATED BY '\r\n' 
         IGNORE 1 LINES;
     FINISH

Here USERNAME must have FILE privilege.

answered Jan 26, 2012 at 23:07

Shiplu Mokaddim

57.8k20 gold badges147 silver badges193 bronze badges

Sign up to request clarification or add additional context in comments.

Comments

clime · Accepted Answer · 2012-01-26 23:06:54Z

2

You can use bash like this:

#!/bin/bash

params="dbname -uuser -ppassswd"

echo "SELECT * FROM table;" | mysql $params
# or 
mysql $params <<DELIMITER
SELECT * FROM table;
DELIMITER

answered Jan 26, 2012 at 23:06

clime

8,92610 gold badges64 silver badges84 bronze badges

Collectives™ on Stack Overflow

How to use a bash script to write to a mysql table

2 Answers 2

Comments

Comments

Linked

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

Comments

Comments

Linked

Related