Posts Categorized: SQL

Mysql function to get querystring parameter of url

Posted by & filed under Code, Development, SQL, Work.

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 environment of a startup, I do not have that luxury. ┬áThis function so far works […]

EASILY Bulk Load files into a table with different columns

Posted by & filed under Code, Development, Java, SQL, Work.

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. The example then uses BULK INSERT to import the myTestSkipCol2.dat data file into this view. […]