Categories:
.NET (357)
C (330)
C++ (183)
CSS (84)
DBA (2)
General (7)
HTML (4)
Java (574)
JavaScript (106)
JSP (66)
Oracle (114)
Perl (46)
Perl (1)
PHP (1)
PL/SQL (1)
RSS (51)
Software QA (13)
SQL Server (1)
Windows (1)
XHTML (173)
Other Resources:
How To Select Some Columns from a Table
How To Select Some Columns from a Table? - MySQL FAQs - SQL SELECT Query Statements with GROUP BY
✍: FYIcenter.com
If you want explicitly tell the query to return some columns, you can specify the column names in the SELECT clause. The following select statement returns only two columns, "id" and "url" from the table "fyi_links":
mysql> SELECT id, url FROM fyi_links; +-----+-------------------+ | id | url | +-----+-------------------+ | 101 | dev.fyicenter.com | | 102 | dba.fyicenter.com | | 103 | sqa.fyicenter.com | +-----+-------------------+ 3 rows in set (0.00 sec)
2007-05-11, 4700👍, 0💬
Popular Posts:
Can event’s have access modifiers ? Event’s are always public as they are meant to serve every one r...
How is normally a project management plan document organized ? PMP document forms the bible of a pro...
Jack developed a program by using a Map container to hold key/value pairs. He wanted to make a chang...
How To Use Subqueries with the IN Operator? - MySQL FAQs - SQL SELECT Statements with JOIN and Subqu...
What will be printed as the result of the operation below: main() { char *p1; char *p2; p1=(char *)m...