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 All Columns of All Rows from a Table
How To Select All Columns of All Rows from a Table? - MySQL FAQs - SQL SELECT Query Statements with GROUP BY
✍: FYIcenter.com
The simplest query statement is the one that selects all columns of all rows from a single table: "SELECT * FROM tableName;". The (*) in the SELECT clause tells the query to return all columns. The missing WHERE clause tells the query to return all rows in specified table. The tutorial exercise below returns all columns and all rows from table "fyi_links":
mysql> SELECT * FROM fyi_links; +-----+-------------------+-------+--------+--------------- | id | url | notes | counts | created +-----+-------------------+-------+--------+--------------- | 101 | dev.fyicenter.com | NULL | 0 | 2006-04-30 00: | 102 | dba.fyicenter.com | NULL | 0 | 2006-07-01 12: | 103 | sqa.fyicenter.com | NULL | NULL | 2006-07-01 12: +-----+-------------------+-------+--------+--------------- 3 rows in set (0.00 sec)
2007-05-11, 6428👍, 0💬
Popular Posts:
How you will enable front-end validation based on the xml in validation.xml? The <html:javascr...
What is the output of printf("%d")? 1. When we write printf("%d",x); this means compiler will print ...
What is page thrashing? Some operating systems (such as UNIX or Windows in enhanced mode) use virtua...
What is test metrics? Test metrics accomplish in analyzing the current level of maturity in testing ...
How To Run a JUnit Test Class? A JUnit test class usually contains a number of test methods. You can...