Topic: If there is in basis of correspondence that to return 0 if there is no that to fulfill request.
Hello, at once I will tell that I am not strong in MySql and if something turns out that only a trial and error method, therefore I write here . at all I do not know from what side to approach.
In basis there are 3 columns ip (PRIMARY VARCHAR), time (INT), name (VARCHAR)
I need to make one request check and request if check transited.
If in basis is ip (192.168.0.1) and time> = it is necessary to return 1502324324 that 0 (to inform the program) if the condition did not transit check that it is necessary to change time = 15 and name - ' Kohl '.
And if allow 2 problem:
If in basis is ip (192.168.0.1) and time <1502324324 that it is necessary to delete this record from the table.
Very much I calculate for the specific help in an example and it is desirable with the explanation. Thanks.