Posts Tagged ‘views’

I’ve done the political compass loads of times over the years, but I thought it would be interesting to see how my views change over time, so I’m going to post my result here for reference.

For comparison, here is a bunch of political leaders mapped out too. Click to enlarge.

Yes, you can update views in MySQL! A lot of people seem to be under the impression that you are unable to, but this simply isn’t the case. There are a lot of restrictive rules, which can be found in the MySQL manual, but as a rule of thumb, you can update them, but only one table.

For example, lets say you have a view which links table A and table B.

You can run an update on this view, but only if you are only updating the columns from one table. So you could run a query that updates a number of columns from table A, or you could run a query which updates columns from table B – but you can’t run a query which updated columns in both table A and table B.

If you need to accomplish this, you need to use a join instead.