.prod_discont < a.prod_discont
WHERE
alias_for_a.prod_num IS NULL
ORDER BY b.prod_pub_prod_id;
US Data Export wrote:
-Original Message-
From: Bill newton [mailto:[EMAIL PROTECTED]
Sent: Tuesday, November 18, 2008 6:49 PM
To: Jerry Schwartz
Cc: 'mysql'
Subject: Re: Findin
ards,
Jerry Schwartz
The Infoshop by Global Information Incorporated
195 Farmington Ave.
Farmington, CT 06032
860.674.8796 / FAX: 860.674.8341
www.the-infoshop.com
www.giiexpress.com
www.etudes-marche.com
--
Bill Newton
Network Merchants Inc.
http://www.nmi.com
(847) 352-485
707 08 08 (phone) +32 (0)3 707 06 06 (fax) +32 (0)473
47 62 88 (mobile) [EMAIL PROTECTED] http://www.metastable.be BTW-BE
0873.645.643 bankrek.nr. ING 363-0106543-77
--
Bill Newton
Network Merchants Inc.
http://www.nmi.com
(847) 352-4850 ext 141/ Tel
(888) 829-3631/ Fax
--
MySQL General Maili
--
No virus found in this incoming message.
Checked by AVG - http://www.avg.com Version: 8.0.175 / Virus Database:
270.8.2/1739 - Release Date: 10/22/2008 7:23 AM
--
Bill Newton
Network Merchants Inc.
http://www.nmi.com
(847) 352-4850 ext 141/ T
th this: *BDB support will be removed. * Note
that,
as of MySQL 5.1, BDB isn't supported any longer.
http://dev.mysql.com/doc/refman/5.0/en/bdb-storage-engine.html
But you're right that as a storgage engine, there have been very few
questions related to it, on this mailing list anyw
Try using the sub query as a derived table ala:
SELECT eo_name_table.eo_name, eo_name_table.eo_pub_date
FROM eo_name_table LEFT JOIN (SELECT prod.prod_title FROM prod WHERE prod.prod_discont = 0) fake_prod on eo_name_table.eo_name = fake_prod.prod_title
WHERE prod.prod_title IS NULL
I'm not
Hi Jerry,
I think the problem is that NULL is not less than or greater than your
prod_published date. So you probably have eo_pub_date set to NULL in 56
of your rows.
so for
eo_name_table.eo_pub_date > prod.prod_published
or
eo_name_table.eo_pub_date <= prod.prod_published
mysql will rer
To get a blank line instead of NULL you could simply wrap the reference
in an IFNULL function:
select dummy.row_id,IFNULL(real.reference,'') as Reference from dummy left join
real on
real.row_id=dummy.row_id;
Phil wrote:
you could do something like
select dummy.row_id,real.reference from
From the download page:
Please note that at this point only the Windows Beta version is
available. Linux and OS X releases will be available in 2008.
It looks nice, I was looking for a similar tool 5 -6 years ago. It looks
like what I would have wanted at the time.
legolas wrote:
Is ther
Will mysql-table-checksum from mysql toolkit work with setups that have
different Master/ Slave storage engines? Are there any things to
consider when using it between two different engines ( say Innodb master
and MyIsam slave)?
Thanks in advance,
Bill Newton
--
MySQL General Mailing
Hi Koki,
You have to re- establish the database connection in each child process.
Otherwise the packets get mangled and you get the errors you're seeing.
Koki Takeda wrote:
I hope that my contacting you is not an imposition in any way.
My name is Koki Takeda.
This time, I made the php progr
Hello,
Je peux lire des Français, mais l'écriture qu'il n'est pas comme facile.
Ainsi j'emploie des poissons de Babel pour traduire ceci
d'anglais-français. Ainsi, mes excuses s'il la grammaire est totalement
erroné.
Très intéressant. Je devinerais que le problème s'est produit dans le
tra
12 matches
Mail list logo
