Run SQL queries with just one line in python. Use MySQL like a layman.
Project description
🤐 What is Quick SQL Connector ?
-
🖇 Saves upto 80% of code lines as compared to other libraries.
-
😃 Gives you simple interface to execute mysql commands easily.
💽 Pre-requisites & Installation
-
MySQLServer and MySQL Command-Line Client should be installed on your machine.
😋USING PIP
pip install quicksqlconnector
😈FOR LINUX FRIENDS
python3 pip install quicksqlconnector
🙄How to use?
Use 'quicksqlconnector' keyword to import
from quicksqlconnector import quicksqlconnector
Creating instance of module
DB = quicksqlconnector('host', port, 'username', 'password', 'database-name:optional')
quicksqlconnector only have one method which is 'query'
Some Examples
pass your 'mysql commnad' as a 'string' in 'query' method to execute query.
DB.query('update people set id=90 where id=1')
DB.query('delete from people where id=1000')
DB.query('delete from people where id=1022')
DB.query('insert into people value(26,4,6)')
DB.query('select * from people')
🔗Useful Links
PyPi - Visit Here
Website - Visit Here
Project details
Release history Release notifications | RSS feed
Download files
Download the file for your platform. If you're not sure which to choose, learn more about installing packages.
Source Distribution
Built Distribution
Close
Hashes for quicksqlconnector-1.4.3-py3-none-any.whl
Algorithm | Hash digest | |
---|---|---|
SHA256 | 08fee3b64316fb17f2b0051ea02f2f8d98af016df9e28274ddcb8deb65178f12 |
|
MD5 | df8d10b7227e9871c61aca13f5a95088 |
|
BLAKE2b-256 | c01e35c1be5cadd50e4742865cd3688f352372ce1a18c0917d978fa7b0ed62fe |