Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- db_engine = sqlalchemy.create_engine("mysql+pymysql://user:pass@host/database")
- cnx = db_engine.connect()
- table = pd.read_sql('select * from my_table',cnx)
- cnx.close()
- cnx = mysql.connector.connect(**db_details)
- cursor = cnx.cursor()
- cursor.execute('select * from my_table')
- table = pd.DataFrame(data=list(cursor),columns = cursor.column_names)
- cnx.close()
- require(DBI)
- cnx <- dbConnect(dbDriver("MySQL"),dbname="database",username="user",password="pass",host="host")
- table <- dbGetQuery(cnx,"select * from my_table")
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement