hi everybody
i want to take diff of datetime format columns.
Is it possible using direct '-' arithmatic..
It gives result as:
2001-11-03 15:43:47 - 2001-11-03 15:42:21 = 126
2001-11-03 16:11:50 - 2001-11-03 15:48:00 = 6350
First row is clear but i'm not getting second row's
diff.. **((63)50)**
hi
i installed mysql on redhat 7.1 .It's working fine for
localhost.
i made the user entry in mysql-user table as
'192.168.1.20','test','test','Y','.
and try to connect from 192.168.1.20(linux-system)
but it is giving error as
Error: host '192.168.1.20' is not allowed to connect
to this
hi
i want to know is there any size limit(no. of rows) for mysql created table.
In my case table contain only four cloumn
date,ip_address(varchar[20],tx_bytes(integer),rx_bytes(integer).
i want to maintain a huge database of this format.
so plz i want to know the limit of mysql database.