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, 1842🔥, 0💬
Popular Posts:
What Happens If the Imported Table Already Exists in Oracle? If the import process tries to import a...
How To Connect ASP Pages to Oracle Servers in Oracle? If you are running Windows IIS Web server and ...
How To Get Year, Month and Day Out of DATETIME Values in SQL Server Transact-SQL? You can use DATEPA...
What is sqlservr.exe - Process - SQL Server (SQLEX?PRESS) in SQL Server? Process sqlservr.exe is the...
What Are Bitwise Operations in SQL Server Transact-SQL? Bitwise operations are binary operations per...