Hi I'm Yusuf, I'm a junior Computer Science student interested in Open Source, Software Development and Engineering
I’m looking for internship opportunities in Software development and engineering.
I'll start with,
The sqlite3 module is a wrapper for the SQLite database library, providing a persistent database that can be updated and accessed using slightly nonstandard SQL syntax.
The code needed to make a database connections: import sqlite3
con = sqlite3.connect('example.db')
create a cursor: cur = con.cursor()
Now we can excute SQL statment: cur.execute('''CREATE TABLE stocks
(date text, trans text, symbol text, qty real, price real)''')
Don't forget to close db connection cur.close()
Full code:
import sqlite3
con = sqlite3.connect('example.db') cur = sqlite3.curser()
cur.excute("")
cur.close
For further reading Here are sqlite3 official docs
For further actions, you may consider blocking this person and/or reporting abuse
We're a place where coders share, stay up-to-date and grow their careers.
I'll start with,
The sqlite3 module is a wrapper for the SQLite database library, providing a persistent database that can be updated and accessed using slightly nonstandard SQL syntax.
The code needed to make a database connections:
import sqlite3
con = sqlite3.connect('example.db')
create a cursor:
cur = con.cursor()
Now we can excute SQL statment:
cur.execute('''CREATE TABLE stocks
(date text, trans text, symbol text, qty real, price real)''')
Don't forget to close db connection
cur.close()
Full code:
import sqlite3
con = sqlite3.connect('example.db')
cur = sqlite3.curser()
cur.excute("")
cur.close
For further reading Here are sqlite3 official docs