'by' and 'near'

Picture is credited to http://ptiteouch.deviantart.com/art/letters-73769764

I opened the book, and it was page 125. I studied about by and near. What's the difference...?

In fact, by means just at the side of; something that is by you may be closer than something that is near you.

So I compared the examples:

1. We live near the sea (perhaps five kilometers away).
2. We live by the sea (we can see it).

Then I knew the meaning of a clause, "Please, stand by me, Dear."

So when a girl say it to me, she wants me not only standing near her, but standing by her instead (so she can see me always).

Oh, what a romantic statement!

So I made some sentences used by and near:

I live near Pekayon. Actually, my residence is by Metropolitan Mall (I can see the mall from my window). And near my residence, it's about 1 kilometer to the South, there's a laundry service corner that I always use. When I go to that laundry service corner, there's a porridge stall standing by the main road. I can see it from there.