Error creating MySQL view in phpMyAdmin

mysql phpmyadmin sql-view
Rich picture Rich · Oct 28, 2016 · Viewed 14.2k times · Source

I'm having a hard time trying to create a view in phpMyAdmin. I have a database named myDB and a table named myTable.

In phpMyAdmin I click on the SQL tab, type in :

SHOW CREATE VIEW myView;

I got this error MySQL said:

#1146 - Table 'myTable.myView' doesn't exist

I don't understand this error message at all, of course it doesn't exist, otherwise why would I want to create it in the first place? And why wouldn't mySQL allow me to create it? How do I create a view?

Thanks

Answer

Vrunda Savaliya picture Vrunda Savaliya · Jan 2, 2017 
SHOW CREATE VIEW

The syntax you are using is not for creating view in SQL. it is to show the views you have created in SQL

You need to use the following syntax to create a view

CREATE VIEW view_name AS
SELECT column_name(s)
FROM table_name
WHERE condition

Related questions

ERROR 2002 (HY000): Can't connect to local MySQL server through socket '/var/run/mysqld/mysqld.sock' (2)

I installed LAMP on Ubuntu 12.04 LTS (Precise Pangolin) and then set root password on phpMyAdmin. I forgot the password and now I am unable to login. When I try to change password through terminal I get: ERROR 2002 (HY000): Can't connect …

Read More
Import file size limit in PHPMyAdmin

I have changed all the php.ini parameters I know: upload_max_filesize, post_max_size. Why am I still seeing 2MB? Im using Zend Server CE, on a Ubuntu VirtualBox over a Windows 7 host.

Read More
Setting up foreign keys in phpMyAdmin?

I'm setting up a database using phpMyAdmin. I have two tables (foo and bar), indexed on their primary keys. I am trying to create a relational table (foo_bar) between them, using their primary keys as foreign keys. I created …

Read More