Update field on daily basis with MySQL and PHP

Question

I have a database in which I have record of patients, for example id, name, time, date, regularity, etc. Now I want to add a new field medical-record-number, I mean another integer field and auto-increment it on daily basis. I use MySQL and PHP. Thanks in advance.

Answer 1

try this

   $sql = "ALTER TABLE `patient` ADD `medical-record-number` int(10) AUTO_INCREMENT";
    mysqli_query($sql);