MYSQL version differences

[John]

Hi

I am totally new to MySQL. Just wanted to know what are the major
differences between version 3.23 and version 4.0.26? Also would apps written
for 4.0.26 break on 3.23?

Thanks

Regards

[Jonathan]

Re: MYSQL version differences

John wrote:[color=blue]
> Hi
>
> I am totally new to MySQL. Just wanted to know what are the major
> differences between version 3.23 and version 4.0.26? Also would apps written
> for 4.0.26 break on 3.23?
>
> Thanks
>
> Regards
>
>[/color]

I think you might start here:

http://dev.mysql.com/doc/refman/4.1/en/news-4-0-x.html

Unfortunately I have no short overview of important differences for you.

Jonathan

[Bill Karwin]

Re: MYSQL version differences

"John" <John@nospam.in fovis.co.uk> wrote in message
news:xuadnZsaD_ 4_gVneRVny1Q@pi pex.net...[color=blue]
> I am totally new to MySQL. Just wanted to know what are the major
> differences between version 3.23 and version 4.0.26?[/color]

You should read the change logs starting on this page:

http://dev.mysql.com/doc/refman/4.1/en/news.html

That is, read "D.2 Changes in release 4.0.x" for the summary, and the
sub-sections for detailed information of changes per 4.0.x point-release.
[color=blue]
> Also would apps written for 4.0.26 break on 3.23?[/color]

In most cases MySQL 4.0 is backward-compatible with 3.23 at the application
level. I have had the experience of upgrading MySQL from 3.23 to 4.0,
without requiring any changes to the Perl web application on that server.

However, no one on a newsgroup can answer that question definitively with
regard to _your_ application (or any particular application). We don't know
what your application does, or which features of MySQL it employs.

Regards,
Bill K.

[Markus Popp]

Re: MYSQL version differences

Hi,

one concrete example that comes to my mind are UNION joins - if your
application uses them, it will run with 4.0 but not with 3.23. Also InnoDB
tables are not available in 3.23's standard versions (only with Max), so if
you use InnoDB table with 4.0, they will fall back to MyISAM if you move
them to a 3.23-standard server.

Markus