I did this a few years ago, not sure what insulin I was on back then, but I took my quick-acting insulin at night time instead of my long-lasting insulin. I realised after taking the whole dose, which was about 30units. Normally I'd take about 12units for a large carby evening meal, so as expected I went very hypo and needed a lot of sugar to get back to normal.
I would say that if it ever happened again, still take your long-lasting insulin, even though it will add the the initial low; without it you will be high all the next day.
Also, my boyfriend at the time had a great idea which prevented it from occuring again. As I never needed to use more that about 15 units of quick acting insulin in one go, we used a black marker pen and blacked out all the unit numbers over 15 (if i did need to use over that amount I'd have to do it in two doses). This means that if I ever picked up the pen and wound to 30, thinking it was my long lasting, I'd notice straight away I had the wrong pen.
Of course this idea would only work for people who have considerably more long-lasting insulin per dose than quick acting.