How to pronounce MyISAM and InnoDB

How to pronounce MyISAM and InnoDB

am 07.01.2007 16:09:15 von 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.

--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/mysql?unsub=gcdmg-mysql@m.gmane.org

Re: How to pronounce MyISAM and InnoDB

am 07.01.2007 16:16:09 von mstearne

I just say

"My, I, Sam" and "inno, d, b"

Michael


-----Original Message-----
From: "js "
Date: Mon, 8 Jan 2007 00:09:15
To:mysql@lists.mysql.com
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?unsub=mstearne@entermix.com




--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/mysql?unsub=gcdmg-mysql@m.gmane.org

Re: How to pronounce MyISAM and InnoDB

am 07.01.2007 19:15:31 von 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".


On Jan 7, 2007, at 7:16 AM, Michael Stearne wrote:

> I just say
>
> "My, I, Sam" and "inno, d, b"
>
> Michael
>
>
> -----Original Message-----
> From: "js "
> Date: Mon, 8 Jan 2007 00:09:15
> To:mysql@lists.mysql.com
> 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?
> unsub=mstearne@entermix.com
>
>
>
>
> --
> MySQL General Mailing List
> For list archives: http://lists.mysql.com/mysql
> To unsubscribe: http://lists.mysql.com/mysql?
> unsub=brian@briandunning.com
>


--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/mysql?unsub=gcdmg-mysql@m.gmane.org

Re: How to pronounce MyISAM and InnoDB

am 07.01.2007 20:25:16 von Jan Pieter Kunst

2007/1/7, 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

--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/mysql?unsub=gcdmg-mysql@m.gmane.org

[OT} How to pronounce GIF (was: Re: How to pronounce MyISAM and InnoDB)

am 08.01.2007 01:23:25 von tk

At 10:15 AM 1/7/2007 -0800, Brian Dunning wrote:
>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

>On Jan 7, 2007, at 7:16 AM, Michael Stearne wrote:
>>
>>I just say
>>
>>"My, I, Sam" and "inno, d, b"
>>
>>From: "js "
>>
>>Sorry for this silly question but I've been always had trouble
>>pronouncing "MyISAM" and InnoDB.


--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/mysql?unsub=gcdmg-mysql@m.gmane.org

Re: How to pronounce MyISAM and InnoDB

am 08.01.2007 10:38:04 von Philip Mather

Jan,
In English I pronounce them as...

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

....respectively.

Regards,
Phil
> 2007/1/7, 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
>


--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/mysql?unsub=gcdmg-mysql@m.gmane.org

Re: How to pronounce MyISAM and InnoDB

am 08.01.2007 17:36:44 von chriswhite

I'll bite..

> 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)

--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/mysql?unsub=gcdmg-mysql@m.gmane.org

Re: [OT} How to pronounce GIF (was: Re: How to pronounce MyISAM and InnoDB)

am 12.01.2007 19:49:21 von Brian Dunning

On Jan 7, 2007, at 4:23 PM, TK wrote:

> 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
To unsubscribe: http://lists.mysql.com/mysql?unsub=gcdmg-mysql@m.gmane.org

RE: [OT} How to pronounce GIF (was: Re: How to pronounce MyISAM and InnoDB)

am 12.01.2007 20:01:28 von Jerry Schwartz

.... Especially for tall ones.

Regards,

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

860.674.8796 / FAX: 860.674.8341


> -----Original Message-----
> From: Brian Dunning [mailto:brian@briandunning.com]
> 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)
>
> On Jan 7, 2007, at 4:23 PM, TK wrote:
>
> > 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
> To unsubscribe:
> http://lists.mysql.com/mysql?unsub=jschwartz@the-infoshop.co m
>
>




--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/mysql?unsub=gcdmg-mysql@m.gmane.org

Re: [OT} How to pronounce GIF

am 12.01.2007 20:04:24 von Gerald Clark

Brian Dunning wrote:
> On Jan 7, 2007, at 4:23 PM, TK wrote:
>
>> 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=gcdmg-mysql@m.gmane.org

RE: [OT} How to pronounce GIF

am 12.01.2007 20:48:07 von 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:gerald_clark@suppliersystems.com]=20
Sent: Friday, January 12, 2007 1:04 PM
To: Brian Dunning
Cc: mysql
Subject: Re: [OT} How to pronounce GIF

