Advertisement
Guest User

Untitled

a guest
Jul 12th, 2016
150
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 0.45 KB | None | 0 0
  1. #!/usr/bin/env python3.5
  2. import MySQLdb
  3.  
  4. db = MySQLdb.connect(host="localhost", # Der Host, Normalerweise localhost
  5. user="Muster", # Dein Nutzername
  6. password="muster" # Dein Passwort
  7. database="musterdb" # Name der Datenbank
  8.  
  9. # du musst ein Curser objekt erstellen
  10. cur = db.cursor()
  11.  
  12. # benutze jede SQL die du magst
  13. cur execute("SELECT * FROM DEIN_TABELLEN_NAME")
  14.  
  15. for row in cur.fetchall():
  16. print row[0]
  17.  
  18. db.close()
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement