How to pronounce MyISAM and InnoDB

[js]

Hi list,

Sorry for this silly question but I've been always had trouble
pronouncing "MyISAM" and InnoDB.
How do you pronunce them?

Thanks in advance.

[Brian Dunning]

My friend says "my sam" and "in-NOD-b". I want to kill him every
time. He also says "jif" instead of "gif".

I just say
"My, I, Sam" and "inno, d, b"
Michael
-----Original Message-----
Date: Mon, 8 Jan 2007 00:09:15
Subject: How to pronounce MyISAM and InnoDB
Hi list,
Sorry for this silly question but I've been always had trouble
pronouncing "MyISAM" and InnoDB.
How do you pronunce them?
Thanks in advance.
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/mysql?
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/mysql?

[Jan Pieter Kunst]

Post by js
Hi list,
Sorry for this silly question but I've been always had trouble
pronouncing "MyISAM" and InnoDB.
How do you pronunce them?
Thanks in advance.

When I'm speaking Dutch (which is most of the time) I say

My-ee-sahm
Inno-day-bay

JP

[Philip Mather]

Jan,
In English I pronounce them as...

My-eye-sam
In-oh-dee-bee

...respectively.

Regards,
Phil

Post by Jan Pieter Kunst

Post by js
Hi list,
Sorry for this silly question but I've been always had trouble
pronouncing "MyISAM" and InnoDB.
How do you pronunce them?
Thanks in advance.

When I'm speaking Dutch (which is most of the time) I say
My-ee-sahm
Inno-day-bay
JP

[TK]

Post by Brian Dunning
My friend says "my sam" and "in-NOD-b". I want to kill him every
time. He also says "jif" instead of "gif".

The GIF Pronunciation Page:
http://www.olsenhome.com/gif/

In short, the original inventors of the GIF format (CompuServe, 1987) have always defined the pronunciation to be like "JIF." So, that has always been the "correct" pronunciation.

- TK

Post by Brian Dunning

I just say
"My, I, Sam" and "inno, d, b"
Sorry for this silly question but I've been always had trouble
pronouncing "MyISAM" and InnoDB.

[Brian Dunning]

Post by TK
In short, the original inventors of the GIF format (CompuServe,
1987) have always defined the pronunciation to be like "JIF." So,
that has always been the "correct" pronunciation.

Sure, so I'll start pronouncing "graphics" as "jraphics".

[Jerry Schwartz]

... Especially for tall ones.

Regards,

Jerry Schwartz
Global Information Incorporated
195 Farmington Ave.
Farmington, CT 06032

860.674.8796 / FAX: [phone]

-----Original Message-----
Sent: Friday, January 12, 2007 1:49 PM
To: mysql
Subject: Re: [OT} How to pronounce GIF (was: Re: How to
pronounce MyISAM and InnoDB)

Post by TK
In short, the original inventors of the GIF format (CompuServe,
1987) have always defined the pronunciation to be like "JIF." So,
that has always been the "correct" pronunciation.

Sure, so I'll start pronouncing "graphics" as "jraphics".
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql

[Gerald L. Clark]

Post by Brian Dunning

In short, the original inventors of the GIF format (CompuServe, 1987)
have always defined the pronunciation to be like "JIF." So, that has
always been the "correct" pronunciation.

Sure, so I'll start pronouncing "graphics" as "jraphics".

How do you pronounce "giraffe"?

[m***@netscape.net]

Hi,

gif will inevitably gravitate towards jif for the same reason SQL is
sequel and lib, as in /usr/lib, is often 'libe'. The reasons
are described in the Appendix to Orwell's 1984 which is dedicated to
newspeak, look for 'duckspeak' in particular,
and the consideration of 'Minitruethful' vs 'Minitrueful'. In other
words the pronunciation will be such that
chances of the other party to actually think about its meaning be as
little as possible. This is very good
in a job interview situation (I have no idea what TCP/IP means but I
desperately need this job...) or
in IT salesman pitches which most of the time amount to 'give us your
money in exchange for a lot of frustration
trying to use our product' but you're far more likely to hear words
like Java, Internet or even whole nice
sounding expressions like 'closing the digital gap' or 'business
intelligence' or 'globalization'.
Giraffe, on the other hand, could be pronounced in every which way
possible unless uttering it
can gain you an advantage, I guess if you are biologists discussing
giraffe breeding.

Thanks,
Michael

-----Original Message-----
From: ***@suppliersystems.com
To: ***@briandunning.com
Cc: ***@lists.mysql.com
Sent: Fri, 12 Jan 2007 2:04 PM
Subject: Re: [OT} How to pronounce GIF

Post by Gerald L. Clark

Post by TK
In short, the original inventors of the GIF format (CompuServe,

1987) >> have always defined the pronunciation to be like "JIF." So,
that has >> always been the "correct" pronunciation.

Post by Gerald L. Clark

Post by TK
Sure, so I'll start pronouncing "graphics" as "jraphics".

How do you pronounce "giraffe"?

-- Gerald L. Clark
Supplier Systems Corporation

-- MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:
http://lists.mysql.com/mysql?unsub=***@netscape.net

________________________________________________________________________
Check Out the new free AIM(R) Mail -- 2 GB of storage and
industry-leading spam and email virus protection.

[Chris White]

I'll bite..

Post by js
Sorry for this silly question but I've been always had trouble
pronouncing "MyISAM" and InnoDB.
How do you pronunce them?

I pronounce MyISAM as "give-me-foreign-keys" and InnoDB as
"curse-you-cryptic-foreign-key-errors"

(currently running far and fast)

[John Trammell]

Way offoptic now....

How do you pronounce "gift"? :^)

$ egrep '^gif' /usr/share/dict/words
gift
gift's
gifted
gifting
gifts

To heck with the spec, all precedent in English says hard G.

Next they'll tell us to pronounce "jpeg" as "gay-peg".


-----Original Message-----
From: Gerald L. Clark [mailto:***@suppliersystems.com]
Sent: Friday, January 12, 2007 1:04 PM
To: Brian Dunning
Cc: mysql
Subject: Re: [OT} How to pronounce GIF

Post by Brian Dunning

Post by TK
In short, the original inventors of the GIF format (CompuServe,
1987) have always defined the pronunciation to be like "JIF." So,
that has always been the "correct" pronunciation.

Sure, so I'll start pronouncing "graphics" as "jraphics".

How do you pronounce "giraffe"?

--
Gerald L. Clark
Supplier Systems Corporation

--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/mysql?unsub=***@holmescorp.com



INFORMATION IN THIS MESSAGE, INCLUDING ANY ATTACHMENTS, IS INTENDED FOR THE PERSONAL AND CONFIDENTIAL USE OF THE INTENDED RECIPIENT(S) NAMED ABOVE. If you are not an intended recipient of this message, or an agent responsible for delivering it to an intended recipient, you are hereby notified that you have received this message in error, and that any review, dissemination, distribution, or copying of this message is strictly prohibited. If you received this message in error, please notify the sender immediately, delete the message, and return any hard copy print-outs.

This message has been scanned for viruses by McAfee's Groupshield.

[David Ruggles]

I'm new to this list, but have searched through the archives and haven't
found anything that addresses my question.

First a little background:

I'm creating a supply ordering system. Each supply order may be modified
many times before being approved and finally filled.

I created the following databases:

Supplyorder
uid double (auto) (pk)
site double
date date

Supplyorderhistory
uid double (auto) (pk)
supplyorderuid double
status double

Supplyorderlineitems
uid double (auto) (pk)
supplyorderhistoryuid double
other fields ...

Each time an existing supply order is modified a new history record is
created so we have a paper trail of all the changes made to the order and
the specific line items ordered are associated with the history record.

I want to select for a given date all sites that have the last history
record with a certain status.

This will select the last history record for each site:

SELECT MAX(h.uid), site FROM supplyorder AS s, supplyorderhistory AS h
WHERE h.supplyorderuid = s.uid AND date = '2007-01-08' GROUP BY s.uid

But if I do this:

SELECT MAX(h.uid), site FROM supplyorder AS s, supplyorderhistory AS h
WHERE h.supplyorderuid = s.uid AND date = '2007-01-08' and status = '2'
GROUP BY s.uid