Brian Dunning wrote:
> On Jan 7, 2007, at 4:23 PM, TK wrote:
>=20
>> In short, the original inventors of the GIF format (CompuServe, =20
>> 1987) have always defined the pronunciation to be like "JIF." So, =20
>> that has always been the "correct" pronunciation.
>=20
>=20
> Sure, so I'll start pronouncing "graphics" as "jraphics".
>=20
>=20
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=3Djohnt@holmescorp.=
com



INFORMATION IN THIS MESSAGE, INCLUDING ANY ATTACHMENTS, IS INTENDED FOR T=
HE PERSONAL AND CONFIDENTIAL USE OF THE INTENDED RECIPIENT(S) NAMED ABOVE=
If you are not an intended recipient of this message, or an agent res=
ponsible for delivering it to an intended recipient, you are hereby notif=
ied that you have received this message in error, and that any review, di=
ssemination, distribution, or copying of this message is strictly prohibi=
ted. If you received this message in error, please notify the sender imme=
diately, delete the message, and return any hard copy print-outs. Th=
is message has been scanned for viruses by McAfee's Groupshield.

--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/mysql?unsub=3Dgcdmg-mysql@m.gmane.org

Re: [OT} How to pronounce GIF

am 12.01.2007 21:09:47 von 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


John Trammell wrote:
> 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:gerald_clark@suppliersystems.com]
> Sent: Friday, January 12, 2007 1:04 PM
> To: Brian Dunning
> Cc: mysql
> Subject: Re: [OT} How to pronounce GIF
>
> Brian Dunning wrote:
>> On Jan 7, 2007, at 4:23 PM, TK wrote:
>>
>>> 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"?


--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/mysql?unsub=gcdmg-mysql@m.gmane.org

Selecting records based on max and value

am 12.01.2007 21:09:55 von 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.
(910) 285-7200 david@safedatausa.com



--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/mysql?unsub=gcdmg-mysql@m.gmane.org

Re: Selecting records based on max and value

am 12.01.2007 21:41:44 von Peter Brawley

David,

>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=
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

-----

David Ruggles wrote:
> 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.
> (910) 285-7200 david@safedatausa.com
>
>
>
>


--
No virus found in this outgoing message.
Checked by AVG Free Edition.
Version: 7.1.410 / Virus Database: 268.16.10/624 - Release Date: 1/12/2007


--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/mysql?unsub=gcdmg-mysql@m.gmane.org

RE: Selecting records based on max and value

am 12.01.2007 21:46:29 von David Ruggles

Thanks! I'll make the column type change.

Thanks,

David Ruggles
CCNA MCSE (NT) CNA A+
Network Engineer Safe Data, Inc.
(910) 285-7200 david@safedatausa.com



-----Original Message-----
From: Peter Brawley [mailto:peter.brawley@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,

>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=
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

-----

David Ruggles wrote:
> 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.
> (910) 285-7200 david@safedatausa.com
>
>
>
>


--
No virus found in this outgoing message.
Checked by AVG Free Edition.
Version: 7.1.410 / Virus Database: 268.16.10/624 - Release Date: 1/12/2007




--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/mysql?unsub=gcdmg-mysql@m.gmane.org

Re: Selecting records based on max and value

am 13.01.2007 07:07:44 von Shawn Green

Hi David,

David Ruggles wrote:
>
> 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.
>
>
>
> David Ruggles
> CCNA MCSE (NT) CNA A+
> Network Engineer Safe Data, Inc.
> (910) 285-7200 david@safedatausa.com
>
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


--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/mysql?unsub=gcdmg-mysql@m.gmane.org

Re: [OT} How to pronounce GIF

am 19.01.2007 17:28:26 von mizioumt

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: gerald_clark@suppliersystems.com
To: brian@briandunning.com
Cc: mysql@lists.mysql.com
Sent: Fri, 12 Jan 2007 2:04 PM
Subject: Re: [OT} How to pronounce GIF

Brian Dunning wrote:
> On Jan 7, 2007, at 4:23 PM, TK wrote:
> >> 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=mizioumt@netscape.net

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


--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/mysql?unsub=gcdmg-mysql@m.gmane.org