Re: Restricting number of records in a single query
Posted by:
Danny Wang
Date: April 14, 2011 03:07PM
You can create a view and let user only access the view, looks like
create view v1 as select * from vendors limit 10;
But please be aware that MySQL optimizer is not that smart so when you join with the view, you might get performance problem.
Subject
Written By
Posted
Re: Restricting number of records in a single query
April 14, 2011 03:07PM
Sorry, you can't reply to this topic. It has been closed.
Content reproduced on this site is the property of the respective copyright holders.
It is not reviewed in advance by Oracle and does not necessarily represent the opinion
of Oracle or any other party.