All pastes #93843 Raw Edit

Stuff

public text v1 · immutable
#93843 ·published 2006-07-20 20:18 UTC
rendered paste body
   cursor = conn.cursor ()
   cursor.execute ("DROP TABLE IF EXISTS animal")
   cursor.execute ("""
           CREATE TABLE animal
           (
               name CHAR(40),
               category CHAR(40)
           )
       """)
   cursor.execute ("""
           INSERT INTO animal (name, category)
           VALUES
               ('snake', 'reptile'),
               ('frog', 'amphibian'),
               ('tuna', 'fish'),
               ('racoon', 'mammal')
       """)
   print "%d rows were inserted" % cursor.rowcount

#YO QUIERO QUE "snake" sea una variable y que "reptile" tambien sea una variable y que se ejecute lo de la variable