MySQL operations

Change a table name ALTER TABLE old_table RENAME new_table; Move a table from one database to another CREATE TABLE new_database_name.new_table_name LIKE original_database_name.original_table_name; INSERT new_database_name.new_table_name SELECT * FROM original_database_name.original_table_name; Difference between…

Continue Reading MySQL operations

Database normalization

Notes taken from Brian Green's excellent video on normalization on youtube : https://www.youtube.com/watch?v=QqlPXKxN6LQ Normalisation is a process of removing anomalies from a database. These anomalies include: insertion, update and deletion…

Continue Reading Database normalization

Getting Mercator crop of Iceland map (with known extremes of longitude and latitude)

Go to https://planet.openstreetmap.org/ and download the latest openstreetmap .pbf file. It's big so you will have to wait a while. 2) Download OSMConvert - we need this software to crop…

Continue Reading Getting Mercator crop of Iceland map (with known extremes of longitude and latitude)