- MySQL for Python
- Albert Lukaszewski, PhD
- 353字
- 2021-04-13 17:12:28
What if you want to specify a different price floor every time you run the search? What if you didn't want to use a floor but specify the price exactly? What if you wanted to reuse part of the statement and automate queries by fish name instead of retrieving all of them at once? Under such circumstances, you need to be able to handle variables in your SELECT
statements.
MySQL for Python passes variables to MySQL in the same way that Python formats other kinds of output. If we wanted to specify just the floor of the search, we would assign the variable as any other and pass it to the execute()
method as a string. Consider the following snippet from a Python terminal session:
>>> value = "7.50" >>> command = cur.execute("""SELECT * FROM menu WHERE price = %s""" %(value)) >>> results = cur.fetchall() >>> for record in results: ... print record[0], ". ", record[1], "(%s)" %record[2] ... 1 . tuna (7.50)
If we wanted the user to have the option of specifying the price precisely or using comparative expressions, we can add in that option along with making the previous variable user-defined.
>>> operation = input("operation: ") operation: '=' >>> value = input("value: ") value: 7.50 >>> command = cur.execute("""SELECT * FROM menu WHERE price %s %s""" %(operation, value)) >>> results = cur.fetchall() >>> for record in results: ... print record[0], ". ", record[1], "(%s)" %record[2] ... 1 . tuna (7.50)
As you may have surmised by now, the execute()
method is simply passing the MySQL statement as a string to _mysql
, which in turn passes it to the C database API, which in turn passes it to MySQL. This being the case, we can define the statement separately and pass it to execute()
as a variable. Consider the following replacement for the latter half of the preceding code.
>>> statement = """SELECT * FROM menu WHERE price %s %s""" %(operation, value) >>> command = cur.execute(statement) >>> results = cur.fetchall() >>> for record in results: ... print record[0], ". ", record[1], "(%s)" %record[2] ... 1 . tuna (7.50)
- 中文版AutoCAD 2016從入門到精通
- Adobe Photoshop 網頁設計與制作標準實訓教程(CS5修訂版)
- CakePHP 1.3 Application Development Cookbook
- 中文版 Photoshop CC 從入門到精通
- CAD/CAM軟件應用技術
- AutoCAD 2016中文版完全自學手冊
- Adobe創意大學Photoshop CS5 產品專家認證標準教材
- Small Business Server 2008 – Installation, Migration, and Configuration
- Blender 2.5 Materials and Textures Cookbook
- Photoshop數字圖像處理
- LaTeX入門與實戰應用
- After Effects 2023實訓教程
- UG NX 12.0中文版實戰從入門到精通
- Photoshop CC新媒體圖形圖像設計與制作(全彩慕課版)
- Getting Started with Oracle Hyperion Planning 11