Simple bash example to store the output of a MySQL query in an array: dbquery=$(mysql -u username -p password -e "use table; select field from table;") array=( $( for i in $dbquery ; do echo $i ; done ) )...
Instead of writing a script to pull in information from a CSV file, you can link MYSQL directly to it and upload the information using the following SQL syntax. To import an Excel file into MySQL, first export it as a CSV file. Remove the CSV headers from the generated CSV file along with empty [...]