Advertisement
Guest User

Untitled

a guest
May 28th, 2017
73
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
Bash 0.41 KB | None | 0 0
  1. # Promenne pro pripojeni k MySQL
  2. DB_USER="root"
  3. DB_PASS="dmmysql"
  4. DB_HOST="localhost"
  5. DATABASE="administrace"
  6. TABULKA="uzivatele"
  7. MYSQL="mysql -h$DB_HOST -N -u$DB_USER -p$DB_PASS -D $DATABASE"
  8.  
  9. RADKU=$($MYSQL <<< "SELECT COUNT(*) AS id FROM $TABULKA")
  10.  
  11. for i in `seq 1 $RADKU`
  12. do
  13.    ID=$($MYSQL <<< "SELECT id FROM $TABULKA WHERE id=$i")
  14.    IP=$($MYSQL <<< "SELECT ip FROM $TABULKA WHERE id=$ID")
  15. done
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement