The following list describes some of the important characteristics of MySQL:
ENUMtypes. See section 7.3 Column types.
WHEREparts of queries. Example:
mysql> SELECT CONCAT(first_name, " ", last_name) FROM tbl_name WHERE income/dependents > 10000 AND age > 30;
ORDER BYclauses. Support for group functions (
LEFT OUTER JOINwith ANSI SQL and ODBC syntax.
INSERTto insert a subset of a table's columns; those columns that are not explicitly given values are set to their default values.
myisamchk, a very fast utility for table checking, optimization and repair. See section 15 Maintaining a MySQL installation.
UPDATEreturn how many rows were changed (affected). It is possible to return the number of rows matched instead by setting a flag when connecting to the server.
ABSis a valid column name. The only restriction is that for a function call, no spaces are allowed between the function name and the `(' that follows it. See section 7.34 Is MySQL picky about reserved words?.
-?options to obtain online assistance.
SHOWcommand can be used to retrieve information about databases, tables and indexes. The
EXPLAINcommand can be used to determine how the optimizer resolves a query.