Max just becomes the last history record with a status of 2. I understand
why it is working this way and that it is working correctly, I just don't
know how to get what I want out of it.

Thanks in advance for any help.

Thanks,

David Ruggles
CCNA MCSE (NT) CNA A+
Network Engineer Safe Data, Inc.
[phone] ***@safedatausa.com

[Peter Brawley]

David,

Post by David Ruggles
I want to select for a given date all sites that have
the last history record with a certain status.

Try something like ...

SELECT h1.supplyorderid
FROM supplyorder o
JOIN supplyorderhistory h1 ON o.uid=h1.supplyorderuid
LEFT JOIN supplyorderhistory h2
ON h2.supplyorderuid = h.supplyorderuid
AND h1.status=2
AND h1.uid < h2.uid
WHERE o.date=<given_date>
AND h2.uid IS NULL

There's a brief discussion of this query pattern at
http://www.artfulsoftware.com/mysql-queries.php; in the left panel click
on 'Aggregates' then on 'Within-group aggregates'.

BTW your id columns should be ints not doubles, bigints if you expect
huge rowcounts. Likewise status.

PB

-----

Post by David Ruggles
I'm new to this list, but have searched through the archives and haven't
found anything that addresses my question.
I'm creating a supply ordering system. Each supply order may be modified
many times before being approved and finally filled.
Supplyorder
uid double (auto) (pk)
site double
date date
Supplyorderhistory
uid double (auto) (pk)
supplyorderuid double
status double
Supplyorderlineitems
uid double (auto) (pk)
supplyorderhistoryuid double
other fields ...
Each time an existing supply order is modified a new history record is
created so we have a paper trail of all the changes made to the order and
the specific line items ordered are associated with the history record.
I want to select for a given date all sites that have the last history
record with a certain status.
SELECT MAX(h.uid), site FROM supplyorder AS s, supplyorderhistory AS h
WHERE h.supplyorderuid = s.uid AND date = '2007-01-08' GROUP BY s.uid
SELECT MAX(h.uid), site FROM supplyorder AS s, supplyorderhistory AS h
WHERE h.supplyorderuid = s.uid AND date = '2007-01-08' and status = '2'
GROUP BY s.uid
Max just becomes the last history record with a status of 2. I understand
why it is working this way and that it is working correctly, I just don't
know how to get what I want out of it.
Thanks in advance for any help.
Thanks,
David Ruggles
CCNA MCSE (NT) CNA A+
Network Engineer Safe Data, Inc.

[David Ruggles]

Thanks! I'll make the column type change.

Thanks,

David Ruggles
CCNA MCSE (NT) CNA A+
Network Engineer Safe Data, Inc.
[phone] ***@safedatausa.com



-----Original Message-----
From: Peter Brawley [mailto:***@earthlink.net]
Sent: Friday, January 12, 2007 3:42 PM
To: David Ruggles
Cc: 'mysql'
Subject: Re: Selecting records based on max and value


David,

Post by David Ruggles
I want to select for a given date all sites that have
the last history record with a certain status.

Try something like ...

SELECT h1.supplyorderid
FROM supplyorder o
JOIN supplyorderhistory h1 ON o.uid=h1.supplyorderuid
LEFT JOIN supplyorderhistory h2
ON h2.supplyorderuid = h.supplyorderuid
AND h1.status=2
AND h1.uid < h2.uid
WHERE o.date=<given_date>
AND h2.uid IS NULL

There's a brief discussion of this query pattern at
http://www.artfulsoftware.com/mysql-queries.php; in the left panel click
on 'Aggregates' then on 'Within-group aggregates'.

BTW your id columns should be ints not doubles, bigints if you expect
huge rowcounts. Likewise status.

PB

-----

