Using SELECT Statements in Views in MySQL

Q

Can SELECT Statements Be Used on Views in MySQL?

✍: FYIcenter.com

A

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)

 

SELECT Query Statements with GROUP BY in MySQL

⇒⇒MySQL Database Tutorials

2016-10-17, 201👍, 0💬