Collections:
Using SELECT Statements in Views in MySQL
Can SELECT Statements Be Used on Views in MySQL?
✍: 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)
⇒ Filerting out Duplications in Returning Rows in MySQL
⇐ Count Number of Rows with SELECT Statements in MySQL
2018-01-06, 1422🔥, 0💬
Popular Posts:
How To End a Stored Procedure Properly in SQL Server Transact-SQL? Where the end of the "CREATE PROC...
How To Format Time Zone in +/-hh:mm Format in SQL Server Transact-SQL? From the previous tutorial, y...
How To Convert Numeric Values to Integers in SQL Server Transact-SQL? Sometimes you need to round a ...
Where to find answers to frequently asked questions on PHP Connections and Query Execution for MySQL...
How To Convert Binary Strings into Hexadecimal Character Strings in SQL Server? When a query returns...