Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- mysql < echo "query"
- mysql --host=localhost --user=user --password=password < echo "CREATE USER 'testuser'@'localhost' IDENTIFIED BY 'jakdJxct8W';
- CREATE DATABASE IF NOT EXISTS 'testuser_dev' DEFAULT CHARACTER SET utf8 COLLATE utf8_bin;
- GRANT ALL PRIVILEGES ON 'testuser_dev' . * TO 'testuser'@'localhost';
- CREATE DATABASE IF NOT EXISTS 'testuser_qa' DEFAULT CHARACTER SET utf8 COLLATE utf8_bin;
- GRANT ALL PRIVILEGES ON 'testuser_qa' . * TO 'testuser'@'localhost';"
- echo "select 1" | mysql
- mysql --batch --silent -e 'SHOW TABLES';
- mysql --host=localhost --user=user --password=password << END
- CREATE USER 'testuser'@'localhost' IDENTIFIED BY 'jakdJxct8W';
- CREATE DATABASE IF NOT EXISTS 'testuser_dev' DEFAULT CHARACTER SET utf8 COLLATE utf8_bin;
- GRANT ALL PRIVILEGES ON 'testuser_dev' . * TO 'testuser'@'localhost';
- CREATE DATABASE IF NOT EXISTS 'testuser_qa' DEFAULT CHARACTER SET utf8 COLLATE utf8_bin;
- GRANT ALL PRIVILEGES ON 'testuser_qa' . * TO 'testuser'@'localhost';
- END
- mysql --host=localhost --user=user --password=password < commands.sql
- echo "YOURQUERYSTRINGHERE">tmpfile
- mysql --host=localhost --user=user --password=password dbname <tmpfile
- mysql --host=localhost --user=user --password=password -e "QUERY" dbname
- QUERY="select * from $MYTABLE WHERE name="silly@place.com";"
- mysql --host=localhost --user=user --password=password -e "$QUERY" mydbname
- echo "$QUERY"|mysql --host=localhost --user=user --password=password mydbname
- read -d '' SQL_QUERY_1 << EOF
- SELECT prod.id as id, prod.title as title, comp.name as company, pho.id as photo_id, pho.image as photo_name
- FROM products as prod
- JOIN accounts as comp
- ON comp.id = prod.account_id
- JOIN photos as pho
- ON pho.id = prod.featured_photo_id;
- EOF
- echo ${SQL_QUERY_1} | mysql
Add Comment
Please, Sign In to add comment