Example for an ideal which is not flat (and explicit witness for this fact) 
I'm looking for an ideal $\mathfrak{a}$ of an commutative (possibly nice) ring $A$ together with an injective $A$-module homomorphism $M\hookrightarrow N$ such that the induced map $\mathfrak{a}\otimes_A M\to\mathfrak{a}\otimes_A N$ is not injective.

I want to see such a concrete example since at the moment I have a hard time understanding why it is even possible that this happens, probably because I don't have an intuition about what it means to tensorize with an ideal. Is there any good way to think about this? Or maybe the problem is that all ideals of nice rings are flat? Are there criteria for this?

First of all we are looking for an ideal $\mathfrak a$ which isn't flat. (A simple example is $\mathfrak a=(X,Y)$ in $A=K[X,Y]$.)
It would be nice if  $\mathfrak a$ contains an $A$-sequence $a,b$, that is, $a$ is a non-zero divisor on $A$ and $b$ is a non-zero divisor on $A/(a)$. (For instance, in the previous example $a=X$ and $b=Y$.)
Then take $M=N=A/(a)$, and the multiplication by $b$ which is clearly injective.
We thus have a homomorphism $\mathfrak a/a\mathfrak a\to\mathfrak a/a\mathfrak a$ which is given by the multiplication with $b$. However, the last map is not injective since $b\hat a=0$ (why?) while $\hat a\ne0$ (why?).