Post by David Ruggles
I'm new to this list, but have searched through the archives and haven't
found anything that addresses my question.
I'm creating a supply ordering system. Each supply order may be modified
many times before being approved and finally filled.
Supplyorder
uid double (auto) (pk)
site double
date date
Supplyorderhistory
uid double (auto) (pk)
supplyorderuid double
status double
Supplyorderlineitems
uid double (auto) (pk)
supplyorderhistoryuid double
other fields ...
Each time an existing supply order is modified a new history record is
created so we have a paper trail of all the changes made to the order and
the specific line items ordered are associated with the history record.
I want to select for a given date all sites that have the last history
record with a certain status.
SELECT MAX(h.uid), site FROM supplyorder AS s, supplyorderhistory AS h
WHERE h.supplyorderuid = s.uid AND date = '2007-01-08' GROUP BY s.uid
SELECT MAX(h.uid), site FROM supplyorder AS s, supplyorderhistory AS h
WHERE h.supplyorderuid = s.uid AND date = '2007-01-08' and status = '2'
GROUP BY s.uid
Max just becomes the last history record with a status of 2. I understand
why it is working this way and that it is working correctly, I just don't
know how to get what I want out of it.
Thanks in advance for any help.
Thanks,
David Ruggles
CCNA MCSE (NT) CNA A+
Network Engineer Safe Data, Inc.

[Shawn Green]

Hi David,

<snip>
Supplyorder
uid double (auto) (pk)
site double
date date
Supplyorderhistory
uid double (auto) (pk)
supplyorderuid double
status double
Supplyorderlineitems
uid double (auto) (pk)
supplyorderhistoryuid double
other fields ...
Each time an existing supply order is modified a new history record is
created so we have a paper trail of all the changes made to the order and
the specific line items ordered are associated with the history record.
I want to select for a given date all sites that have the last history
record with a certain status.
<snip>
David Ruggles
CCNA MCSE (NT) CNA A+
Network Engineer Safe Data, Inc.

This takes two steps. First we find the last histories:

CREATE TEMPORARY TABLE tmpLastChanges
SELECT MAX(h.uid) max_id, h.supplyorderuid FROM supplyorderhistory AS h
WHERE date = '2007-01-08' GROUP BY h.supplyorderuid;

Then use that list to get the actual records you seek:

SELECT max_id, site
FROM tmpLastChanges tlc
INNER JOIN supplyorderhistory h
on tlc.max_id = h.uid
AND h.status = 2
INNER JOIN supplyorder AS s,
WHERE h.supplyorderuid = s.uid;

This is just one way to implement a "group-wize maximum" query pattern. Search the list and the rest of the web for this term and you will see many other variations.
--
Shawn Green, Support Engineer
MySQL Inc., USA, www.mysql.com
Office: Blountville, TN

Are you MySQL certified? www.mysql.com/certification
__ ___ ___ ____ __
/ |/ /_ __/ __/ __ \/ /
/ /|_/ / // /\ \/ /_/ / /__
/_/ /_/\_, /___/\___\_\___/
<___/ www.mysql.com

[Eric Braswell]

In an effort to quell this off-topic and rather pointless dialog, allow
me to refer you to the Wikipedia article on the subject:
http://en.wikipedia.org/wiki/GIF

Specifically the section:

"According to the creator of the "GIF" format, Steve Wilhite, the
pronunciation is with a soft "g" and the acronym is pronounced like the
peanut butter brand, Jif. To fellow employees of CompuServe he would
often say "Choosy developers choose GIF", spinning off of the
historically popular peanut butter commercial. This pronunciation was
also identified by CompuServe in their documentation of a graphics
display program called CompuShow. "

"GIF" is not a word, it's an acronym, therefore "precedent in English"
has no bearing.

Eric

Post by John Trammell
Way offoptic now....
How do you pronounce "gift"? :^)
$ egrep '^gif' /usr/share/dict/words
gift
gift's
gifted
gifting
gifts
To heck with the spec, all precedent in English says hard G.
Next they'll tell us to pronounce "jpeg" as "gay-peg".
-----Original Message-----
Sent: Friday, January 12, 2007 1:04 PM
To: Brian Dunning
Cc: mysql
Subject: Re: [OT} How to pronounce GIF

Post by Brian Dunning

Post by TK
In short, the original inventors of the GIF format (CompuServe,
1987) have always defined the pronunciation to be like "JIF." So,
that has always been the "correct" pronunciation.

Sure, so I'll start pronouncing "graphics" as "jraphics".

How do you pronounce "giraffe"?