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

Regardless of existence or not, if a being is willing to wipe out an entire race just because they exercised the free will he gave them, he's not a creature I'd respect let alone worship.

Why not ask yourself, and then do the research, to answer your question? Ask:

1. Is the God of the Bible all knowing and all powerful and if so what does that mean?
2. Did the flood destroy all living creatures and how does the Bible say those creatures got there in the first place?
3. What does it mean that God regretted it and why?

Maybe the first questions you should ask yourself is how do any of us know what an all powerful etc. God can and can't do and have you ever done anything you knew you would regret but you had to do it anyway?

You know people know that people eventually die..

But i have been to more then a few Funerals and time and time again i see people break down in tears and mourn the loss of their loved one.. Now why would a person mourn the death of a family member or a loved one when they all know that every human being eventually dies.. It's been happening for thousands of generations but people still cry at funerals...

So how can someone who knows people die mourn the death of a loved one at a funeral?

That sounds like a weird question right?

I don't know he probably was heartbroken when he said that. It's not easy letting your creation be destroyed you know.

Also, by leaving Noah and his brood alive, he ensured the original sin was carried forward. If he had thought about it he would have wiped out everything and started from scratch with the benefit of hindsight.

The Job & the first 11 chapters of Genesis are the oldest parts of Scripture, proper, and so most likely to contain mythic elements.

Check out standard scholarship on this, not random videos as other users suggest.

I have a pet hypothesis, but once I post it, certain people are going to rush in to tell me I'm full of it.

I don't think the ancient Hebrews actually believed God was all-knowing. They were too smart to imagine that even a god could be perfect. Sure, he created the entire known universe, but I honestly think they viewed him as having imperfections, learning as he went along.