Sql control centre - How to view all the records for a table?

2004-02-10 Thread florence florence
Hi,
 
Can anyone help me that i want to view all the record from a table, but in mysql 
control centre, i only can view the first 1000 records, can anybody teach me how to 
make it can view for all the rest of the records?
 
   Thank  u.
 
regards,
 
florence




Thank you very much.

regards,

florence
 Y! Asia presents Lavalife
- Get clicking with thousands of local singles today!

Re: Sql control centre - How to view all the records for a table?

2004-02-10 Thread Hans van Dalen
MySQL CC is a beta version, I can't find an option to set this max value. 
Maybe its an option for you to use the command line functions? There is no 
maximum of the viewed records.

Hans

At 09:02 10-2-2004, you wrote:
Hi,

Can anyone help me that i want to view all the record from a table, 
but in mysql control centre, i only can view the first 1000 records, can 
anybody teach me how to make it can view for all the rest of the records?

   Thank  u.

regards,

florence



Thank you very much.

regards,

florence
 Y! Asia presents Lavalife
- Get clicking with thousands of local singles today!


--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]


Re: Sql control centre - How to view all the records for a table?

2004-02-10 Thread Ronan Lucio
> Hi,

Hi,

> Can anyone help me that i want to view all the record from a table,
but in mysql control centre, i only can view the first 1000 records, can
anybody teach me how to make it can view for all the rest of the records?

Click with the right button in the tableĀ“s name -> "Open table" - "Return
Limit"
Type the limit that you want and click OK.

Ronan



-- 
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]



Fwd: Re: Sql control centre - How to view all the records for a table?

2004-02-10 Thread Hans van Dalen

Date: Tue, 10 Feb 2004 09:13:02 +0100
To: florence florence <[EMAIL PROTECTED]>
From: Hans van Dalen <[EMAIL PROTECTED]>
Subject: Re: Sql control centre - How to view all the records for a table?
If you right click the table then you can choose: Return limit. At that 
moment you can give your own limit... Give a big number and wait for 
a  long time ;-))

At 09:02 10-2-2004, you wrote:
[EMAIL PROTECTED]


--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]