MySQL Double Equal Sign

Question

I am debugging an old website and I am getting some SQL errors. When I went through it, I found the following query.

UPDATE boats set new_high_date == DATE_ADD(NOW(), INTERVAL 3 MONTH) WHERE id=49701 

I do not know what == means. Is this a valid request? I can’t execute it.

I'm not sure if I should change this, or does it mean something?

Answer 1

There is no double value in MySQL, so you must remove it.

Answer 2

This is not true, in sql there is no double equal sign. The correct installation method is

 UPDATE boats SET new_high_date = DATE_ADD(NOW(), INTERVAL 3 MONTH) WHERE id = 49701 

Answer 3

Blindly, you can delete them because MYSQL does not have ==