SQL generated columns: Add three hours to the value in the logintime to find the value of current column

Question

what SQL query do i run to make the value of login_again column always three hours added to the login_time column timestamp, i know i have to use the clause GENERATED AS somewhere with some SQL arithmetic operations, thanks guys. Am implementing Brute force attack protection for a certain web application.

Answer 1

How can this work as protection against brute force attack can you enlighten me please?

Answer 2

Database driven login control bro

Answer 3

Bro I would like to know more about how it works. If you don't mind to pass me a link or something to get started with.

I appreciate it ...

Answer 4

We database with the number of login attempts made and then we select this value and check if its greater than three if it then we redirect to a page with a login again count down

Answer 5

Alright, Thanks for the case example ...

And good luck with the solution bro! 👍

Answer 6

Thanks bro

Answer 7

The number of login attempts is echoed to javascript from php and then you use if logic to redirect to page with count down