Noor Chaudhry
Reputation: 73
Convert a CSV to MySQL update statement in Bash
How do I convert CSV file to MySQL update statement in Bash? I can convert it to a INSERT statement, but I want to convert it to update statement and add it to an existing row.
Upvotes: 0
Views: 273
Answers (2)
Bernd Buffen
Reputation: 15057
Import the csv in a new table. update the main table with the new data. remove the new table
Upvotes: 0
robbymarston
Reputation: 356
What exactly are you trying to accomplish? If you simply want to import a mysqldump you can use mysqlimport. See http://dev.mysql.com/doc/refman/5.7/en/mysqlimport.html for more information.
Upvotes: 1
Related Questions
- How do I get the directory where a Bash script is located from within the script itself?
- Looping through the content of a file in Bash
- Echo newline in Bash prints literal \n
- How can I check if a program exists from a Bash script?
- Extract filename and extension in Bash
- How to import an SQL file using the command line in MySQL?
- How do I tell if a file does not exist in Bash?
- How do I check if a directory exists or not in a Bash shell script?
- How to redirect and append both standard output and standard error to a file with Bash
- How to check if a string contains a substring in Bash