Category Archives: sql

Storing temperature data in postgresql

Posted on 05.03.13 by Morten

Pushing temperaturedata from an arduino setup into a postgresql database Continue reading →

Posted in arduino, php, sql | 2 Comments

SQL – setting and resetting in one query

Posted on 16.02.11 by Morten

A colleague has a web application where a number of flags can be set or reset using checkboxses. These flags corresponds to rows in a table. When they have been altered, those who are set are returned from the browser, … Continue reading →

Posted in sql | Comments Off on SQL – setting and resetting in one query

Concatenating a utf8 char field and a datetime field in mysql

Posted on 03.02.11 by Morten

In a database of mine (using mysql 5), I needed to make a ‘fake name’ – concatenating the real name and a datetime, so I did a concat(name, ‘(‘,thetime,’)’) in the sql and got just what I expected TheName (2011.02.02 … Continue reading →

Posted in sql | Comments Off on Concatenating a utf8 char field and a datetime field in mysql