Usually, at the end of the query running it displays the time how much it
took.
Or else enable the profiling and run the query to check the exact time it
took for execution at all levels.
On Mon, Aug 1, 2011 at 12:11 PM, Adarsh Sharma wrote:
> Dear all,
>
> I want to know how much time did it ta
Dear all,
I want to know how much time did it take to run a sample query.
In postgresql, we enable timing by \timing command.
Is there is any way to enable in Mysql
Thanks
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/my
use event scheduler.
On Mon, Aug 1, 2011 at 12:00 PM, hezjing wrote:
> Hi
>
> I want to delete the records which are older than two hours from a table.
>
> Currently, I have scheduled a cron job script to delete the records every
> one hour. I'm wondering if there is a more elegant way of doing
Hi
I want to delete the records which are older than two hours from a table.
Currently, I have scheduled a cron job script to delete the records every
one hour. I'm wondering if there is a more elegant way of doing this with
out the cron job script?
--
Hez
s.
http://www.eset.com
__ Information from ESET NOD32 Antivirus, version of virus signature
database 6339 (20110731) __
The message was checked by ESET NOD32 Antivirus.
http://www.eset.com
__ Information from ESET NOD32 Antivirus, version of virus signature
database 6339 (
Got it - thank you, I did not think about the meaning of file except as it
relates to MySQL. Re syntax - thanks.
On Sun, 31 Jul 2011, Claudio Nanni wrote:
Hi Doug,
1.FILE is GLOBAL because it refers to the ability of the user to read/write
files on the server host filesystem (where the filesy
Hi Doug,
1.FILE is GLOBAL because it refers to the ability of the user to read/write
files on the server host filesystem (where the filesystem permissions
allow).
2.
1) user@localhost OK, not recommended
2) 'user@localhost' WRONG
3) 'user'@'localhost' OK, BEST
single quotes prevent any
mysql> select day(now())-5;
+--+
| day(now())-5 |
+--+
| 26 |
+--+
2011/7/31 yavuz maslak :
>
> I don't want all records during 5 days ( 24*5days ) . Only I need records
> at 5 days ago ( for instance 24 hours on 26 th July 2011) ?
>
> How can I do t
I don't want all records during 5 days ( 24*5days ) . Only I need records
at 5 days ago ( for instance 24 hours on 26 th July 2011) ?
How can I do that ?
>Depends on how your table is set up (you're going to need a date in the
data...) but probably something along the lines of "where creat
I have both a theory question and a question on implementation of privileges.
First theory. I have been using:
grant all privileges on db-name.* to user@localhost
identified by 'password';
Because I blunder about as root I never was impacted by 'file' being a global
permission. As 'lo
Depends on how your table is set up (you're going to need a date in the
data...) but probably something along the lines of "where createDate =
date_sub(now(), interval 5 days)".
- Original Message -
> From: "yavuz maslak"
> To: mysql@lists.mysql.com
> Sent: Sunday, 31 July, 2011 11:46:1
Hi
How can I get all records exact 5 days ago from a table, neither 6 days nor
4 days ?
Could you give me an example ?
Thanks
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/mysql?unsub=arch...@jab.org
12 matches
Mail list logo
