Tornadoes and record rainfall wreak havoc in northern Mexico and southern US