Skip to content
Realhe.ro blog

Realhe.ro blog

Not another blog about webdesign, security and IT.

  • Home
  • Gamedev repository (mostly Phaser stuff)
  • Phaser course
    My Phaser course for absolute beginners.
  • Elementary OS
    Tips for Elementary OS users.
  • Projects
    • PHP
      • Smarty gettext with domain support (block t plugin) [depreciated]
      • Active directory support for Yii framework
    • jQuery
      • jQuery advanced filter list plugin
      • Reversed version of cycle2 plugin Scroll Vert
    • Misc
  • Contact
  • Friends
    • iBeat IT – my friend’s blog about Hyper-V and IT
    • Girls Gone Tech – About women in IT world (Polish)

Language Switcher

  • English
  • Polski

Konrad Fedorczyk

1Hi, I'm Konrad!
I spend my time mostly on coding web related stuff. I hope you'll find my articles helpful.

Adrian Ligiewicz

1Work in IT is my dream.
Acquiring engineer title is a matter of time and constant hunger for knowledge only solidifies it.
If you let me prove myself, you will not regret that.

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.

Continue reading Create SQL table for logs (with rotation)

Posted on August 21, 2018Categories Quick Tip, SQLLeave a comment on Create SQL table for logs (with rotation)
Proudly powered by WordPress