How can someone who is all knowing and all powerful do something that they'd later regret?

In the bible it said God regretted making humans and wanted to flood the earth to destroy all living creatures. That's confusing to me because how could a perfect and all knowing being do something that they'd later regret?