Re: innodb disabled

The problem happened on production server. So i will be doing all the testings later. Thanks a lot to all of you On Thu, May 8, 2008 at 2:23 PM, Srini <[EMAIL PROTECTED]> wrote: > Is your problem fixed? > > what was the problem > > > -srini > Krishna Chandra Prajapati wrote: > >> Thanks a lot to

Re: connectors: per session persistent connection (PHP)

Paul DuBois schrieb: On May 7, 2008, at 4:36 AM, Sebastian Mendel wrote: Hi, wouldn't it be very helpful if mysql connectors support some sort of per session persistent connection? this would save a lot of queries in many apps, for example SET NAMES, setting variables, creating temporary

Re: connectors: per session persistent connection (PHP)

On May 7, 2008, at 4:36 AM, Sebastian Mendel wrote: Hi, wouldn't it be very helpful if mysql connectors support some sort of per session persistent connection? this would save a lot of queries in many apps, for example SET NAMES, setting variables, creating temporary tables How would

Re: innodb disabled

Is your problem fixed? what was the problem -srini Krishna Chandra Prajapati wrote: Thanks a lot to all of you. On Wed, May 7, 2008 at 8:51 PM, Srini <[EMAIL PROTECTED]> wrote: It could be the problem with permissions or sizes of iblog or ibdata files Can you try this back up the iblog a

LEFT JOIN without temporary table?

I want to get a list of all products that either exist or do not exist. In other words, if prod.prod_pub_prod_id exists then I want to report its prod_num; if it doesn't, then I want to report the product ID with a blank value for the prod_num. I'm currently using a temporary table to do this, but

Re: question about update/join query

Brent - thanks, now I understand. My aversion to subqueries is for performance against a very large table, which event_log promises to be. I hope to minimize this with some time boundaries on that table (where event_time between x and y). But thanks, I'll play with that. And thanks Martin for the

Re: [ excel to mysql ]

Save the excel file as a CSV text file, then use LOAD DATA INFILE command to import. See the mysql manual for usage and example. On May 8, 2008, at 4:49 AM, Lord Gustavo Miguel Angel wrote: Hi! How i do for transfer data from excel file to mysql? Some example? Thanks -- MySQL General Ma

RE: Order Problem

Perfect. It worked just how I wanted. Thanks for your help. Neil > Date: Wed, 7 May 2008 19:54:39 +0200> To: [EMAIL PROTECTED]> Subject: Re: > Order Problem> From: [EMAIL PROTECTED]> > Hi,> > You should look at the > `FIND_IN_SET` function here: > > http://dev.mysql.com/doc/refman/5.0/en

[ excel to mysql ]

Hi! How i do for transfer data from excel file to mysql? Some example? Thanks