MYSQL-TOOLS

Comparison of graphical tools for MySQL

Home Basic Select Statements

Basic Select Statements

In this lesson of the MySQL tutorial, you will learn...
  1. About the database we'll be using in class.
  2. To comment your SQL code.
  3. To understand SQL syntax.
  4. To select all rows from a table.
  5. To sort record sets.
  6. To filter records.
  7. To use the CASE function to display different values depending on the values of a column or columns.

The SELECT statement is used to retrieve data from tables. SELECT statements can be used to perform simple tasks such as retrieving records from a single table or complicated tasks such as retrieving data from multiple tables with record grouping and sorting. In this lesson, we will look at several of the more basic ways to retrieve data from a single table.

Title Filter     Display # 
# Article Title Hits
1 Basic SQL Syntax Rules 10887
 
mysql tools