Other Operations

• COUNT() and GROUP BY are useful for characterizing data in various ways.
  • COUNT() counts the number of rows.
  • GROUP BY group all records by a particular field.

• An INNER JOIN allows for rows from either table to appear in the result if and only if both tables meet the conditions specified in the ON clause.

• Use MAX() to obtain the maximum value of a column.

• UNION that combines the output of two separate SELECT statements.

How do I use mysql in batch mode?

---

---

© 2007 John Michael Pierobon

Notes