Python For Hackers by Shantnu Tiwari

Author:Shantnu Tiwari
Language: eng
Format: mobi, epub, pdf
Publisher: leanpub.com
Published: 2015-07-23T00:00:00+00:00

We connect to our students database. SqLite will create a database file for you, if it doesn’t exist.

cmd = "CREATE TABLE students (Name TEXT, Age INT)" c.execute(cmd) conn.commit()

We create a Table students with 2 values: Name and age.

The execute() command runns the SQL instruction, while the commit() writes it to the database. You don’t need to commit after every instruction, you can do it at the end, if you want.

data = [("Robert", 10), ("Sally", 15), ("Matthew", 7)] c.executemany("INSERT INTO students VALUES (?,?)", data)

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.