MySql Control Center

Collapse
This topic is closed.
X
X
 
  • Time
  • Show
Clear All
new posts
  • Trevor Morrison

    MySql Control Center

    Hi,

    I am new to using the Control Center-0.9.2-beta. My problem is that I
    cannot seem to display more than 1000 rows in my result set when I know that
    there is 1534 rows. I know that it is a setting somewhere, but is it in
    MySql or in the Control Center somewhere. I am running this on a Windows
    2000 machine.

    TIA

    Trevor


    --
    MySQL General Mailing List
    For list archives: http://lists.mysql.com/mysql
    To unsubscribe: http://lists.mysql.com/mysql?unsub=m...ie.nctu.edu.tw

  • Brandon

    #2
    Re: MySql Control Center

    In Control Center, right click on the server, and select edit. Select MySQL
    Options Tab, and change the "Automatica lly limit SELECT queries to" option.
    (enter 0 for unlimited)

    Brandon

    ""Trevor Morrison"" <demo@hailix.co m> wrote in message
    news:bh0clb$7v2 $1@FreeBSD.csie .NCTU.edu.tw...[color=blue]
    > Hi,
    >
    > I am new to using the Control Center-0.9.2-beta. My problem is that I
    > cannot seem to display more than 1000 rows in my result set when I know[/color]
    that[color=blue]
    > there is 1534 rows. I know that it is a setting somewhere, but is it in
    > MySql or in the Control Center somewhere. I am running this on a Windows
    > 2000 machine.
    >
    > TIA
    >
    > Trevor
    >
    >
    > --
    > MySQL General Mailing List
    > For list archives: http://lists.mysql.com/mysql
    > To unsubscribe:[/color]
    http://lists.mysql.com/mysql?unsub=m...ie.nctu.edu.tw[color=blue]
    >[/color]


    Comment

    • Brandon

      #3
      Re: MySql Control Center

      In Control Center, right click on the server, and select edit. Select MySQL
      Options Tab, and change the "Automatica lly limit SELECT queries to" option.
      (enter 0 for unlimited)

      Brandon

      ""Trevor Morrison"" <demo@hailix.co m> wrote in message
      news:bh0clb$7v2 $1@FreeBSD.csie .NCTU.edu.tw...[color=blue]
      > Hi,
      >
      > I am new to using the Control Center-0.9.2-beta. My problem is that I
      > cannot seem to display more than 1000 rows in my result set when I know[/color]
      that[color=blue]
      > there is 1534 rows. I know that it is a setting somewhere, but is it in
      > MySql or in the Control Center somewhere. I am running this on a Windows
      > 2000 machine.
      >
      > TIA
      >
      > Trevor
      >
      >
      > --
      > MySQL General Mailing List
      > For list archives: http://lists.mysql.com/mysql
      > To unsubscribe:[/color]
      http://lists.mysql.com/mysql?unsub=m...ie.nctu.edu.tw[color=blue]
      >[/color]


      Comment

      Working...