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, 4801👍, 0💬
Popular Posts:
How To Change the Password of Another User Account? - MySQL FAQs - Managing User Accounts and Access...
If cookies are not enabled at browser end does form Authentication work? No, it does not work.
How many types of validation controls are provided by ASP.NET ? There are six main types of validati...
What's the output of the following program? And why? #include main() { typedef union { int a; char b...
How To Process Query Result in PL/SQL? - Oracle DBA FAQ - Introduction to PL/SQL You can run queries...