How to copy row with some specific values using event in mysql?

See more:

PHP

MySQL

event

I want to copy userId = 10 yesterday's record and duplicate it but with today's date, that should be stored in "dateM" column. Overall this whole event is not working. I have tried many other ways but no use.

What I have tried:

 CREATE EVENT test_user_10
  ON SCHEDULE
       EVERY 1 DAY
    STARTS '2016-11-28 19:20:00' ON COMPLETION PRESERVE ENABLE 
  DO

INSERT INTO measurement 

(userId,height,age,weightEnter,weight,chestSkin) 

SELECT 
(userId,height,age,weightEnter,weight,chestSkin)

FROM measurement WHERE userId = 10 AND date(dateM)=(CURDATE()-1);