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)
⇒ Drop an Existing View in MySQL
⇐ Drop an Existing Index in MySQL
2018-01-24, 1173👍, 0💬
Popular Posts:
What is dba.FYIcenter.com Website about? dba.FYIcenter.com is a Website for DBAs (database administr...
What Happens If the UPDATE Subquery Returns Multiple Rows in MySQL? If a subquery is used in a UPDAT...
How To Turn on mysql Extension on the PHP Engine in MySQL? The "mysql" API extension is provided as ...
What Happens to Your Transactions When ERROR 1205 Occurred in MySQL? If your transaction receives th...
How To Use DATEADD() Function in SQL Server Transact-SQL? DATEADD() is a very useful function for ma...