MySQL Archive

  • Joining columns/ concatenate strings in Oracle PLSQL/ MySQL

    Joining columns/ concatenate strings in Oracle PLSQL/ MySQL

    Joining columns and results together is really easy in Oracle or MySQL, in both there is the same function – CONCAT(). However you should be aware that there are differences between the databases on how this function works. In MySQL the CONCAT() function works by...

    Project info

  • Google Maps API part 1: Accurate Geocoding for UK Postcodes

    Google Maps API part 1: Accurate Geocoding for UK Postcodes

    Recently I had to build a system that would take an address, pass it to google and return latitude and longitude values. The result is then stored for later use and display on Google maps. However, firstly I found that the default XML geocoding service...

    Project info

  • Creating XML from PHP/ MySQL for use with SPRY

    Creating XML from PHP/ MySQL for use with SPRY

    So lets say for example you have a table in your database and you want to return some results, pretty easy with PHP/ MySQL and I dare say easy enough with other languages. Now rather than return the results to the page and format them...

    Project info