December 2024 M T W T F S S 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31
Category Archives: sql
Storing temperature data in postgresql
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
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
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
You must be logged in to post a comment.