libertyct Posted September 25, 2007 Share Posted September 25, 2007 I am having diffuculty creating views, i have tried the following example... CREATE TABLE t (qty INT, price INT); INSERT INTO t VALUES(3, 50); CREATE VIEW v AS SELECT qty, price, qty*price AS value FROM t; SELECT * FROM v; it still wont work, i get some user privildge error, i've also heard there misght be a bug in mysql that causes this. has anybody experienced the same issue? Link to comment https://forums.phpfreaks.com/topic/70666-mysql-create-view/ Share on other sites More sharing options...
fenway Posted September 25, 2007 Share Posted September 25, 2007 Which mysql version? Link to comment https://forums.phpfreaks.com/topic/70666-mysql-create-view/#findComment-355186 Share on other sites More sharing options...
libertyct Posted September 25, 2007 Author Share Posted September 25, 2007 Thnx for the response. I am currently hosting with netfirms and the site says MySQL 5+ is the version. i am using SQLYog too Link to comment https://forums.phpfreaks.com/topic/70666-mysql-create-view/#findComment-355194 Share on other sites More sharing options...
fenway Posted September 25, 2007 Share Posted September 25, 2007 And you've checked the grants table to make sure do have this permission? Link to comment https://forums.phpfreaks.com/topic/70666-mysql-create-view/#findComment-355240 Share on other sites More sharing options...
Recommended Posts
Archived
This topic is now archived and is closed to further replies.