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 14630
mysql tools

How create data source in Visual Studio with data from My SQL tables with FK. more...

'mysql.proc' doesn't exist fixed problem


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