CONSULTAS en MySQL

* Listados:
SELECT columnas FROM tabla [WHERE condición]
[GROUP BY columna [ HAVING condición ]]
[ORDER BY columna [ ASC | DESC ]]
[LIMIT [inicio,] num_registros]
(Se puede usar el comodín * para seleccionar todas las columnas)

Ejemplos:
SELECT * FROM City;
SELECT Name, Population FROM City
WHERE CountryCode='ESP' AND Population > 500000 LIMIT 0,10;
SELECT CountryCode, SUM(Population) FROM City
GROUP BY CountryCode HAVING SUM(Population) > 10000000;
SELECT City.Name, Country.Name FROM City, Country
…