7 messages in com.mysql.lists.win32Re: MYSQL vs Microsoft SQL| From | Sent On | Attachments |
|---|---|---|
| Ng Huay Ping | 20 Feb 2001 21:34 | |
| Joris Lambrecht | 21 Feb 2001 00:15 | |
| Deives Michellis | 21 Feb 2001 03:48 | |
| Joris Lambrecht | 21 Feb 2001 05:18 | |
| Deives Michellis | 21 Feb 2001 05:58 | |
| Joris Lambrecht | 21 Feb 2001 06:30 | |
| Stefan Schmiedl | 21 Feb 2001 06:48 |
| Subject: | Re: MYSQL vs Microsoft SQL |
|---|---|
| From: | Deives Michellis (dmic...@uol.com.br) |
| Date: | 02/21/2001 03:48:40 AM |
| List: | com.mysql.lists.win32 |
The first (and bigger) diference is in the Price... :-) Some thousands of dollars to MS SQL Server...
There are others diferences... MySQL crash or freeze over 30 simultaneous connections (I know just about shareware version), MySQL does not support Commit, Rollback, and general SQL Transactions, and does not support Subqueries like this: mysql> SELECT * FROM table WHERE id IN (SELECT id FROM table2);
All of this "missing" in MySQL are documented in their own manuals.
MySQL is a good and popular data base manager, one of the best on my opinion. MS SQL Server is very good too, and if you need some of that above, you may change your data base manager, OR change your source code to work without this facilities.
The standard query language is also the same for all data base (MySQL, MS SQL, Oracle, Informix, etc etc etc), but all of them make "enhanchements" in the SQL. You most study your database manager to learn more about...
----- Original Message ----- From: "Ng Huay Ping" <hp...@mpmsb.com> To: <win...@lists.mysql.com> Sent: Wednesday, February 21, 2001 2:34 AM Subject: MYSQL vs Microsoft SQL
hai;
Did anybody can tell me ,what is the different between MYSQL and Microsoft SQL ??
their query language same?? the way they connect to PERL same??