title: How to track changes to a boolean column in a MySQL database?
body: <p>My application serves customers which are online stores. One of the tables in my DB is "Product" and it has a column "In_Stock". This is a boolean (bit(1)) column. My customers send data feeds of their product catalog and each customer has their own version of this table. I would like to track changes to this In Stock column, something to the effect of...</p>
  
  <pre><code> 11/13/2016  true
   12/26/2016  false
   01/07/2017  true
  </code></pre>
  
  <p>Just so that when I do some auditing, I can see for a given time period what was the state of a given product.</p>
  
  <p>How best can I do this?</p>
  
  <p>It seems overkill to create a separate history table and have it updated by a trigger just for one boolean column.  Would a history column suffice? I can save the data there in some kind of JSON string.</p>