Output select query as insert statements

mysqlselectdump.sh

#!/bin/bash
# Output select query as insert statements
#
# Ex: insert all users from database1 into database2 but replace password with "dummy"
# ./mysqlselectdump username database1 "SELECT id, name, \"dummy\" as password FROM users" users password | mysql -u username -ppassword database2

USERNAME="$1"
DATABASE="$2"
QUERY="$3"
INSERTTABLE="$4"
PASSWORD="$5"
TEMPTABLE="mysqlselectdump_temp_table"

if [ "$INSERTTABLE" = "" ] ; then
	echo "Usage: $0 username database query insert_table [password]"
	exit
fi

if [ "$PASSWORD" = "" ] ; then
	read -s -p "Password: " PASSWORD
	# write new line on stderr
	echo 1>&2
fi

function q () {
	mysql -u "$USERNAME" "-p$PASSWORD" -e "$1" "$DATABASE"
}

q "DROP TABLE IF EXISTS \`$TEMPTABLE\`"
q "CREATE TABLE \`$TEMPTABLE\` $QUERY"
# dump and replace first temp table name occurence with insert table name
# remove --skip-extended-insert if you don't want one insert per line
# --complete-insert is important if inserting into existing table
mysqldump -u "$USERNAME" "-p$PASSWORD" --skip-extended-insert --skip-triggers --no-create-info --complete-insert "$DATABASE" "$TEMPTABLE" | sed -e "s/$TEMPTABLE/$INSERTTABLE/"
q "DROP TABLE IF EXISTS \`$TEMPTABLE\`"