MySQL SQL SELECT command is used to retrieve rows selected from one or more tables. It allows you to select mysql table columns.
Login to MySQL
Code:
mysql -u user -p databasename
If your table name is books, to select all columns type command:
Code:
SELECT * FROM books;
Using * is easy, you an specify the column name with following command (let us say column name is author and email):
Code:
SELECT autor, email FROM books;
For more information please see SELECT command syntax
http://dev.mysql.com/doc/refman/5.0/en/select.html