Not much happening at the moment. Done much more schoolwork recently than I had been doing. Computing in particular.<\/p>\n
I’ve had to get round the fact that mySQL doesn’t support subqueries until version 4.1 which is still in alpha release and mchicago<\/a> thinks its a bad idea to install that on tralk. I wanted to do something like:<\/p>\n but I can’t, so I now have a piece of PHP code which puts the results of the first part of the query into an array and loops through that array, creating a new query based on each result to do the sub part of the query on. (that made sense before it came out of my head). Well anyway, I think it’s messy.<\/p>\n Then there’s the fact that I can’t use INTERVAL with a TIME type, only DATETIME types. so instead of doing:<\/p>\n I have to do:<\/p>\n which is horridible. I haven’t even started on figuring out whether or not the bus travels on the right day…<\/p>\n I complain about these things, but I’m actually really enjoying the programming. I hadn’t realised how long it is since I’ve done any proper programming I’ve been spending so much time learning how to use Linux.<\/p>\n DT on the other hand is causing me headaches. My project is lacking direction quite terminally at the moment and I’m a bit fed up with it. I’m definately making progress in maths but no where near enough progress to get a B at the end of the year \ud83d\ude41 – yet.<\/p>\n lauperr<\/a> is up and down like a yoyo, I really hope she doesn’t quit school. I wish she had a bit more confidence in herself because she’s such a great person with lots of talents.<\/p>\n We had a disco in the IT room in our Computing Lesson\/break time as Mr M was away. It involved much dancing to music thanks to djkoa<\/a> and dognuts and cookies thanks to lauperr<\/a> and was hilarious.<\/p>\n wonchop<\/a> has made a new animation, eels on wheels which I love (here<\/a>) which reminds me, I still haven’t got a flash plugin for Mozilla Firebird.<\/p>\n I think I have my first stats lesson with a lower sixth group tomorrow which will be fun :S<\/p>\n Night night.<\/p>\n","protected":false},"excerpt":{"rendered":" Not much happening at the moment. Done much more schoolwork recently than I had been doing. Computing in particular. I’ve had to get round the fact that mySQL doesn’t support subqueries until version 4.1 which is still in alpha release and mchicago thinks its a bad idea to install that on tralk. I wanted to … Continue reading SQL blues<\/span><\/a><\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[1],"tags":[],"class_list":["post-122","post","type-post","status-publish","format-standard","hentry","category-uncategorized"],"_links":{"self":[{"href":"https:\/\/tola.me.uk\/blog\/wp-json\/wp\/v2\/posts\/122","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/tola.me.uk\/blog\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/tola.me.uk\/blog\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/tola.me.uk\/blog\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/tola.me.uk\/blog\/wp-json\/wp\/v2\/comments?post=122"}],"version-history":[{"count":0,"href":"https:\/\/tola.me.uk\/blog\/wp-json\/wp\/v2\/posts\/122\/revisions"}],"wp:attachment":[{"href":"https:\/\/tola.me.uk\/blog\/wp-json\/wp\/v2\/media?parent=122"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/tola.me.uk\/blog\/wp-json\/wp\/v2\/categories?post=122"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/tola.me.uk\/blog\/wp-json\/wp\/v2\/tags?post=122"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}SELECT * FROM RunStop a WHERE stopid=4 AND EXISTS (SELECT 1 FROM RunStop b WHERE b.runid=a.runid and b.stopid=23 AND a.id <> b.id);<\/code><\/p>\nSELECT * FROM `RunStop` WHERE time BETWEEN ('07:30:00' - INTERVAL 1 HOUR) AND ('07:30:30' + INTERVAL 1 HOUR)<\/code><\/p>\nSELECT * FROM `RunStop` WHERE (TIME_TO_SEC(time) - TIME_TO_SEC('07:30:00')) <= 3600 AND (TIME_TO_SEC(time) - TIME_TO_SEC('07:30:00')) >= -3600<\/code><\/p>\n