quicksqlconnector 1.4.41

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

🤐 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'

It has two arguments, query and parameters.

Some Examples

pass your 'mysql commnad' as a 'string' in 'query' method to execute query.

DB.query("SELECT * FROM test where id= %s", (input_user,))
DB.query("SELECT * FROM test")
DB.query('CREATE TABLE test(name varchar(10), id int(10))')
DB.query("INSERT INTO test values(%s, %s)", ('harry', 13))

What's coming?

• It will soon support other SQL databases including: Microsoft SQL server, SQL Lite, Postgres SQL etc.

🔗Useful Links

PyPi - Visit Here

Website - Visit Here