MySQL - Drop an Existing View in MySQL

Drop an Existing View in MySQL

Q

How To Drop an Existing View in MySQL?

✍: FYIcenter.com

A

If you have an existing view, and you don't want it anymore, you can delete it by using the "DROP VIEW viewName" statement as shown in the following script:

mysql> DROP VIEW faqComment;
Query OK, 0 rows affected (0.00 sec)

mysql> SELECT * FROM faqComment;
ERROR 1146 (42S02): Table 'fyi.faqcomment' doesn't exist

⇒CREATE, ALTER and DROP Statements in MySQL

⇒⇒MySQL Database Tutorials

2018-01-24, 614👍, 0💬

Drop an Existing Index in MySQL
How To Drop an Existing Index in MySQL? If you don't need an existing index any more, you should delete it with the "DROP INDEX indexName ON tableName" statement. Here is an example SQL script: mysql> DROP INDEX tip_subject ON tip; Query OK, 0 rows affected (0.13 sec) Records: 0 Duplicates: 0... 2018-02-14, 686👍, 0💬

Drop an Existing View in MySQL
How To Drop an Existing View in MySQL? If you have an existing view, and you don't want it anymore, you can delete it by using the "DROP VIEW viewName" statement as shown in the following script: mysql> DROP VIEW faqComment; Query OK, 0 rows affected (0.00 sec) mysql> SELECT * FROM faq... 2018-01-24, 615👍, 0💬

Create a New View in MySQL
How To Create a New View in MySQL? 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.... 2018-01-24, 597👍, 0💬

What Are DML Statements in MySQL
What Are DML Statements in MySQL? DML (Data Manipulation Language) statements are statements to change data values in database tables. The are 3 primary DML statements: INSERT - Inserting new rows into database tables. UPDATE - Updating existing rows in database tables . DELETE - Deleting existing r... 2018-01-24, 587👍, 0💬

All rights in the contents of this web site are reserved by the individual author. fyicenter.com does not guarantee the truthfulness, accuracy, or reliability of any contents.