查询数据库
- 连接
# 连接
db=MySQLdb.connect(host = 'host_name',
user = 'root',
passwd = 'pass_word',
db = 'db_name',
port = 8888,
charset = 'utf8')
# 获取操作游标
cursor=db.cursor()
- 执行获取语句
# 使用execute方法执行SQL语句
n = cursor.execute("select * from news id order by id desc limit 0,2")
* “select * from table_name id order by id desc limit 0,2” *
: 从table_name这个表中, 以倒序从第0个行开始获取2行数据.**
* “select * from table_name id order by id desc” *
: 从table_name这个表中, 以倒序获取所有数据.**
- 获取数据
for info in cursor.fetchall():
print (info)