Databases

Tables and columns

MySQL

Installing MySQL

Accessing MySQL via CLI

Creating a database

Configuring .my.cnf

The mysqladmin command

GUI clients

Tables

Data types

Creating a database

Creating tables

Dropping tables

Allowing NULL values

Specifying a primary key

Updating tables

Basic syntax

INSERT

SELECT

UPDATE

DELETE

Comments

Conclusion

SELECT

SELECT all columns

Formatting

SELECT specific columns only

LIMIT

COUNT

MIN, MAX, AVG, and SUM

DISTINCT

Conclusion

WHERE

WHERE Clause example

Operators

AND keyword

OR keyword

LIKE operator

IN operator

IS operator

Conclusion

Sorting with ORDER and GROUP by

ORDER BY

GROUP BY

INSERT

Inserting multiple records

UPDATE

DELETE

JOIN

Cross join

Inner join

Left join

Right join

Conclusion

The MySQL dump command

Exporting a Database

Exporting all databases

Automated backups