Latest developer linksBookmark and Share
 
HomeThis WeekTop MonthTop AlltimeSearchRegisterFAQ
  
 
Submit Your Link
Please login to submit your Link
 

Querying Data from MySQL

Posted: Sep/24/2009   By: nikhil   Points:15   Category: MySQL  - Performance    Views:97   Vote Up (0)   Vote Down (0)    
In order to retrieve data from MySQL database server you use SELECT statement. Here is the simple form of it:

The SELECT statement has many option clauses which you can use these or not. If you use, the order has to be appear as shown.

To select all columns in a table you can use (*) notation instead of listing all column name. For example, if you need to query all the columns in offices table just execute this query:

View Complete Post


Comments:
Be the first to comment this post.
 
Post Comment
Please login to post your comment
More Related Resources
 
Categories:
.NET
Java
PHP
C/C++/VC++
HTML/XML
SAP
MainFrames
Data Warehousing
Testing
MySQL
SQL Server
Oracle
Javascript/VB Script
Others
Login
 
 
 
 
 Forgot password
 Contact Us   Terms Of use   Share your knowledge