Hello All,
Thanks for the all info !! I've done my query like this:
SELECT id,SUBSTRING(FROM_UNIXTIME(unixtime),1,10) as
unixtime,ip,porta_snmp,porta_switch,ip_cliente,mac_cliente from teste group
by unixtime,porta_switch,porta_snmp;
I've used SUBSTRING to get rid of the time from my unixtime...
Hi All,
I need to sort some data from a MySQL table. I have data saved like this:
++-++--+
| id | unixtime| porta_snmp | porta_switch |
++-++--+
| 1 | 2003-01-07 12:23:24 | 1614 | 1
Thank you all for the Tip ! It work´s fine now !! :)
Gus
- Original Message -
From: <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Cc: <[EMAIL PROTECTED]>
Sent: Wednesday, March 20, 2002 10:32 AM
Subject: Re: [PHP-DB] order by problem
> On Wed, 20 Mar 2002 [EMAIL PROTECTED] wrote:
>
> Y
Hello All,
I´m having a 'problem' that I dont know how to resolve. The problem is:
I have a table that I want to get the last number to increment. To do this I
want to sort the filed 'ctrlnumber'. Using this query´s I get:
mysql> SELECT ctrlnumber FROM table WHERE id=14;
++
| ctrlnum