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
