In article [EMAIL PROTECTED],
Jeff Gannaway [EMAIL PROTECTED] writes:
I've got one huge table (table a), and two smaller tables (tables b and c)
I need to find which records in 'table a' are not in 'table b' nor are
they in 'table c'.
The Primary Key for all 3 tables is 'ProductID'.
I
Hello,
I am not able to change character set using set character set.
/etc/my.cnf (important parts)
[client]
character-sets-dir = /usr/local/share/mysql/charsets
---
content of that directory:
dns:/usr/local/share/mysql/charsets# ls
cp1251.conf dos.conf hp8.conf
Hi All
This may be a longshot or it could just be the place where the answer is. I
have asked something similiar before regarding this but never could a clear view
of the way to proceed.
Anyway, here it is. Simply I have an offline mirror of oscommerce what I woould
like to do is keep the
Jeff
Why are you doing a LEFT JOIN instead of a INNER JOIN
right now you are getting all rows from first table regardless of match
condition so all of the rows for
a.ProductID FROM ImportLiebermansStep3Add
are being returned
try the inner join instead
Martin
- Original Message -
From: Jeff
Hello
I need to access the mysql's connection handling ,,
are there any exposed API's that can allow me to see
what is being received on 3306 for serverand can i
hold that data for some checks so that if my check
goes perfrect ill let allow that data to pass on to
server for further request
I dont think so, but I might be wrong.
I belive in your case u have to write a custom app
that listens on port 3306 and checks for every data
transfer.
Karam
--- Sheraz [EMAIL PROTECTED] wrote:
Hello
I need to access the mysql's connection handling ,,
are there any exposed API's that can
I know the boat has probably sailed by now on this thread, but as far as I
saw nobody has thrown in what I was going to say.
A simple blanket statement like Design for understanding, logic and
maintenance, not performance. is a little too glossy.
You can't put all database usage into the one
Hmm...can someone help me on this? Many thanks.
- Forwarded by Joseph S CHUNG/OGCIO/HKSARG on 2004-07-12 09:40 -
Joseph S CHUNG
Hi Jeremy,
I didn't find any resouce limit but the performace is very bad. Do you have
any suggestion how to tune the solaris to provide the better performance for
Solaris?
Linda
- Original Message -
From: Jeremy Zawodny [EMAIL PROTECTED]
To: Linda [EMAIL PROTECTED]
Cc: [EMAIL
