Re: SQL difference - mySQL and MS SQL

Also, in my experience, MS SQL is more "mature" - in every sense of the word, including
support...!

Thanks, Sue!!!

Vic


"Sue Hoegemeier" <Sue_H@xxxxxxxxxxxxx> wrote in message
news:5j6vd2h01e5eqp0kce8ajvatj52ecb4rk4@xxxxxxxxxx
Correct. The Lacking and No Support references apply to
MySQL.
MySQL is pretty far behind most of the other database
vendors. They just added support for things such as stored
procedures, triggers, distributed transactions - which is
why Ole mentioned the version of MySQL making a difference.
So if you have a book for MySQL 4.x or earlier, you won't
have any documentation on syntax and usage of triggers and
stored procedures.

-Sue

On Sun, 13 Aug 2006 16:38:09 -0400, "Victor" <vic@xxxxxxx>
wrote:


"Ole Kristian Bangås" <olekristian.bangas@xxxxxxxxxxxxxx> wrote in message
news:Xns981E29682647olekristianbangaas@xxxxxxxxxxxxxxxx
"Victor" <vic@xxxxxxx> wrote in
news:uZDbV$lvGHA.3936@xxxxxxxxxxxxxxxxxxxx:

I just bought a book that I thought was about the SQL query language.
Turns out it's really about mySQL. Uh.

What is the difference between query language for mySQL and MS SQL? Is
there a good reference?

I have never seen such a reference, and it highly depends on the version
of Micrsoft SQL Server and more importantly the verison of MySQL. MySQL
version 4 is nowhere near Microsoft SQL Server (in any version I've
seen). MySQL version 5 is starting to fill the gap, but it's still huge.

Most basic SQL syntax is the same in MySQL and Microsoft SQL Server, but
there are so many differences that I would suggest a book about
Transact-SQL (the dialect that Microsoft SQL Server uses).

Some differences (depending on version of MySQL and database engine
used)
* Lacking support for subqueries
* Lacking support for referential integrity
* Using LIMIT inetead of TOP (actually I hope this comes into the SQL
syntax, and even better that Microsoft SQL Server will support it)
* Lacking support for userdefined functions/stored procedures
* MySQL supports date and time datatypes, whereas Microsoft SQL Server
only have datetime
* No support for computed columns
* No support for triggers

And when we take SQL Server 2005 into consideration:
* No support for managed code
* No support for XML
* No support for Common Table Expressions

Well, there are so many differences, I've just mentiones some here. In
my opinion MySQL is far from a mature product.

--
Ole Kristian Bangås
MCT, MCDBA, MCDST, MCSE:Security, MCSE:Messaging, MCTS, MCITP

When you write "differences", you are saying that this is what ***mySQL*** is
LACKING,
correct?





.

Relevant Pages

  • Re: SQL difference - mySQL and MS SQL
    ... MySQL is pretty far behind most of the other database ... They just added support for things such as stored ... I have never seen such a reference, and it highly depends on the version ... version 4 is nowhere near Microsoft SQL Server (in any version I've ...
    (microsoft.public.sqlserver.connect)
  • Re: SQL difference - mySQL and MS SQL
    ... What is the difference between query language for mySQL and MS SQL? ... version 4 is nowhere near Microsoft SQL Server (in any version I've ... Lacking support for referential integrity ...
    (microsoft.public.sqlserver.connect)
  • Re: SQL difference - mySQL and MS SQL
    ... What is the difference between query language for mySQL and MS SQL? ... version 4 is nowhere near Microsoft SQL Server (in any version I've ... Lacking support for referential integrity ...
    (microsoft.public.sqlserver.connect)
  • Re: Problem with Set MyRst = MyDB.OpenRecordset(PString, dbOpenForwardOnly)
    ... but I've already verified that the SQL ... MySQL = MySQL & "FROM tblVehicleJobs INNER JOIN tblAddnlOwnrs ON ... vbNewLine ... MySQL = MySQL & "FROM tblVehicleJobs INNER JOIN tblLienHolders ON ...
    (comp.databases.ms-access)
  • Re: looking for way to include many times some .py code from anotherpython code
    ... data is read from mysql and presented ... > The underlaying data at some time point go into sql tables. ... > it into xml and present on web/. ... > I don't want to invent the database schema in bsddb in python. ...
    (comp.lang.python)