php with mysql

I was speaking at PHP[Tek] this week on the JSON Data Type and using generated columns. JSON columns can not be indexed but data from a JSON column can be extracted via a generated column and that column can be indexed. All was going well until someone asked me about modifying data in a generated column. Was it possible? I blinked hard. I have not tried that! I had not seen any mention of that in the documentation. So I had to admit that I did not know and would have to try that. The Test mysql> CREATE TABLE gentest (a INT, b INT AS (a + 1) STORED, INDEX(b)); ... mysql> INSERT INTO gentest VALUES (1),(2),(3),(4); ... So now we have a table with data to test. So lets try to modify the value of one of the generated columns. mysql> UPDATE gentest SET b = 9 WHERE a = 1; And what did the server do? It returned an error and told me The value specified for generated column 'b' in table 'gentest' is not allowed. Lesson Learned So now I know that the server wi...

Okay, I will admit that I grew up professionally without package management. Well, we did have SSCS and RCS under Unix and a lot of very brilliant shells scripts but nothing modern programmers would deign to touch. Then came Linux Torvalds (and why hasn't he been given a Nobel prize?!?!) and I blundered into the Redhat world with their RPM package manager. RPMS are great but over time I was seduced by Ubuntu and became and became an apt-get fiend. Now I need to do a demo of the new MySQL 5.7.12 Document store features on an RPM based distro, Oracle 7.1. I could have used a Vagrant or Docker image but ended up using VirtualBox. You can even use a fresh install on hardware even though that seems to be becoming passe in a virtual & containerized world. So if you are following along please adjust to your platform. After installing the latest and greatest Virtualbox from VirtualBox.org, I pulled the ISO image from Oracle . Then I set up a virtual machine using that ISO. And no...