2011/08/08 10:25 -0400, Jerry Schwartz
I was a reluctant convert, and still don't use Hungarian notation consistently;
but in something like MS Access, where you might want to associate a label with
a field, things like "lblCompany" and "txtCompany" make a lot of sense.
I forg
2011/08/08 00:13 -0600, Mike Diehl
Well, I can see this being useful in assembly language, or strongly-typed,
non-OO languages. But I was asking specifically about SQL!
We know from context that customers is a table and it makes no sense at all to
prefix a type to it in order to
bytesmiths.com; mysql@lists.mysql.com
>Subject: RE: Hungarian Notation [Was Re: Too many aliases]
>
>
>Jan-
>the upside is you dont have to look up a variable to know what type it is:
>zVariable is Null termed string
>bVariable is boolean
>nVariable is an Integer
>fVariable is
On Saturday 06 August 2011 10:58:43 am Jan Steinman wrote:
> > From: Johnny Withers
> >
> > http://en.wikipedia.org/wiki/Hungarian_notation
Well, I can see this being useful in assembly language, or strongly-typed,
non-OO languages. But I was asking specifically about SQL!
When will this EVER
y
Cc: mysql@lists.mysql.com
Sent: Sun Aug 07 19:03:43 2011
Subject: Re: Hungarian Notation [Was Re: Too many aliases]
I despise this sort of notation, and have instead adopted what have
cheerfully named Hungarian Suffix notation, the reason being Signal-To-Noise
ratio. Instead of prefacing everything
I despise this sort of notation, and have instead adopted what have
cheerfully named Hungarian Suffix notation, the reason being Signal-To-Noise
ratio. Instead of prefacing everything with some form of prefix, just do the
opposite:
Customer_tbl
Customer_Dead_boo
Customer_DOB_date
Customer_qs (that
..Shawshank Redemption
> Subject: Hungarian Notation [Was Re: Too many aliases]
> From: j...@bytesmiths.com
> Date: Sat, 6 Aug 2011 09:58:43 -0700
> To: mysql@lists.mysql.com
>
> > From: Johnny Withers
> >
> > http://en.wikipedia.org/wiki/Hungarian_notation
>
>
It's simple... ttwwadi is the only reason I assume.
Sent from my iPad
On Aug 5, 2011, at 2:39 PM, (Hal�sz S�ndor) h...@tbbs.net wrote:
> 2011/08/04 10:21 -0500, Johnny Withers
> http://en.wikipedia.org/wiki/Hungarian_notation
>
>
> On Thu, Aug 4, 2011 at 9:41 AM, Mike Diehl
> From: Johnny Withers
>
> http://en.wikipedia.org/wiki/Hungarian_notation
"The original Hungarian notation... was invented by Charles Simonyi... who
later became Chief Architect at Microsoft."
Ugh. That explains a lot!
The only time I let types intrude on names is with booleans, which I try
2011/08/04 10:21 -0500, Johnny Withers
http://en.wikipedia.org/wiki/Hungarian_notation
On Thu, Aug 4, 2011 at 9:41 AM, Mike Diehl wrote
> Well, while we're on the subject of SQL style, can anyone tell me why I'm
> always seeing people prefixing the name of a table with something like
>
; Sent: Thursday, August 04, 2011 8:26 AM
> > To: r...@grib.nl
> > Cc: mysql@lists.mysql.com
> > Subject: Re: Too many aliases
> >
> > >>>> 2011/08/03 12:46 +0200, Rik Wasmus >>>>
> >
> > But the
> > main thing is it helps
d.
>
> -Original Message-
> From: h...@tbbs.net [mailto:h...@tbbs.net]
> Sent: Thursday, August 04, 2011 8:26 AM
> To: r...@grib.nl
> Cc: mysql@lists.mysql.com
> Subject: Re: Too many aliases
>
> >>>> 2011/08/03 12:46 +0200, Rik Wasmus >>>>
>-Original Message-
>From: David Lerer [mailto:dle...@us.univision.com]
>Sent: Wednesday, August 03, 2011 10:25 AM
>To: mysql@lists.mysql.com
>Subject: RE: Too many aliases
>
>I rarely use aliases (unless rarely required in self-join queries).
>Yes, the column name
...@grib.nl
Cc: mysql@lists.mysql.com
Subject: Re: Too many aliases
>>>> 2011/08/03 12:46 +0200, Rik Wasmus >>>>
But the
main thing is it helps to distinguish tables in joins having the same
table
more then once (and of course results from subqueries etc.):
SELECT first.*
FROM t
2011/08/03 12:46 +0200, Rik Wasmus
But the
main thing is it helps to distinguish tables in joins having the same table
more then once (and of course results from subqueries etc.):
SELECT first.*
FROM tablename first
LEFT JOIN tablename second
ONfirst.some_id = second.some_id
On Aug 3, 2011 9:24 AM, "David Lerer" wrote:
>
> I rarely use aliases (unless rarely required in self-join queries).
> When I have that option, I create unique columns by prefixing every
> table (and its objects) with a number.
> Something like:
> Create table T1234_Employee
> (C1234_Employee_id
:47 AM
To: mysql@lists.mysql.com
Subject: Re: Too many aliases
> >>>> 2011/08/02 12:11 +0530, Adarsh Sharma >>>>
>
> select p.* from table A p, B q where p.id=q.id
>
> or
>
> select p.* from table B q , A p where q.id=p.id
> <<<<&l
> 2011/08/02 12:11 +0530, Adarsh Sharma
>
> select p.* from table A p, B q where p.id=q.id
>
> or
>
> select p.* from table B q , A p where q.id=p.id
>
> Why do people constantly change table names for queries, although, as here,
> it gain them nothing? It often makes for less
2011/08/02 12:11 +0530, Adarsh Sharma
select p.* from table A p, B q where p.id=q.id
or
select p.* from table B q , A p where q.id=p.id
Why do people constantly change table names for queries, although, as here, it
gain them nothing? It often makes for less clarity (for which
19 matches
Mail list logo