SQL 4.0
Posted by: Kim Sample (---.sta.sprint-hsd.net)
Date: February 25, 2006 07:37PM

I realize that this comes with 5.0, but so many programs are not compatible with this version, that I really need to use mysql 4. Is it possible to uninstall 5 and install and use 4.

Help would be greatly appreciated.

Options: ReplyQuote
Re: SQL 4.0
Posted by: CyberSpatium (---.hsd1.or.comcast.net)
Date: February 26, 2006 10:33AM

are you refering to not wanting to use the latest verion of mysql, MySQLi? With MySQL v5 you can use both MySQL and MySQLi in your scripts.



If you where not talking about this, what did you mean then?

Options: ReplyQuote
Re: SQL 4.0
Posted by: Kim Sample (---.sta.sprint-hsd.net)
Date: February 26, 2006 02:26PM

Here is what I'm running into with one of my programs....

I believe the problem is resulting from this:


"Incompatible change: Beginning with MySQL 5.0.12, natural joins and joins
with USING, including outer join variants, are processed according to the
SQL:2003 standard. The changes include elimination of redundant output
columns for NATURAL joins and joins specified with a USING clause and proper
ordering of output columns. The precedence of the comma operator also now is
lower compared to JOIN.

These changes make MySQL more compliant with standard SQL. However, they can
result in different output columns for some joins. Also, some queries that
appeared to work correctly prior to 5.0.12 must be rewritten to comply with
the standard. For details about the scope of the changes and examples that
show what query rewrites are necessary, see Section, "JOIN

That is why I wanted to use 4.x

Options: ReplyQuote
Re: SQL 4.0
Posted by: nabab (83.141.121.---)
Date: March 01, 2006 05:06AM

I have the same problem, can anybody help to replace MySQL5.x by 4.1x plz without downgrading to a previous WAMP version (with either Apache1x or PHP4.x)??

Options: ReplyQuote
Re: SQL 4.0
Posted by: ooh456 (---.telia.com)
Date: March 03, 2006 09:21AM

I agree.

I think it's a rather common setup nowadays on web hosts to use PHP5 and MySQL 4. At least that's what all my web hosts do. Using WAMP as a dev server with MySQL5 and a production server of MySQL4 is causing me headaches, Does anyone know a clean way to downgrade MySQL 5 to the latest version of MySQL 4?

If not I'm afraid I will have to abandon the otherwise pretty cool Wampserver for a while until my web host upgrades.

Thanks for any suggestions.

Options: ReplyQuote
Re: SQL 4.0
Posted by: Kim Sample (---.sta.sprint-hsd.net)
Date: March 03, 2006 02:01PM

In reponse to this...
Here is what I did and it is working fine.

I' m using version 1.4.4 of wamp with the perl addon which comes with these versions.

Apache version : Apache/1.3.33 (Win32)
PHP version : 5.0.4
MySQL version : 4.1.10a-nt - extension : mysqli

It is still below my server, but it transfers over without any problem.
I suggest trying that.

I spent hours looking for something that was just as nice to use, easy to setup and believe them there isn't anything out there, so use this version and you will be pleased.

Hope this helps.

Kim Sample

Options: ReplyQuote

Sorry, only registered users may post in this forum.