1 table named: scan
2 columns named: id, and date
I have two working queries, a SELECT and then an INSERT which I would like to merge together creating a INSERT where the condition is equal to 0.
Show '1' if the latest ID row in the database has scan date of today otherwise show '0' when no today's date is present.
SELECT COUNT(scan.date) AS datecheck FROM scan WHERE scan.id = (SELECT MAX(scan.id) AS datecheck FROM scan WHERE scan.date = CURDATE())
If there is no entry for today, meaning a results of '0' then create a new row with ID+1 and the current date.
INSERT INTO `scan`(`id`, `date`) SELECT (MAX(id)+1), CURDATE() FROM scan;
I have been trying for hours now with no luck yet, I would be grateful if you can tell me where I am going wrong and let me know what the correct query is. Thank you.