List:General Discussion« Previous MessageNext Message »
From:SGreen Date:July 9 2004 2:31pm
Subject:Re: Control Center : dump
View as plain text  
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:       mysql@stripped            
                            
                      <philippe@costrad        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/mysql?unsub=1






Thread
Control Center : dumpPhilippe Poelvoorde9 Jul
Re: Control Center : dumpSGreen9 Jul
  • Re: Control Center : dumpPhilippe Poelvoorde9 Jul