|
|
Posted by Duane Phillips on 08/29/06 00:54
It works basically the same as in other SQL driven databases, excepting that
it uses single quotes for instead of double.
Sample of character, numerical, and table to table link in WHERE clause:
WHERE table1.field1 = 'some parameter' AND table1.field2 = 6 AND
table1.field5 = table3.field1
With character and date fields use single quote marks around the parameter
value, and skip the single quotes for numerical arguments.
This is the basic structure, but you can do far more operators and
nestings... but it is basically SQL 92 compliant (depending on your version
of MySQL, which you did not specify).
Cheers!
~ Duane Phillips.
"jatrojoomla" <jatrojoomla@gmail.com> wrote in message
news:1156770696.026364.285250@74g2000cwt.googlegroups.com...
>I am trying to use GROUP BY cluse, what is the utility of this cluse in
> MySQL
> plz. any body tell me
>
Navigation:
[Reply to this message]
|