1. Computing & Technology

Discuss in my forum

Select - MySQL Command

By , About.com Guide

Definition: The select statement is used in SQL to specify what data you would like returned when querying the MySQL database. An asterisks [*] will return all data, or you can choose specific data.
Examples:
 SELECT * FROM Table_name;
This will return all data from the table called Table_name

 SELECT name FROM People WHERE email = "SpaceCowboy@yourname.com";
This will return the data from the "name" field on the table called "people" for the person who's email address is SpaceCowboy@yourname.com

©2012 About.com. All rights reserved.

A part of The New York Times Company.