DZone Snippets > manatlan > sqlite
12389 users tagging and storing useful source code snippets
Ruby/Rails interview questions
Hessian Extender on OSGi Container
Getting Started Quickly with Hibernate Annotations
17 Websites to Boost Your Designer Profile
Flex Layout Vs Java Layout - First impressions
sqlite (15)
ruby (6)
database (4)
activerecord (3)
rails (3)
sql (3)
python (2)
perl (1)
excel (1)
bash (1)
function (1)
places (1)
aperture (1)
script (1)
db (1)
backup (1)
aggregate (1)
sqlite3 (1)
dbi (1)
firefox (1)
osx (1)
shell (1)
del.icio.us (1)
mysql (1)
c (1)
program (1)
python (22)
pil (3)
image (3)
files (3)
mail (2)
pixbuf (2)
xml (2)
server (2)
invoke (2)
gtk (2)
sql (2)
smtp (2)
xslt (2)
http (2)
doctest (1)
qemu (1)
list (1)
resize (1)
sqlite (1)
beautifulsoup (1)
inspect (1)
exceptions (1)
config (1)
cherrypy (1)
xmlrpc (1)
encoding (1)
mssqlserver (1)
singleton (1)
ubuntu (1)
execute (1)
set (1)
entities (1)
snippets (1)
tuple (1)
php (1)
db (1)
editor (1)
csharp (1)
path (1)
scite (1)
javascript (1)
linux (1)
translate (1)
html (1)
Snippets is a public source code repository. Easily build up your personal collection of code snippets, categorize them with tags / keywords, and share them with the world
manatlan http://manatlan.online.fr
import sqlite con = sqlite.connect('mydatabase.db') cur = con.cursor() #~ cur.execute('CREATE TABLE foo (o_id INTEGER PRIMARY KEY, fruit VARCHAR(20), veges VARCHAR(30))') #~ con.commit() cur.execute('INSERT INTO foo (o_id, fruit, veges) VALUES(NULL, "apple", "broccoli")') con.commit() print cur.lastrowid cur.execute('SELECT * FROM foo') print cur.fetchall()
Snippets originally developed by Peter Cooper and powered by Ruby On Rails.
Copyright © 2007 DZone, Inc.
