Menu
Im trying to conennect to an sql database that its already created an that its located on a server. How can I connect to this database using python. Ive tried using java but I cant seem to get working either.
778
Connections are automatically closed when they are deleted (typically when they go out of scope) so you should not normally need to call [ conn. close() ], but you can explicitly close the connection if you wish. and similarly for cursors (my emphasis):
To disconnect Database connection, use close() method. If the connection to a database is closed by the user with the close() method, any outstanding transactions are rolled back by the DB.
Well depending on what sql database you are using you can pip install pymssql for microsoft sql (mssql), psycopg2 for postgres (psql) or mysqldb for mysql databases Here are a few examples of using it
Microsoft sql
import pymssql conn = pymssql.connect(server=server, user=user, password=password, database=db) cursor = conn.cursor() cursor.execute("SELECT COUNT(MemberID) as count FROM Members WHERE id = 1") row = cursor.fetchone() conn.close() print(row) Postgres
import psycopg2 conn = psycopg2.connect(database=db, user=user, password=password, host=host, port="5432") cursor = conn.cursor() cursor.execute('SELECT COUNT(MemberID) as count FROM Members WHERE id = 1') row = cursor.fetchone() conn.close() print(row) mysql
import MySQLdb conn = MySQLdb.connect(host=host, user=user, passwd=passwd, db=db) cursor = conn.cursor() cursor.execute('SELECT COUNT(MemberID) as count FROM Members WHERE id = 1') row = cursor.fetchone() conn.close() print(row) If you love us? You can donate to us via Paypal or buy me a coffee so we can maintain and grow! Thank you!
Donate Us With
