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, 1438🔥, 0💬
Popular Posts:
How To Convert Numeric Values to Character Strings in MySQL? You can convert numeric values to chara...
What Is an Oracle Instance in Oracle? Every running Oracle database is associated with an Oracle ins...
How To Drop an Index in Oracle? If you don't need an existing index any more, you should delete it w...
How To Enter Unicode Character String Literals in SQL Server Transact-SQL? Unicode characters are mu...
What is dba.FYIcenter.com Website about? dba.FYIcenter.com is a Website for DBAs (database administr...