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? Quote 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? Quote 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 Quote 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? Quote Link to comment https://forums.phpfreaks.com/topic/70666-mysql-create-view/#findComment-355240 Share on other sites More sharing options...
Recommended Posts
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.