SELECT [DISTINCT|ALL ] { * | [fieldExpression [AS newName]} FROM tableName [alias] [WHERE condition][GROUP BY fieldName(s)] [HAVING condition] ORDER BY fieldName(s) Command Description CREATE DATABASE ...

The MySQL syntax offers several ways to avoid repeating names in a table and to. ... The names do not need to be in alphabetical order because you will sort them using a MySQL "select" statement.

For example, type "mysql -u root -p" (without the quote marks) and enter your password when prompted. Create a MySQL SELECT query to select the data you want to output to CSV.

mysql> SELECT * FROM table LIMIT 5,10; # Retrieve rows 6-15 </pre><BR><BR>Here is a link to the MySQL page talking about the SELECT syntax, ...