MySQL’s documentation is OK, but it’s examples are sometimes quite poor. I have a particular setup where values across two tables – a course table and a schedule table which relates to it – can be effectively “overridden”. The idea is that for any given course, one can set “default” values, and then these can… Read more »
Posts Tagged: mysql
Performing Operations on MySQL Data While Copying between Tables
I had the need to copy a load of data from one table to another while incrementing (or just adding an arbitrary number to) some numeric indices. Before I lept to a programming language like PHP to do a load of selects, manipulate the data and then run inserts I thought I’d try and do… Read more »