Just run the query: SELECT * FROM table_name_goes_here;
To see all of the columns and all of the data in a particular table. I
don't use the control center but I have heard that if you do not change a
setting, it limits you by default to viewing only the first 1000 records of
any query. How to set that value was answered recently in this same list so
you should be able to find it in the archives rather easily.
Yours,
Shawn Green
Database Administrator
Unimin Corporation - Spruce Pine
Philippe
Poelvoorde To: [EMAIL PROTECTED]
<[EMAIL PROTECTED] cc:
ing.co.uk> Fax to:
Subject: Control Center : dump
07/09/2004 06:34
AM
Hi,
mysqlcc have a nice option which is : show create, but is there a menu
where one can obtain something like : show insert (or a dump of the table)
?
--
Philippe Poelvoorde
COS Trading Ltd.
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
