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:
Can SELECT Statements Be Used on Views
Can SELECT Statements Be Used on Views? - MySQL FAQs - SQL SELECT Query Statements with GROUP BY
✍: FYIcenter.com
Select (query) statements can be used on views in the same way as tables. The following tutorial exercise helps you creating a view and running a query statement on the view:
mysql> CREATE VIEW myLinks AS SELECT * FROM fyi_links WHERE url LIKE '%fyi%'; Query OK, 0 rows affected (0.49 sec) mysql> SELECT tag, counts, url, DATE(created) FROM myLinks ORDER BY counts DESC; +------+--------+-------------------+---------------+ | tag | counts | url | DATE(created) | +------+--------+-------------------+---------------+ | SQA | 6 | sqa.fyicenter.com | 2006-07-01 | | DEV | 4 | dev.fyicenter.com | 2006-04-30 | | DBA | 3 | dba.fyicenter.com | 2006-07-01 | +------+--------+-------------------+---------------+ 3 rows in set (0.00 sec)
2007-05-11, 4679👍, 0💬
Popular Posts:
What does AddressOf operator do in background ? The AddressOf operator creates a delegate object to ...
How could Java classes direct program messages to the system console, but error messages, say to a f...
How do we enable SQL Cache Dependency in ASP.NET 2.0? Below are the broader steps to enable a SQL Ca...
The object that contains all the properties and methods for every ASP.NET page, that is built is .. ...
How To Write a Query with a Right Outer Join? - Oracle DBA FAQ - Understanding SQL SELECT Query Stat...