Re: SQL difference - mySQL and MS SQL

"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
.

Relevant Pages

  • Re: SQL difference - mySQL and MS SQL
    ... They just added support for things such as stored ... why Ole mentioned the version of MySQL making a difference. ... 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 ...
    (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: SPS 2003 with SQL 2005
    ... Sharepoint Services SP2 enables support for SQL 2005. ... Microsoft SQL Server 2000 Enterprise Edition, ...
    (microsoft.public.sharepoint.portalserver)
  • 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)