[thelist] MySQL newbie question - which version?

Steve Lewis slewis at macrovista.net
Tue May 21 17:45:03 CDT 2002


Peter Kaulback wrote:

> Ok I did one site with ASP and an Access database and I have had
> enough. I
> have begun to learn some SQL especially with MySQL. Which version is best
> to learn with, the later version 4's or the stable 3.23?
> Can testing with 4 on my own system be applied to the real world where
> 3.23
> is used?
>
> Peter Kaulback
>
There are huge differences between MySQL 3.23 and 4 -- I have not used 4
yet either.  If you know ASP you will probably find PHP to be an
acceptable alternative, language differences are important but you
should be able to transition those two pretty easily (as opposed to
learning PERL from and ASP background).  I would recommend you tinker
with MySQL 3.23 first.  Once you get in the habit of writting queries
without subqueries and unions and transactions and ver 4 is official,
then transition.  Using different versions of a database on live and
development environments is asking for trouble, and your SQL will get
alot better when you have to work blindfolded with one arm behind your
back! ;)  There is value in learning to drive on a Pinto when you know
you will get to upgrade to a Porche (or Subaru WRX or whatever your
flavor of auto would be).

--Steve




More information about the thelist mailing list