Which should I use - MySQL 3.2.3 or MySQL 4?

bunner_bob

Most of my clients' sites are on servers (not under my control) running MySQL 3.2.3 (roughly). I'm in the process of doing a new install of MySQL and see that version 4 is solid now. I'm wondering if I'll have any problems using 4 on my development machine, then moving the sites over to servers running 3. Most of my MySQL queries are pretty straightforward - Insert, Update, Select, Delete, plus use of indexes in searches.

What'ya think?

LordShryku

Use what the clients use. It's safer. 4 implements things like subqueries, so if you happen to write one in development, then move it to production on 3, it'll bomb.

It's always best to try to duplicate the production enviroments as much as possible. This includes OS, MySQL, Apache, PHP, etc. All versions. Gives the most accurate test enviroment possible. Now if you were looking to upgrade the clients, that would be a different story....

bunner_bob

Ahh silly impatient me - I went ahead and installed 4. So now I'll have to learn the differences, which is a good thing I suppose.

Thanks!

LordShryku

Well, careful then. A lot of the functions are new, and the MySQL manual is written for th newest production release. Though, most newer functions will say "Since version 4, blah blah blah is available...."