While I was updating my blog recently, I read the top part of it
which said "My adventures in database developing". I realized
that I have really neglected database developing with all my
research into other programming languages.
So I was trying to play around with SQL statements to brush up on
my skills.
Luckily (or unluckily), someone at my work, a java developer,
needed to do a data export and thought that I can do it in 1 SQL
line. He said.... and I quote "You only need 1 SQL line. Whats
the problem?".
Whenever I hear the "whats the problem" line, there usually is
one.
So, with him having great confidence in my SQL-ing ability or a
complete misunderstanding of database developing, I was forced to
do the data export.
I realized early on that it would take a long time. Just to start
off, I needed like 20+ columns, but each column was a row
somewhere in 4 different tables.
…
Showing entries 1 to 1
Apr
03
2008
Showing entries 1 to 1