CREATE VIEW in cPanel at SiteGround

[Ed Poor]

Hi, I'm completely new to PHP and MySQL and I'm using phpMyAdmin - 2.9.0.2 to create a view. I think my syntax is correct:

CREATE VIEW boston
SELECT * from contacts
WHERE city = 'boston'

but I get an error message indicating I don't have the correct privileges. This seems odd to me since I am the one who created the database! Do I have to assign myself greater privileges or log on under a different user name?

I can create and drop tables - why can't I create a view?

Ed Poor

[Ed Poor]

Error

SQL query:
CREATE VIEW v AS SELECT *
FROM `person`
WHERE ID >5
MySQL said:
#1064 - You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'view v as
SELECT * FROM `person` WHERE ID > 5' at line 1

[vladimir_cz]

looks like your mySQL engine don't support views as well.
http://dev.mysql.com/doc/refman/5.0/en/create-view.html

[vladimir_cz]

looks like your mySQL engine don't support views as well.
http://dev.mysql.com/doc/refman/5.0/en/create-view.html

[Ed Poor]

Originally Posted by vladimir_cz

looks like your mySQL engine don't support views as well.
http://dev.mysql.com/doc/refman/5.0/en/create-view.html

Thanks, Vladimir. The man at SiteGround said the same thing. I'll have to upgrade, or just write my code without views.

Ed