Results 1 to 2 of 2
  1. #1
    Join Date
    Jul 2006
    Posts
    1

    Unanswered: Restricting MYSQL

    Hello guys,

    I want to restrict mysql instance from execution queries with huge resultset or to nicely put it Is there a way where I can ask mysql to reject any query with resultset exceeding 10K rows?

  2. #2
    Join Date
    Apr 2002
    Location
    Toronto, Canada
    Posts
    20,002
    you can use LIMIT to restrict the number of rows returned in the result set

    i don't thnk there is any way to prevent ahead of time a "large" query from being executed a
    rudy.ca | @rudydotca
    Buy my SitePoint book: Simply SQL

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •