As you might expect, affecting the creation and deletion of databases and tables in Python is very similar to MySQL when using MySQL for Python. There are some differences as we shall see in this section.
For the following examples, we will work with the following code being assumed:
import MySQLdb mydb = MySQLdb.connect('localhost', 'skipper', 'secret', 'csv') cur = mydb.cursor()
Cursor.execute() shows the number of affected rows in previous commands, whether
SELECT, it always returns a
0 value for the
CREATE command of a database:
Consequently, passing the output of the method to a variable will result in that variable equating to 0:
>>> res = cur.execute("CREATE ...