Skip to content

Searcharticlesvideosblogsforumsinterview questionsarticles

Tech
Articles
Blogs
News
Videos
Interviews
Forums
Books
Events
- Jobs
- Stories

Article
Blog
Video
Ebook
Interview Question

Loading

Upcoming Events

23 NOV
AI Agents Conference 2026 - 3rd Edition

Our Training Programs

AI & Machine Learning
Mastering Large Language Models
Mastering Prompt Engineering
Certified Vibe Coder
Github Copilot Training
Generative AI for Beginners
n8n Automation & AI Agents Training

About Us Contact Us Privacy Policy Terms Brand Guidelines Partners C# Tutorials Consultants Ideas Report A Bug FAQs Sitemap Stories CSharp TV DB Talks Web3 Universe Jumpstart Blockchain

©2026 C# Corner.

All contents are copyright of their authors.

Who uses pycharm How do u connect sqlite3 to the pycharm

Home
Forums
Python

Who uses pycharm How do u connect sqlite3 to the pycharm

Ayush A

5yAsked Mar 5, 2021, 11:48 AM760Python

Who uses pycharm How do u connect sqlite3 to the pycharm

1 Reply

Know the answer? Post it — somebody with the same question will find it here.

Sign in to answer this question

It is the same account you read, post and publish with — and you will come straight back to this page.

Sign in Create an account

Rajanikant Hawaldar5y ago
Accepted answer
1. import sqlite3
2. con = sqlite3.connect('example.db')
3. cur = con.cursor()
4. # Create table
5. cur.execute('''''CREATE TABLE stocks
6. (date text, trans text, symbol text, qty real, price real)''')
7. # Insert a row of data
8. cur.execute("INSERT INTO stocks VALUES ('2006-01-05','BUY','RHAT',100,35.14)")
9. # Save (commit) the changes
10. con.commit()
11. # We can also close the connection if we are done with it.
12. # Just be sure any changes have been committed or they will be lost.
13. con.close()