MySQL Data Backup Tool BitDaddys Corp. $12.00 More Info Free Trial Buy Now! Unique and Easy to use MySQL Database backups. Powerful Hourly Rotations. more ... MySQL Tutorials Table Of Contents Part 1: Start MySQL and Create Databases and Tables (Create) Part 2: Add Data (Insert and Replace) Part 3: Show Data (Select) Part 4: Delete Data (Delete and Drop) Part 5: Backup Data (Dump) How to use C# and MySQL Connector/Net How to use MySQL 5 Part 3: Selecting Data (greatly simplified)

This article and tutorial describes and demonstrates how you can:

• [ click here ] Reading an Entire Table With Select *
• [ click here ] Reading only certain Columns With Select Column_Name
• [ click here ] Reading only certain Data With Select Where
• [ click here ] Reading Totals and Similar With Select Sum, Avg, Min, Max, Count

---

The MySQL SELECT command is how you get information from the tables you create and use. It is the primary way of reading information from your mysql database.

SELECT SYNTAX

Steps To Read all of theData in a table using the MySQL SELECT Command	Visual Demonstration
Open the MySQL Command Line and select your database Type 'SELECT' Type An asteric for all columns '*' Type From and your table name 'FROM mytable;'

Syntax:

Select * From MyTable

"SELECT is used to retrieve rows selected from one or more tables, and can include UNION statements and subqueries. ... "

more info...

[ return to top ]

---

The MySQL SELECT command can be used to Read specfic information. You don't have to look at every piece of information available, instead you can just look at fields or columns you want to see.

SELECT SYNTAX

Steps To Read Specific Column Data using the MySQL SELECT Command	Visual Demonstration
Open the MySQL Command Line and select your database Type 'SELECT' Type the list of column names you want to see 'id,x' Type From and your table name 'FROM mytable;'

Syntax:

Select Customer_Number,Customer_Name From MyCustomers;

more info...

[ return to top ]

---

The MySQL SELECT command can be used to Read specfic rows. You don't have to look at every line of information available, instead you can just look at rows you want to see.

SELECT SYNTAX

Steps To Read Specific Row Data using the MySQL SELECT Command With WHERE	Visual Demonstration
Open the MySQL Command Line and select your database Type 'SELECT' Type the list of column names you want to see 'id,x' Type From and your table name 'FROM mytable' Type Where and your criteria 'WHERE id>102;'

Syntax:

Select Customer_Number,Customer_Name From MyCustomers Where Customer_Number>100;

You can use compartive operators like:

• > (greater than)
• < (less than)
• = (equals)
• != (not equal)
• >= (greater than or equal)
• <= (less than or equal)

more info...

[ return to top ]

 

---

The MySQL SELECT command can be used to Read specfic information. You can do things like get totals, count how many items are available, get the smallest item, get the largest column and even average a field.

SELECT SYNTAX

Steps To Read and Perform Specific Functions on Column Data using the MySQL SELECT Command	Visual Demonstration
Open the MySQL Command Line and select your database Type 'SELECT' Type the aggregate function name and the column name you want to perform the function on 'max(id);' Type From and your table name 'FROM mytable'

Syntax:

Select Min(Price) From PriceList Where Item='Books';

or

Select Count(*) From MyCustomers;

or

Select Sum(Amount) From Sales Where ItemSold='Pizza'';

Aggregate (also known as Summary) functions include:

• min (minimum)
• max (maximum)
• avg (avergage)
• count (count)
• sum (total)

more info...

[ return to top ]