Learn SQL Database Programming

Understanding the SELECT statement and the FROM clause

At a minimum, every SELECT statement on a table needs the SELECT and FROM keywords. If you want to select all the rows and columns from the appearances table in lahmansbaseballdb, you should execute the following query:

SELECT * FROM lahmansbaseballdb.appearances;

Make sure to add a semicolon (;) to the end of your SQL statements. The semicolon marks the end of a query. The query may execute without it, but it is good practice to ensure that the SQL code will execute properly.

This query will give you the results shown in the following screenshot:

What we are telling MySQL when we execute ...