SQL File

# SQL with Python

A simple Python project demonstrating basic SQL database operations — Create, Read, Update, Delete (CRUD) — using SQL statements executed in Python scripts.

This repository contains small Python scripts that walk through key database tasks like creating a database, building tables, inserting records, querying data, updating entries, and deleting records.

---

Project Overview

This repo helps beginners understand how Python can interact with SQL-based databases (like SQLite or MySQL). Each script focuses on one core database action. :contentReference[oaicite:1]{index=1}

🔹 Languages & Tools:
• Python
• SQL (relational database logic)
• SQLite / MySQL (depends on your local setup)

---

Repository Structure

File	Purpose
1_DBcreate.py	Create a new database
2_Table.py	Create a table in the database
3_Insert.py	Insert sample data
4_show.py	Fetch & display data
5_delete.py	Delete records
6_Update.py	Update existing records
Administrator Windows PowerShell.txt	Notes / commands for PowerShell

---

Requirements

Before running scripts, make sure you have:

• Python 3.x installed
• A SQL database (for example, SQLite comes with Python)
• Optional: MySQL server if you want to connect to MySQL

Install required packages:

pip install sqlite3   # SQLite module (usually included with Python)
# For MySQL, e.g.:
pip install mysql-connector-python