Ad

How Can I Update A Record Of Specfic User From Start Date Of Moth Till The End Of That Specific Month?

- 1 answer

Database columns Image

UPDATE `agentstats` SET `total_target` = '150' from `agentstats` Where `date` BETWEEN '2022-01-01' and '2022-01-31'and`user_id` = 3
user_id is the foreign key 

This is the query i made its not working. Can any one please help me this.

Ad

Answer

You have a few syntax errors. Try this:

UPDATE `agentstats` 
SET `total_target` = '150'
Where `date` BETWEEN '2022-01-01' and '2022-01-31' and `user_id` = 3

Basically: remove from `agentstats` and add spaces before and after the and in '2022-01-31'and`user_id` = 3

Ad
source: stackoverflow.com
Ad