Advertisement
Guest User

Untitled

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