DZone Snippets > manatlan > db
12309 users tagging and storing useful source code snippets
Automate Your Rails Deployment
Silverlight 3D Engine : Balder supports Silverl...
db (8)
sql (4)
database (3)
plone (2)
python (2)
mysql (2)
shell (1)
php (1)
column (1)
pylons (1)
cron (1)
sqlite (1)
IS_Nullable (1)
storm (1)
web (1)
bash (1)
mssql (1)
sqlalchemy (1)
backup (1)
image (1)
schema (1)
wsgi (1)
sysadmin (1)
select (1)
orm (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.
