Actually, a better word might be different. Lacking implies it did not have when I mean it did not do it the way I understood. But the biggest issue for me was the transactions (of course that tells you I was not at first using inno) and then there were all the extensions.

i.e. Data type
long, medium, and tiny text and many more

Joins along with group by work different. Of course that's true for Postgres and others.

Lack of views, cursors, etc..

And plenty of other little but very important items like max_rows, delay_key_write, etc...


But to be honest MySQL was the first database I used to expand my VFP programs. I quickly found many things as not my cup of tea. I enjoyed MsSQL much more and others. About that time I got a small job using Oracle and had my eyes opened even more with the different syntax and features. So now I try to stay with Postgres. Postgres is very close to Oracle and still has much of the syntax of MsSQL without the locking issues.

John