MySQL question

[abc123ben]

Well, I really haven't started learning PHP & MySQL until now. Fortunately, I have the book PHP 5, but with it, MySQL 4 - and the latest release is 5. I am wondering, does SQL syntax change? For instance, when a new version of MySQL, like v4 to v5, does the SQL syntax change? Or does SQL syntax stay the same, but the database of MySQL is a new version. Any help appreciated.

 

[monty]

As far as I know, the SQL syntax remains the same. This also makes kind off sence since SQL is not developed by MySQL, it's just a language for performing queries on a database.

The things that change over versions are functionality, stability, security, etc.

 

[ZannuZZi]

Hello. As far as I know new MySQL 5x works with delays for younger MSQL scripts. But I don't know why?

 

[abc123ben]

Okay, thanks for your help .

 

[Peter]

syntax can change especially if you jump to a new major version as mySQL has done.

It is true mySQL do not write the specification for SQL but like all database engines they implement it in wildly different ways. If this were not the case all software would work with all databases and this is quite clearly not the case.

As well as the possibility of syntax changing there is also the possibility of any functions/features you may wish to use being dropped (of course many features also get added)