|
Re: lug-bg: MySql Query
- Subject: Re: lug-bg: MySql Query
- From: Danail Petrov <oneofus@xxxxxxxxxxxxx>
- Date: Fri, 11 Feb 2005 13:39:28 +0200
Ivailo Ivanov wrote:
Privet,
Imam 2 tablici
1 tablica login|unixtime|
2 tablica login|ip|mac|
Iskam ot vtora tablica da izvadia login, ip, mac ako
MAX(UNIXTIME) za sashtia login ot parva tablica e po
malak ot 123456789. Kak tova da se napravi s edno ili
v kraen sluchai s dve querita i temporalni tablici.
__________________________________
Do you Yahoo!?
Read only the mail you want - Yahoo! Mail SpamGuard.
http://promotions.yahoo.com/new_mail
============================================================================
A mail-list of Linux Users Group - Bulgaria (bulgarian linuxers).
http://www.linux-bulgaria.org - Hosted by Internet Group Ltd. - Stara Zagora
To unsubscribe: http://www.linux-bulgaria.org/public/mail_list.html
============================================================================
select login ip from table1 where table1.login=table2.login and
table1.unixtime<123456789;
нещо такова трябва да е . Незнам дали ще сработи , пиша наизуст. Но едно
бързо query към mysql.org ще те ориентира веднага :)
Поздрави,
Данаил Петров
============================================================================
A mail-list of Linux Users Group - Bulgaria (bulgarian linuxers).
http://www.linux-bulgaria.org - Hosted by Internet Group Ltd. - Stara Zagora
To unsubscribe: http://www.linux-bulgaria.org/public/mail_list.html
============================================================================
|
|
|