Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- #!/bin/bash
- read col1 col2 col3 ... coln <<<
- $(mysql -u username -ppassword databasename -sse
- "select col1,col2,col3,...coln from table where ..." 2>/dev/null)
- # do something with $col1, $col2...
- mysql -u username -ppassword databasename -sse
- "update table set col1=..., col2=... where ..." 2>/dev/null
- [mysql]
- user=user
- password=password
Add Comment
Please, Sign In to add comment