Search
 
SCRIPT & CODE EXAMPLE
 
CODE EXAMPLE FOR SQL

execut sql python

# connect database and create cursor here
import sqlite3 
conn = sqlite3.connect('File.Name')
cur = conn.cursor()
# statement to be executed
cur.execute("""SELECT COL_NAME FROM TABLE_NAME LIMIT 5;""").fetchall()
 
PREVIOUS NEXT
Tagged: #execut #sql #python
ADD COMMENT
Topic
Name
6+2 =