MySQL for Python

Getting MySQL for Python 7
Using a package manager (only on Linux) 8
Using RPMs and yum 9
Using RPMs and urpm 9
Using apt tools on Debian-like systems 9
Using an installer for Windows 10
Using an egg file 10
Using a tarball (tar.gz file) 14
Importing MySQL for Python 17
Accessing online help when you need it 18
MySQLdb 18
_mysql 19
Connecting with a database 20
Creating a connection object 20
Creating a cursor object 22
Interacting with the database 22
Closing the connection 23
Multiple database connections 23
Summary 24
Chapter 2: Simple Querying 25
A brief introduction to CRUD 25
Forming a query in MySQL 26
SELECT 27
* (asterisk) 27
FROM 28
staff 28
; (semicolon) 29

Other helpful quantifiers 29
WHERE 30
GROUP BY 30
HAVING 32
ORDER BY 33
LIMIT 35
INTO OUTFILE 37
Passing a query to MySQL 37
A simple SELECT statement 38
Modifying the results 39
Using user-defined variables 40
Determining characteristics of a database and its tables 41
Determining what tables exist 42
Assigning each table a number 43
Offering the options to the user 43
Allowing the user to detail a search query 44
Changing queries dynamically 45
Pattern matching in MySQL queries 45
Putting it into practice 46
Project: A command-line search utility 48
Preparing a database for searching 49
Planning your work, then working your plan 50
Develop a well-abstracted search functionality 50
Specifying the search term from the command-line 52
Implementing and incorporating the other functions: -t, -f, and -o 55
Including an option for an output file 57
Room to grow 57
Summary 58
Chapter 3: Simple Insertion 59
Forming a MySQL insertion statement 60
INSERT 60
INTO 61
Table name 61
Column names 61
VALUES 63
<some values> 64
; (semicolon) 66
Helpful ways to nuance an INSERT statement 66
INSERT...SELECT... 66
INSERT DELAYED… 70
INSERT...ON DUPLICATE KEY UPDATE... 71