Skip to main content

Run SQL queries with just one line in python. Use MySQL like a layman.

Project description

Downloads

🤐 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


Download files

Download the file for your platform. If you're not sure which to choose, learn more about installing packages.

Source Distribution

quicksqlconnector-1.4.3.tar.gz (3.5 kB view hashes)

Uploaded Source

Built Distribution

quicksqlconnector-1.4.3-py3-none-any.whl (4.6 kB view hashes)

Uploaded Python 3

Supported by

AWS AWS Cloud computing and Security Sponsor Datadog Datadog Monitoring Fastly Fastly CDN Google Google Download Analytics Microsoft Microsoft PSF Sponsor Pingdom Pingdom Monitoring Sentry Sentry Error logging StatusPage StatusPage Status page