python query with parameters

321913901018 Devineni Yashwanth answered on May 5, 2023 Popularity 2/10 Helpfulness 1/10

answer python query with parameters

python query with parameters

Comment

import sqlite3

conn = sqlite3.connect('example.db')
c = conn.cursor()

# Create table
c.execute('''CREATE TABLE stocks
             (date text, trans text, symbol text, qty real, price real)''')

# Insert a row of data
values = ('2006-01-05', 'BUY', 'RHAT', 100, 35.14)
c.execute("INSERT INTO stocks VALUES (?, ?, ?, ?, ?)", values)

# Commit the changes
conn.commit()

# Close the connection
conn.close()

Popularity 2/10 Helpfulness 1/10 Language python

Source: Grepper

Tags: parameters python

Link to this answer
Share Copy Link

Contributed on May 05 2023

321913901018 Devineni Yashwanth

0 Answers Avg Quality 2/10

python query with parameters

Contents

More Related Answers

python query with parameters

Grepper

Documentation

Social

Legal

Contact

Oops, You will need to install Grepper and log-in to perform this action.