[EMAIL PROTECTED] 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: [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]
-- Philippe Poelvoorde COS Trading Ltd. +44.(0)20.7376.2401 [EMAIL PROTECTED]
-- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
