The SELECT statement is primarily used to retrieve zero or more rows from one or more tables in a database. In MySQL, SELECT is the most commonly used DML (Data Manipulation Language) command. In specifying a SELECT query, the user specifies a description of the desired result set. It is built with optional clauses that specify how and what data to retrieve. The general command syntax is shown below; SELECT [<clause options>] <column list> [FROM] <table> [<clause options>]; Basic SELECT statement example using world database (and the result data): mysql> SELECT Name FROM Country; +-------------------------------------------------+ | Name | +-----------------------...
“The best way to be ready for the future is to invent it.”— John Sculley