Skip to content

FaiXanAhm3D/Python-MySQL

Folders and files

NameName
Last commit message
Last commit date

Latest commit

ย 

History

3 Commits
ย 
ย 
ย 
ย 

Repository files navigation

Python + MySQL Database App ๐Ÿ“š

This is a beginner-friendly Python project that connects to a MySQL database to perform basic CRUD operations (Create, Read, Update, Delete).

It serves as a simple command-line interface for managing data entries like students, employees, etc.


๐Ÿ”ง Features

  • Add new records to the database
  • View all existing records
  • Update specific entries
  • Delete entries from the database
  • Clean terminal-based user interface

๐Ÿ› ๏ธ Tech Stack

  • Python 3
  • MySQL
  • mysql.connector (Python library)

โš™๏ธ Setup Instructions

  1. Make sure MySQL is installed and running.
  2. Create a database and table (refer to setup.sql if provided).
  3. Update your database connection settings in the script:
    connection = mysql.connector.connect(
        host="localhost",
        user="your_mysql_username",
        password="your_mysql_password",
        database="your_database_name"
    )
  4. Install the required package: pip install mysql-connector-python

About

A simple Python project that connects to a MySQL database to perform CRUD (Create, Read, Update, Delete) operations using mysql.connector.

Topics

Resources

Stars

Watchers

Forks

Releases

No releases published

Packages

 
 
 

Contributors

Languages