Software development, photography, jokes, ....

Sites by me

 
tas-logoTransportation Administration System
snoezelkussen-logo-kleinstSnoezelen Pillows for Dementia
ikzoekeenbegeleider-logoBegeleiders voor gehandicapten
Laat uw hond het jaarlijkse vuurwerk overwinnen
Betuweroute en Kunst
logo 50x50Hey Vos! Je eigen naam@vos.net emailadres?
Kunst in huis? Nicole Karrèr maakt echt bijzonder mooie dingen
nettylogo2Kunst in huis? Netty Franssen maakt ook bijzonder mooie dingen
Professionele opvang bij Gastouderbureau
Kind-Zijn
Salarisadministratie en belastingadvies bij
De Zaak Loont
Zutphense Bomenstichting

Hosting Favorites

 
ANU Internet Services
XelMedia .internet services
register.com
GoDaddy.com

Blogroll

 
Bomenstichting
MacFreak
Google Translate
PHP
MySQL
jQuery
jQuery UI
codecademy
YourHead Stacks API
Favicon Generator. For real.
Check HTTPS problems



Categories

Archives
 Dec 2019 (1)
 Nov 2019 (1)
 Oct 2019 (2)
 Aug 2019 (2)
 Jun 2019 (2)
 May 2019 (2)
 Apr 2019 (5)
 Feb 2019 (6)
 Dec 2018 (2)
 Nov 2018 (1)
 Oct 2018 (1)
 Sep 2018 (5)
 Aug 2018 (1)
 Jul 2018 (6)
 Jun 2018 (4)
 May 2018 (2)
 Apr 2018 (3)
 Mar 2018 (10)
 Feb 2018 (8)
 Jan 2018 (2)
 Dec 2017 (3)
 Nov 2017 (4)
 Oct 2017 (3)
 Sep 2017 (2)
 Aug 2017 (2)
 Jul 2017 (1)
 Jun 2017 (2)
 May 2017 (4)
 Apr 2017 (4)
 Mar 2017 (2)
 Feb 2017 (2)
 Jan 2017 (5)
 Dec 2016 (5)
 Nov 2016 (5)
 Oct 2016 (2)
 Sep 2016 (4)
 Aug 2016 (2)
 Jul 2016 (4)
 Jun 2016 (2)
 May 2016 (3)
 Apr 2016 (6)
 Mar 2016 (3)
 Feb 2016 (1)
 Jan 2016 (3)
 Dec 2015 (3)
 Nov 2015 (4)
 Oct 2015 (4)
 Sep 2015 (3)
 Aug 2015 (3)
 Jul 2015 (1)
 Jun 2015 (1)
 May 2015 (3)
 Apr 2015 (2)
 Feb 2015 (3)
 Jan 2015 (3)
 Dec 2014 (4)
 Nov 2014 (2)
 Oct 2014 (5)
 Sep 2014 (4)
 Aug 2014 (5)
 Jul 2014 (2)
 Jun 2014 (2)
 May 2014 (5)
 Apr 2014 (2)
 Feb 2014 (1)
 Jan 2014 (2)
 Dec 2013 (2)
 Nov 2013 (3)
 Oct 2013 (3)
 Sep 2013 (2)
 Aug 2013 (1)
 Jul 2013 (3)
 Jun 2013 (2)
 May 2013 (3)
 Apr 2013 (3)
 Mar 2013 (6)
 Feb 2013 (3)
 Jan 2013 (4)
 Dec 2012 (5)
 Nov 2012 (3)
 Oct 2012 (3)
 Sep 2012 (6)
 Aug 2012 (4)
 Jun 2012 (5)
 May 2012 (7)
 Apr 2012 (4)
 Mar 2012 (1)
 Feb 2012 (5)
 Jan 2012 (5)
 Dec 2011 (5)
 Nov 2011 (7)
 Oct 2011 (4)
 Sep 2011 (6)
 Aug 2011 (3)
 Jul 2011 (7)
 Jun 2011 (9)
 May 2011 (3)
 Apr 2011 (8)
 Mar 2011 (7)
 Feb 2011 (2)
 Jan 2011 (3)
 Dec 2010 (6)
 Nov 2010 (10)
 Oct 2010 (4)
 Sep 2010 (3)
 Aug 2010 (10)
 Jul 2010 (10)
 Jun 2010 (1)
 May 2010 (1)
 Apr 2010 (2)
 Mar 2010 (2)
 Feb 2010 (5)
 Jan 2010 (1)
 Dec 2009 (6)
 Nov 2009 (6)
 Oct 2009 (4)
 Sep 2009 (2)
 Jul 2009 (1)

Marc's Place


 

Powered by the Blogspot.stack

Foto: Night Train Impression

 Permalink
Night Train Impression

Night Train Impression


While waiting for my train to come, I suddenly felt like taking this picture - it was all about the combination of people, the (or no) interaction, etc..
After that I used some apps on the iPhone to get the desired effect to abstract the situation and leave more to the imagination.
 Comments

Casal dos Jordões - Finest Reserve Port

 Permalink
Looking for a superb, organic port wine? I really can recommend this one! More about this company, which wins medal after medal since moving to organic growing of plants in 1994.

casal-dos-jordoes-finest-reserve-port
 Comments

Foto: Dinner in a hotel room

 Permalink
Dinner in a hotel room

Dinner in a hotel room

 Comments

MySQL: Split a comma-separated list and insert result into table

 Permalink
Looking for a SPLIT-function in MySQL, I came across this one. I tried it and I must have have done something not right, because MySQL threw an error at the function. I am not a MySQL guru and since this is a one time Q&D conversion-action, I only took the SUBSTRING code and created a query with which one can split the contents of an old field into separate columns and directly insert the results into a new, normalized table.

My example is about a TEXT-column I want to get rid of and of which I want to transfer the contents to a separate table. This column contains email addresses separated by a comma. Thus, first, I had to find the maximum number of email addresses used in that column, so I found this query and added MAX() around it.

select max(length(emails) - length(replace(emails, ',', ''))) as occurrences
from old_table
where emails<>''


With that number, I created that number+1 of unions, so I would end up with all email addresses in one column. That select statement is then used in a left join to retrieve the corresponding user name and feed the results at the same time into a new table, which uses an ID and a USER-ID, instead of an email address:

insert into new_table
select idnr, user
from (
  select idnr,
  trim(substring(substring_index(emails, ',', 1), char_length(substring_index(emails, ',', 1 -1)) + 1)) as email
  from old_table
  where emails<>''

  union

  select idnr,
  trim(substring(substring_index(emails, ',', 2), char_length(substring_index(emails, ',', 2 -1)) + 2)) as email
  from old_table
  where emails<>''

  union

  select idnr,
  trim(substring(substring_index(emails, ',', 3), char_length(substring_index(emails, ',', 3 -1)) + 2)) as email
  from old_table
  where emails<>''

  union

  select idnr,
  trim(substring(substring_index(emails, ',', 4), char_length(substring_index(emails, ',', 4 -1)) + 2)) as email
  from old_table
  where emails<>''
) as x
join users u on (u.email1=x.email or u.email2=x.email)
where x.email<>''


Now that I have all used email address associated with the IDs of the original rows, I can now delete the old column and change all my LIKE-queries into LEFT JOINs. Much better, because email addresses change.
 
 Comments

Foto: Deer on Dune-top near Zandvoort

 Permalink
Deer on a dune-top

Deer on a dune-top

 Comments
© 1997- Marc Vos (and others)   -   Privacy Statement   -    Contact Me