title: Is there any built-in alternatives to cron in MySQL or other databases?
body: <p>It's pretty basic what I'm asking.</p>
  
  <p>Imagine a column for date in users table.</p>
  
  <pre><code>Username --- RegistrationDate ----- Authority
  user1     -  (today's date)     -   1
  user2     -  (yesterday's date) -   1
  </code></pre>
  
  <p>Each user has to be upgraded to <code>Authority = 2</code> after 10 days automatically.</p>
  
  <p>I know I can do this with PHP by executing it constantly with CRON, but what about built-in features of databases? </p>
  
  <p>Something like:</p>
  
  <pre><code>//pseudo code
  bind trigger on users.RegistrationDate, function() {
         if(RegistrationDate &gt;= RegistrationDate+10 days)
             return updateAuthority(1)
  }
  </code></pre>
  
  <p>One important thing about this is the performance. It shouldn't check for each trigger in a loop, whatever should be triggered should be triggered right on time by binding them directly on the column.</p>
  
  <p>Second important thing is, it should be exported when I take a backup of the database. I don't want to re-create them all.</p>
  
  <p>I'm not an expert about databases, but I use MySQL for this project and need a similar feature for MySQL. If it doesn't exists and I have to continue using a cron, would you please tell me if similar feature exists in Oracle/MSSQL or PostgreSQL so I can port my database? (oh, and MongoDB too, it may also be an alternative.)</p>
  
  <p>Thank you.</p>