Python Phrasebook - Essential Code and Commands by By Brad Dayley

Author:By Brad Dayley
Language: eng
Format: azw3, mobi
ISBN: 0672329107
Publisher: Sams
Published: 2015-04-10T16:49:05.878000+00:00

MySQL_create.py

(('arrivals',),) (('city', 'text', 'YES', '', None, ''), ('flight', 'text', 'YES', '', None, ''), ('time', 'text', 'YES', '', None, ''))

Output from MySQL_create.py code

Adding Entries to a MySQL Database

import MySQLdb myDB = MySQLdb.connect(host="127.0.0.1", port=3306, db="schedule") cHandler = myDB.cursor() sqlCommand = "INSERT INTO Arrivals \ VALUES('%s', '%s', '%s')" % \ (city, flights[x], times[x]) cHandler.execute(sqlCommand) myDB.commit()

Once you have connected to a MySQL database and got a SQL command cursor object, adding entries to the database is just a matter of sending the appropriately formatted SQL commands to the server.

First, connect to the server using the MySQLdb modules connect function, and then use the MySQL database object to get a cursor object. In the sample code, entries are added one at a time by executing the INSERT INTO <tablename> VALUES (<data value>) SQL command using the execute function of the cursor object.

Note

Remember to use the commit() function of the cursor object to flush pending requests to the SQL database so that the changes will be written to disk.

Download

Copyright Disclaimer:
This site does not store any files on its server. We only index and link to content provided by other sites. Please contact the content providers to delete copyright contents if any and email us, we'll remove relevant links or contents immediately.