I'm beating my head against the wall. I just can't see
what's wrong with it; what would be causing the error:
SELECT certificate.cert_num, master_info.uid
FROM certificate
JOIN master_info ON ( certificate.uid = master_info.uid )
LEFT JOIN endorsements ON ( certificate.cert_num =
On 10 Jul 2003 at 13:20, Chris Boget wrote:
SELECT certificate.cert_num, master_info.uid
FROM certificate
JOIN master_info ON ( certificate.uid = master_info.uid )
LEFT JOIN endorsements ON ( certificate.cert_num =
endorsements.cert_num ) WHERE certificate.active = 1 AND
what would be causing the error:
SELECT certificate.cert_num, master_info.uid
FROM certificate
JOIN master_info ON ( certificate.uid = master_info.uid )
LEFT JOIN endorsements ON ( certificate.cert_num =
endorsements.cert_num )
WHERE certificate.active = 1
AND certificate.referred = 0
AND
Why isn't the key being used in the c (certificate) table?
SELECT DISTINCT a.uid, a.company, a.firstname, a.lastname
FROM master_info a, logins lsl, logins lc, certificate c WHERE
a.uid = lsl.uid AND lc.parent = lsl.uid AND lc.uid = c.uid AND
c.void 1 AND c.status IN
('CP', 'MC',
Why isn't the key being used in the c (certificate) table?
SELECT DISTINCT a.uid, a.company, a.firstname, a.lastname
FROM master_info a, logins lsl, logins lc, certificate c WHERE
a.uid = lsl.uid AND lc.parent = lsl.uid AND lc.uid = c.uid AND
c.void 1 AND c.status IN
('CP', 'MC', 'AIC',
On 19 Jun 2003 at 16:18, Chris Boget wrote:
Why isn't the key being used in the c (certificate) table?
SELECT DISTINCT a.uid, a.company, a.firstname, a.lastname
FROM master_info a, logins lsl, logins lc, certificate c WHERE
a.uid = lsl.uid AND lc.parent = lsl.uid AND lc.uid = c.uid AND
Please help me with the following c code:
sprintf(update, update chrc set center=');
len = 24;
memcpy(update+len, center, 128);
len += 128;
sprintf(update+len, ', var=');
len += 8;
Hi all,
I've tried to create the following type of field in a table:
create table temp(id float(100,50) unsigned);
insert into temp
values(123.1234567890123456789012345678901234567890123456789012345);
select * from temp;
This prints:
123.12345886230469
What's wrong with MySQL?