Category: SQL

  • Create SQL table for logs (with rotation)

    Create SQL table for logs (with rotation)

    I needed a very simple SQL table with application log. After sometime I’ve realized that it already has 80 MB of data (sic!). What can you do with logs? Well, answer is simple! Use rotation. Below you can find quick SQL solution for removing old entries.