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

0 vote182 views2 answers
CREATE OR REPLACE FUNCTION
SQL
1 vote145 views2 answers
Mssql show database size
SQL
0 vote185 views1 answer
Liquibase update row
SQL
0 vote136 views1 answer
Get all employee of salary if more than in sql
SQL
0 vote151 views1 answer
Get the previous column of a table in mysql
SQL
1 vote147 views1 answer
Sql run multiple updates in one query
SQL
1 vote101 views1 answer
Athena query timestamp greater than
SQL
0 vote154 views1 answer
Query params sql insert python f string
SQL
0 vote199 views1 answer
Fetching data from mysqldb
SQL
2 votes100 views1 answer
Mysql admin u root p password change password
SQL