starofframe wrote:
Thanks a lot Mike... what's a clear explanation...
You're welcome.
Actually I have used
WHERE crea_dt + interval 1 day < curdate()
before I read ur reply ...but now I guess I better change it to WHERE
crea_dt>curdate-interval 1 day
That's probably just a typo, but just in case, y
Thanks a lot Mike... what's a clear explanation...
Actually I have used
WHERE crea_dt + interval 1 day < curdate()
before I read ur reply ...but now I guess I better change it to WHERE
crea_dt>curdate-interval 1 day
again thanks a lot... and thanks to Jeff too.
Sukanto
--
MySQL General Mailing L
Jeff Smelser wrote:
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
On Monday 07 June 2004 10:03 pm, starofframe wrote:
but
delete from table where date_sub(crea_dt, interval 1 day)
Here:
http://dev.mysql.com/doc/mysql/de/Date_and_time_functions.html
I gave you the function.. You can figure out how m
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
On Monday 07 June 2004 10:03 pm, starofframe wrote:
> but
> delete from table where date_sub(crea_dt, interval 1 day) should delete all data right???
> All I want is compared to date_now
> eg : now is 2004-6-8 and all I want to delete is data t
Yes, I did found out just now...
but
delete from table where date_sub(crea_dt, interval 1 day)
To: <[EMAIL PROTECTED]>
Sent: Tuesday, June 08, 2004 9:41 AM
Subject: Re: delete record that passed > 1 day
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
On Monday 07 June 2004 09:22 pm, Jef
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
On Monday 07 June 2004 09:22 pm, Jeff Smelser wrote:
> On Monday 07 June 2004 09:25 pm, starofframe wrote:
> > Hi Jeff,
> > you mean I can use sql like this
> > DELETE FROM table where date_sub(crea_dt, interval 1 day)
>
> Add: > crea_dt
Could be
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
On Monday 07 June 2004 09:25 pm, starofframe wrote:
> Hi Jeff,
> you mean I can use sql like this
> DELETE FROM table where date_sub(crea_dt, interval 1 day)
Add: > crea_dt
- --
Anything worth fighting for is worth fighting dirty for.
Hi Jeff,
you mean I can use sql like this
DELETE FROM table where date_sub(crea_dt, interval 1 day)
thanks a lot
Sukanto
- Original Message -
From: "Jeff Smelser" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Tuesday, June 08, 2004 8:55 AM
Subject: Re: del
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
On Monday 07 June 2004 08:36 pm, starofframe wrote:
> description like this : if now()-crea_dt > 0 then delete
select date_sub(crea_dt, interval 1 day)
- --
"If you're like me, and I know *I* am..." -- Joel Robinson
-BEGIN PGP SIGNATURE---
hehe... been there...
if there isnt a way if you have logging turned on, you might be able to
find the insert and following updates statements in the log to rebuild the
row.
good luck
chris
-Original Message-
From: Arcangelo [mailto:[EMAIL PROTECTED]
Sent: Thursday, June 12, 2003 10:2
That depends, do you have a backup tape? ;)
Unfortunatly a DELETE is a one-way trip. In theory the data is still
there is the spot on the hard-drive has not been overwritten, but there
are no tools (that I know of) to retrieve that row.
Regards,
Mike Hillyer
www.vbmysql.com
-Original Message-
11 matches
Mail list logo
