List:General Discussion« Previous MessageNext Message »
From:Philippe Poelvoorde Date:July 9 2004 3:21pm
Subject:Re: Control Center : dump
View as plain text  
SGreen@stripped wrote:

> 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.

SELECT ... just shows the data, and does not generate :
INSERT INTO my_table (...)
that a 'mysqldump my_base my_table' would do.
It doesn't matter, I don't usually use the CC, but that can be useful.


> 
> 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
> 
> 
> 
> 
> 
> 
> 


-- 
Philippe Poelvoorde
COS Trading Ltd.
+44.(0)20.7376.2401
philippe@stripped
Thread
Control Center : dumpPhilippe Poelvoorde9 Jul
Re: Control Center : dumpSGreen9 Jul
  • Re: Control Center : dumpPhilippe Poelvoorde9 Jul