Dynamically CRUD operation in MYSQLDB using Python Script
First, You Can run User file, Thne User Input for What Operation do like Create table, Update Record, Delete Record & Show Table Data.
For this, In Your Machine You have install MYSQL & Python.
if You can use Windows, You have to install Python & Mysql both.
https://stackoverflow.com/questions/21372637/installing-python-2-7-on-windows-8
for step by step install MYSQL in Ubuntu 16.04:
https://www.digitalocean.com/community/tutorials/how-to-install-mysql-on-ubuntu-16-04
First, You have to run user file, In that User Choice is define. we can doing 5 types of operation : Create, Read, Update, Delete.
After that config file work as a create database & maintain Connection of SQL Server. CRUd file can contains all the Queries of operation.
Python Scripting Python2 use for coding. pep8 standards using for python code in the code.
- Veerali Shah - Initial work
- Hat tip to anyone who's code was used
- Inspiration
- etc