CREATE TABLE IF NOT EXISTS rec_values (
  id INT PRIMARY KEY AUTO_INCREMENT,
  rec_date
    DATETIME NOT NULL
    DEFAULT CURRENT_TIMESTAMP
         ON UPDATE CURRENT_TIMESTAMP,
  rec_value DECIMAL(3, 1)
);

INSERT INTO rec_values (rec_value) VALUES (12.3);