MySQL :: Re: How to mysqldump of table with where condition for all data older than a certain epochtime value

New Topic

Re: How to mysqldump of table with where condition for all data older than a certain epochtime value

Posted by: Peter Brawley
Date: August 07, 2016 11:17AM

> --where="`EpochTime` > '1470268800975'

Again, that's a Null date. No value is greater than Null.

> WHERE: Timestamp BETWEEN '2016-06-11 09:26:01' AND '2016-08-05 09:26:01'

?! Your first Between date is later than the second. Read the manual, http://dev.mysql.com/doc/refman/5.7/en/comparison-operators.html#operator_between.

Navigate: Previous Message• Next Message

Options: Reply• Quote

Subject

Written By

Posted

How to mysqldump of table with where condition for all data older than a certain epochtime value

Dieter Schneider

August 06, 2016 06:02AM

Re: How to mysqldump of table with where condition for all data older than a certain epochtime value

Peter Brawley

August 06, 2016 11:02AM

Re: How to mysqldump of table with where condition for all data older than a certain epochtime value

Dieter Schneider

August 06, 2016 12:25PM

Re: How to mysqldump of table with where condition for all data older than a certain epochtime value

Rick James

August 06, 2016 08:15PM

Re: How to mysqldump of table with where condition for all data older than a certain epochtime value

Dieter Schneider

August 07, 2016 03:49AM

Re: How to mysqldump of table with where condition for all data older than a certain epochtime value

Peter Brawley

August 07, 2016 11:17AM

Re: How to mysqldump of table with where condition for all data older than a certain epochtime value

Dieter Schneider

August 07, 2016 01:19PM

Re: How to mysqldump of table with where condition for all data older than a certain epochtime value

Peter Brawley

August 07, 2016 01:50PM

Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.