MySQL Tools Comparison.

  • Increase font size
  • Default font size
  • Decrease font size
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 15775





I used HTTPtunnel GNU package for the organization HTTP tunnel with HeidiSQL. Read more...

'mysql.proc' doesn't exist fixed problem


Table 'mysql.proc' doesn't exist. Fix error 1146 Table doesn't exist here...