Das deutsche Python-Forum

Code: Alles auswählen

#!/usr/bin/python
# -*- coding: utf-8 -*-

import MySQLdb as mdb

con = mdb.connect('localhost', 'user', 'passwort', 'testdb')

with con:
    
    cur = con.cursor()
    cur.execute("DROP TABLE IF EXISTS Writers")
    cur.execute("CREATE TABLE Writers(Id INT PRIMARY KEY AUTO_INCREMENT, \
                 Name VARCHAR(25))")
    cur.execute("INSERT INTO Writers(Name) VALUES('Jack London')")
    cur.execute("INSERT INTO Writers(Name) VALUES('Honore de Balzac')")
    cur.execute("INSERT INTO Writers(Name) VALUES('Lion Feuchtwanger')")
    cur.execute("INSERT INTO Writers(Name) VALUES('Emile Zola')")
    cur.execute("INSERT INTO Writers(Name) VALUES('Truman Capote')")

Code: Alles auswählen

Warning (from warnings module):
  File "/home/gutschy/.gimp-2.8/plug-ins/test2_mysql_connect.py", line 11
    cur.execute("DROP TABLE IF EXISTS Writers")
Warning: Unknown table 'Writers'

Code: Alles auswählen

mysql> SHOW TABLES;
+-------------------+
| Tables_in_testdb |
+-------------------+
| Writers           |
+-------------------+
1 rows in set (0.00 sec)