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, 1330🔥, 0💬
Popular Posts:
How Fixed Length Strings Are Truncated and Padded in SQL Server Transact-SQL? When the length of the...
How to connect SQL Server Management Studio Express to SQL Server 2005 Express in SQL Server? Once y...
Where to find answers to frequently asked questions on PHP Connections and Query Execution for MySQL...
How To Drop an Index in Oracle? If you don't need an existing index any more, you should delete it w...
How to continue to the next iteration of a WHILE loop in SQL Server Transact-SQL? How to use CONTINU...