At present, I’m struggling to find solution to either of the following problems:
- how to convert a normal array (indexed array with index starting at 0) into an associative array where value becomes a key and value itself is the value.
- Create a new assoc array from indexed array where values are keys. And this in a single statement. I know it can very well be done using a loop but for a huge sized array containing almost 500,000 elements, a loop is an overhead.
Create an assoc array from the result of mysql sql query. I normally create an indexed array from a mysql sql query result as below:
mapfile -t a_dummy <<< "$(mysql -u root –disable-column-names –silent -B -e "select * from dummy_tbl;" "$DB_NAME")
"
where $DB_NAME is the variable pointing to DB name string.