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 vote214 views1 answer
Oracle drop job if exists
SQL
1 vote204 views1 answer
Declare table variable
SQL
5 votes241 views2 answers
Create table mysql example auto_increment
SQL
10 votes213 views3 answers
How to fetch first 5 characters in sql
SQL
0 vote196 views1 answer
How to start my sql server on mac
SQL
0 vote207 views1 answer
Aktor yang pernah terlibat di film bergenre Aksi di sql
SQL
0 vote301 views1 answer
Contraint default SQL
SQL
0 vote255 views1 answer
Capabilities of sql select statements
SQL
1 vote277 views1 answer
Sql sort column by date
SQL
7 votes252 views1 answer
Query delete duplicates
SQL