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.2-py3-none-any.whl
Algorithm | Hash digest | |
---|---|---|
SHA256 | a711f0634039ec018f239a8f052107fb31f72d4ca8861e17812e377348a335e2 |
|
MD5 | ddbcf48b468f93b24cc4ed5b44318ec0 |
|
BLAKE2b-256 | 24e3c4745b6f2c7aad0623a4cb60f770b795098e52f60ac48fe19ea7c77d55bb |