在Python中如何连接mysql数据库【面试题详解】

今天爱分享给大家带来在Python中如何连接mysql数据库【面试题详解】,希望能够帮助到大家。

首先,安装mysqldb

然后


#!/usr/bin/python
import MySQLdb

db = MySQLdb.connect(host="localhost", # your host, usually localhost
                     user="john", # your username
                      passwd="megajonhy", # your password
                      db="jonhydb") # name of the data base

# you must create a Cursor object. It will let
#  you execute all the queries you need
cur = db.cursor()

# Use all the SQL you like
cur.execute("SELECT * FROM YOUR_TABLE_NAME")

# print all the first cell of all the rows
for row in cur.fetchall() :
    print row[0]

人已赞赏
Python

AttributeError: 'module' object has no attribute 'Counter'【解决方法】

2020-12-28 21:51:11

Python

如何测试一个python脚本的性能【面试题详解】

2020-12-28 21:53:51

'); })();