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