On Thu, 2004-04-08 at 11:15, Saqib Qureshi wrote:
> but actually i want to fatch each year record in a separate variable and in
> a single query how it is possible.
Hi,
try this :
select a2.zon, b2.astyer, count(a2.ntn),
b3.astyer, count(a3.ntn)
from ztrmtrext a2, rtnmtr b2,
Hello
please guide me
this is matter
select a.zon, b.astyer, count(a.ntn)
from ztrmtrext a, rtnmtr b
where
a.ntn = b.ntn and b.astdat is null
and astyer='2003'
group by a.zon,b.astyer
select a.zon, b.astyer, count(a.ntn)
from ztrmtrext a, rtnmtr b
where
a.ntn = b.ntn and b.astdat is
On Sun, Dec 03, 2000 at 03:14:49PM +0100 or thereabouts, Kjetil Thuen wrote:
> Rino Mardo <[EMAIL PROTECTED]> writes:
>
> > hiya. can anyone assist me in finding out what's wrong with the ff:
> >
> > mysql -uroot -e"insert into user(Host,User,Password)
> > values('localhost','guestbook',password
Rino Mardo <[EMAIL PROTECTED]> writes:
> hiya. can anyone assist me in finding out what's wrong with the ff:
>
> mysql -uroot -e"insert into user(Host,User,Password)
> values('localhost','guestbook',password('guestbook')" mysql
>
You are just missing the last ). Add another one behind the last
hiya. can anyone assist me in finding out what's wrong with the ff:
mysql -uroot -e"insert into user(Host,User,Password)
values('localhost','guestbook',password('guestbook')" mysql
that's what i type from the bash prompt and it gives me a syntax error
and the following error message:
ERROR 106
5 matches
Mail list logo
