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 vote206 views1 answer
Get last three characters in mysql column
SQL
1 vote177 views1 answer
Import in mysql without a software
SQL
14 votes198 views1 answer
Sql value of string
SQL
0 vote179 views1 answer
Postgres get running query
SQL
1 vote208 views1 answer
Write an SQL query to print details of the Workers whose FIRST_NAME ends with ‘h’ and contains six alphabets.
SQL
1 vote199 views2 answers
Mysql show views
SQL
0 vote192 views1 answer
Connect to ssms with python
SQL
1 vote183 views1 answer
Set statiscis on in sql server
SQL
0 vote190 views1 answer
Create a PostgreSQL user django on mac
SQL
1 vote205 views1 answer
Print year of a date sql
SQL