Ruby mysql lib compare with Python mysql lib

最新推荐文章于 2022-07-23 16:19:40 发布

原创最新推荐文章于 2022-07-23 16:19:40 发布 · 803 阅读

0 ·

CC 4.0 BY-SA版权

文章标签：

#mysql #python #ruby #database #include #import

Script 专栏收录该内容

11 篇文章

订阅专栏

本文介绍如何使用Ruby和Python两种编程语言连接并操作MySQL数据库，包括建立连接、执行SQL查询、获取数据及关闭连接等关键步骤。

#Lib include:
#Ruby:
require "mysql"
#Python:
import MySQLdb as mdb

#Connect db
#Ruby:
dbh = Mysql.real_connect("localhost", "test", "test", "rubydb")
#Python:
conn = mdb.connect('localhost', 'testuser', 'test623', 'testdb')

#Execute SQL:
#Ruby:
dbh.query("SELECT * FROM database")
#Python:
cursor = conn.cursor()
cursor.execute("SELECT * FROM database")

#Get the data:
#Ruby:
res = dbh.query("SELECT * FROM database")
while row = res.fetch_row do
         puts row
end
#Python:
cursor.execute("SELECT * FROM database")
rows = cusor.fetchall()
for row in rows:
        print row

#Close database:
#Ruby
dbh.close
#Python
mdb.clsoe