Not suprisingly, most google results only returned things for doing this within some kind of PHP application. Probably because nobody belives in MySQL as a data warehouse, or a place to parse strings… In the do with what you have Read More
EASILY Bulk Load files into a table with different columns
with NO FORMAT FILE! I consider this a gem just hiding on the MSDN docs : Using BULK IMPORT on a View The following example creates the v_myTestSkipCol on the myTestSkipCol table. This view skips the second table column, Col2. Read More