Import csv to mysql

Automated csv import to mysql server

#!/bin/bash
IMPORTED_FILE_PATH=/path/to/your/imported/file.csv
TABLENAME=target_table_name
DATABASE=db_name
TMP_FILENAME=/tmp/${TABLENAME}.cvs
# do nothing if imported file does not exist
[ -f "$IMPORTED_FILE_PATH" ] || exit 0
# if temporary file exists, then it means previous import job is running. Also do nothing
[ -f "$TMP_FILENAME" ] && exit 0
# Move it to tmp and rename to target table name
mv "$IMPORTED_FILE_PATH" "$TMP_FILENAME"
mysqlimport --user=mysqlusername --password=mysqlpassword --host=mysqlhost --local $DATABASE $TMP_FILENAME
rm -f "$TMP_FILENAME"

Source: stackoverflow.com

Similar codes

1 vote288 views1 answer
Alphabetical order mysql
SQL
4 votes288 views1 answer
Sql any
SQL
0 vote289 views4 answers
Mysql on kubernetes
SQL
2 votes312 views1 answer
Where clause for child record apex
SQL
2 votes317 views3 answers
How to check current user in mySQL
SQL
0 vote300 views1 answer
Name '_mysql' is not defined
SQL
1 vote273 views1 answer
Mysql count words
SQL
-1 vote326 views1 answer
Add 10 to all numbers in a column sql
SQL
1 vote277 views1 answer
Oracle sql assign unique number to each grouping
SQL
-1 vote275 views1 answer
MYSQL stored procedure select from
SQL