Mysql - Tables Export to Excel!

Hi, I would like to export my table structure from MYSQL from a particular db. Is there any tool for doing this? Please guide me. Thank you VIKRAM A

problem reading array data

I need to read an array's content using a while loop and inside the loop read another array's content. Using the variables from the two arrays I need to execute a query. My problem is the inner while loop reads all records of the array whereas the outer while loop exits after reading the first reco

Re: MyISAM better than innodb for large files?

Also depends on your data access pattern as well. If you can take advantage of clustering my primary key for your selects, then InnoDB could do it for you. My suggestion would be to write some queries based on projected workload, build 2 tables with lots and lots of data, and do some isolated testi

How to View MySQL Temp Files and Temp Tables in Linux

Below is my MySQL Server's status and configuration. But I can not see anything under /tmpfs/, it is showing empty to me. here is the result of "ls -al" drwxrwxrwx 2 mysql mysql60 Apr 7 17:43 tmpfs Could anyone tell me how to check the status of temp files and temp tables on disk? Thanks.

Re: SHOW TABLE STATUS

AFAIR, MySQL 4.x supports LIKE, e.g. SHOW TABLE STATUS LIKE 'tab_%' / Carsten spacemarc skrev: hi all, in MySQL 4.1.x i want to obtain the status of more tables with one only query. In 5.x i use "SHOW TABLE STATUS WHERE Name IN ('tab_1', tab_2, 'tab_3')" In 4.1.x i tried to use but it doesn'

SHOW TABLE STATUS

hi all, in MySQL 4.1.x i want to obtain the status of more tables with one only query. In 5.x i use "SHOW TABLE STATUS WHERE Name IN ('tab_1', tab_2, 'tab_3')" In 4.1.x i tried to use but it doesn't works: how to set the query? Thanks -- MySQL General Mailing List For list archives: http://lis

Re: subquery multiple rows

yea.. almost. but it helped a lot. now i know about those functions too. thank you... Nathan Sullivan wrote: I think you want to do something like this: select prod, group_concat(category separator ', ') from products group by prod; Hope this helps. On Wed, Apr 07, 2010 at 08:37:04AM

Re: subquery multiple rows

I think you want to do something like this: select prod, group_concat(category separator ', ') from products group by prod; Hope this helps. On Wed, Apr 07, 2010 at 08:37:04AM -0700, kalin m wrote: > > hi all... > > i have a bit of a problem with this: > > table products: > > --

Re: subquery multiple rows

On Wed, 2010-04-07 at 11:37 -0400, kalin m wrote: > hi all... > > i have a bit of a problem with this: > > table products: > > -- > prod | category | > -| > boots | winter| > boots | summer | > boots | spring | > shoes | spring | > shoes |

subquery multiple rows

hi all... i have a bit of a problem with this: table products: -- prod | category | -| boots | winter| boots | summer | boots | spring | shoes | spring | shoes | winter| shoes | fall | shoes | summer | --