Mysql – SQL separate units and decimals from price
I have price column in MySQL contains this values : price 1020.2200 202.0000 0.5000 820.6700 I want to split at the floating point. Here is what I'm trying to get : price p_units p_decimals 1020.2200 1020 22 202.0000 202 00…