Re: SQL difference - mySQL and MS SQL

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: Some free utilities for Java, with Hebrew support.
    ... protocol and server and add "extensions" to make their product more ... Provided you want to remain compatible with the "stock" MySQL ... the server you were using to support something ... client libraries don't support or in changing the protocol to break ...
    (comp.lang.java.programmer)
  • Re: SQL difference - mySQL and MS SQL
    ... and didn't deviate as far from the standards as MySQL does. ... They just added support for things such as stored ... 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
    ... 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)
  • Mambo 4.0.14 Stable Bugs
    ... "into outfile" feature of MySQL. ... Because older versions don't support UNION function. ... In this case, username, md5() hashed password and email address of user ...
    (Bugtraq)
  • Re: Few Question About SSH
    ... options (eg enabling sparcv9 support on those systems) without building ... MYSQL server, i tried with pam-mysql and i changed all of pam ... completly from mysql database. ... Good judgement comes with experience. ...
    (SSH)