performance question

All, Just curious as to which query would be better in terms of performance: select * from (select * from a union select * from b) as c; versus select * from a union select * from b; or would these 2 queries be the same ? Thanks, Yong. Yong Lee Developer [EMAIL PROTECTED]

Re: C++ cache MYSQL_RES

Wel Don't want to spoil the party, but it would be helpfull if you post some code. My crystalball is in the repairshop at the moment, zo it is pretty hard to guess what the problem is... Met vriendelijke groet, Open Systems Development Peter M. Groen Klipperwerf 12 2317 DZ Leiden Telef :

C++ cache MYSQL_RES

Hi, Is there a way to cache the MYSQL_RES in C++? I've tried to develop a class with functions returning the MYSQL_RES, MYSQL_ROW and MYSQL_FIELDS. The functions work fine within the class file. But if I call the functions where else, I'll either get 'Segmentation fault' or 'bus error'. Any i

Re: Selecting a column with a regular expression applied to it?

On 9/11/08, Ryan Stille <[EMAIL PROTECTED]> wrote: > > Thank you for the link Darryle, but I don't think you read through my whole > question. I have already read through that page, and I see how to use regex > as a condition for a select. What I am interested in is applying a regex to > a column

Re: Selecting a column with a regular expression applied to it?

Thank you for the link Darryle, but I don't think you read through my whole question. I have already read through that page, and I see how to use regex as a condition for a select. What I am interested in is applying a regex to a column as I select it.Selecting a varchar column with all t

RE: Selecting a column with a regular expression applied to it?

>-Original Message- >From: Darryle Steplight [mailto:[EMAIL PROTECTED] >Sent: Thursday, September 11, 2008 10:00 AM >To: Ryan Stille >Cc: mysql@lists.mysql.com >Subject: Re: Selecting a column with a regular expression applied to it? > >Hi Ryan, > >MySql does have regular expressions. See L

Re: Selecting a column with a regular expression applied to it?

Hi Ryan, MySql does have regular expressions. See Link http://dev.mysql.com/doc/refman/5.0/en/regexp.html On Thu, Sep 11, 2008 at 9:52 AM, Ryan Stille <[EMAIL PROTECTED]> wrote: > From looking at the MySQL 5 docs, it doesn't look like there is any way to > select a column with a regular expressio

Selecting a column with a regular expression applied to it?

From looking at the MySQL 5 docs, it doesn't look like there is any way to select a column with a regular expression applied to it? I have a column that has ended up with some non ascii characters in it, probably vertical tabs and things like that from MS Excel. I need to sort by this field b

Error restarting Clusternode

I'm getting 2008-09-11 10:42:25 [MgmSrvr] ALERT-- Node 1: Node 3 Disconnected 2008-09-11 10:42:25 [MgmSrvr] ALERT-- Node 3: Forced node shutdown completed. Occured during startphase 4. Caused by error 2306: 'Pointer too large(Internal error, programming error or missing error message, p