官术网_书友最值得收藏!

  • MySQL for Python
  • Albert Lukaszewski, PhD
  • 289字
  • 2021-04-13 17:12:28

Chapter 2. Simple Querying

Record retrieval is without doubt the most common activity employed with regard to MySQL and other relational databases. Like most computer programs, MySQL functions on the basis of being invoked with parameters and returning results in accordance with them. As we seen, Python acts as an intermediary to that process. We can use it to access MySQL, login, and connect to a database of our choice.

In this chapter, we will look at the following:

  • Forming a MySQL query directly
  • Passing a query to MySQL
  • User-defined variables in a MySQL query
  • Determining characteristics of a database and its tables
  • Changing queries dynamically, without user input

Working through each of these points will help you at the end of the chapter, when we get to the project: a command-line search tool.

A brief introduction to CRUD

The four basic functions of any persistent storage system like MySQL spell CRUD:

  • Create
  • Read
  • Update
  • Delete

These are key concepts, which each of the basic MySQL commands reflect.

There is nothing technical about the words themselves, but the concepts are very important. They represent the four activities that you can expect to be able to do in every relational database system you use. There are several alternatives to this acronym and keyword series (for example, SCUD for "select, create, update, and delete" or SIDU for "select, insert, delete, and update"). The point of each of these is that database functionality boils down to two sets of opposing activities:

  • Creating and deleting database objects (for example, databases, tables, records)
  • Inserting and reading data (that is writing and reading)

Each of these will be addressed in the coming chapters. In this one, we start with reading data using SELECT.

主站蜘蛛池模板: 新巴尔虎左旗| 福清市| 东莞市| 宣恩县| 玉林市| 阿拉善左旗| 鹤峰县| 安丘市| 西安市| 英德市| 湘潭市| 澄迈县| 赤城县| 沁源县| 栖霞市| 隆化县| 民和| 稷山县| 湖州市| 邵东县| 石楼县| 弥渡县| 库尔勒市| 津市市| 新龙县| 北海市| 清镇市| 视频| 平顶山市| 岑溪市| 高碑店市| 铁力市| 丽江市| 玉门市| 喀喇沁旗| 依安县| 手游| 彭阳县| 衡山县| 丰县| 苏尼特左旗|