UV unwrap spiral texture
First, unwrap your cylinder -- Edit Mode; Select all (A); Unwrap (U) -- with a cylindrical projection. Use a texture that joins the top and the bottom seamlessly.



Then select the bottom row in the UV window (B and make a rectangle) and shear it by grabbing to a side (G). 

Voilà.