Collections:
Create a New View in MySQL
How To Create a New View in MySQL?
✍: FYIcenter.com
You can create a new view based on one or more existing tables by using the "CREATE VIEW viewName AS selectStatement" statement as shown in the following script:
mysql> CREATE TABLE comment (faqID INTEGER, message VARCHAR(256)); Query OK, 0 rows affected (0.45 sec) mysql> INSERT INTO comment VALUES (1, 'I like it'); Query OK, 1 row affected (0.00 sec) mysql> CREATE VIEW faqComment AS SELECT f.id, f.title, f.description, c.message FROM faq f, comment c WHERE f.id = c.faqID; Query OK, 0 rows affected (0.06 sec) mysql> SELECT * FROM faqComment; +----+-------------+-------------------------+-----------+ | id | title | description | message | +----+-------------+-------------------------+-----------+ | 1 | Learn MySQL | Visit dev.fyicenter.com | I like it | +----+-------------+-------------------------+-----------+ 1 row in set (0.07 sec)
2018-01-24, 710👍, 0💬
Popular Posts:
How REAL and FLOAT Literal Values Are Rounded in SQL Server Transact-SQL? By definition, FLOAT(n) sh...
How To Change the Password for Your Own User Account in MySQL? If you want to change the password of...
How to download and install the scaled-down database AdventureWorksLT in SQL Server? If you want to ...
How To Format DATETIME Values to Strings with the CONVERT() Function in SQL Server Transact-SQL? SQL...
How To Change the Password for Your Own User Account in MySQL? If you want to change the password of...