Yahoo Answers is shutting down on May 4th, 2021 (Eastern Time) and beginning April 20th, 2021 (Eastern Time) the Yahoo Answers website will be in read-only mode. There will be no changes to other Yahoo properties or services, or your Yahoo account. You can find more information about the Yahoo Answers shutdown and how to download your data on this help page.

Lv 2666 points

grey580

Favorite Answers36%
Answers33

  • Mysql query help - no entries in the past 6 months?

    I have a log table with the following structure.

    +---------+---------------------+

    | app_id | date |

    +---------+---------------------+

    | 1115502 | 2008-01-29 22:14:04 |

    | 1115502 | 2008-01-29 22:13:47 |

    | 1110529 | 2008-01-29 22:08:36 |

    | 1115560 | 2008-01-29 21:01:40 |

    | 1115560 | 2008-01-29 21:01:24 |

    | 1115560 | 2008-01-29 20:51:02 |

    | 1115842 | 2008-01-29 20:50:09 |

    | 1115560 | 2008-01-29 20:49:47 |

    | 1115560 | 2008-01-29 20:49:17 |

    | 1115560 | 2008-01-29 20:48:44 |

    +---------+---------------------+

    A entry is made in the dbase every time someone touches an app.

    I'm trying to figure out a query will show me all applications that haven't had any entries in the past 6 months.

    Currently my query mixes in entries with that of history log entries less than 6 months if there is also an entry that is older than 6 months. I need to figure out how not to display those at all.

    Any help will be appreciated.

    2 AnswersProgramming & Design1 decade ago

  • Mysql query help - no entries in the past 6 months?

    I have a log table with the following structure.

    +---------+---------------------+

    | app_id | date |

    +---------+---------------------+

    | 1115502 | 2008-01-29 22:14:04 |

    | 1115502 | 2008-01-29 22:13:47 |

    | 1110529 | 2008-01-29 22:08:36 |

    | 1115560 | 2008-01-29 21:01:40 |

    | 1115560 | 2008-01-29 21:01:24 |

    | 1115560 | 2008-01-29 20:51:02 |

    | 1115842 | 2008-01-29 20:50:09 |

    | 1115560 | 2008-01-29 20:49:47 |

    | 1115560 | 2008-01-29 20:49:17 |

    | 1115560 | 2008-01-29 20:48:44 |

    +---------+---------------------+

    A entry is made in the dbase every time someone touches an app.

    I'm trying to figure out a query will show me all applications that haven't had any entries in the past 6 months.

    Currently my query mixes in entries with that of history log entries less than 6 months if there is also an entry that is older than 6 months. I need to figure out how not to display those at all.

    Any help will be appreciated.

    2 AnswersProgramming & Design1 decade ago