PySQL
This is Snippet Extenstion for PySQL database framework for python.
Documentation of PySQL is here https://github.com/rohit-chouhan/pysql/
Where the prefix for use:-
Prefix |
Use |
pysql_connect |
Connect to Server Only |
pysql_connect_db |
Connect to Database |
pysql_create_db |
Create New Database |
pysql_query |
Run SQL Query Manually |
pysql_drop_db |
Drop a Table |
pysql_create_table |
Create a Table |
pysql_drop_table |
Drop a Table |
pysql_insert |
Add Records to Table |
pysql_select_all |
Select All Data from Table |
pysql_select_column |
Select Specific Columns |
pysql_select_where |
Select Data using Where |
pysql_add_column |
Add new column to Table |
pysql_drop_column |
Drop exist Column |
pysql_update_all |
Update all Data in Table |
pysql_update_where |
Update Specific Data in Table |
pysql_delete_all |
Empty All Records for Table |
pysql_delete_where |
Delete Specific Records from Table |
| |