Hello
Can someone explain me what is the difference between mysql & sql server 2000/2005. Is mysql is the language in which we query the sql server 2000/2005 database. And if mysql is itself a database engine like sql server 2000/2005 then is their any query syntex different between mysql and SQL server 2000/2005.

And Why is always the combination of MySQL with PHP? Can we use MySQL with Asp.net (VB.net)?

Cheers
Sheraz

__________________
Cheers
Sheraz

X Post.

You asked this here and someone responded:
http://p2p.wrox.com/topic.asp?TOPIC_ID=66075

Here is a rehash and also more pointed answer:

First off, there are significant differences between SQL Server and MySQL both in keywords that are legal as well as data types. (MySQL supports both a Date data type and a Time Data type where SQL Server has only one data type for both of those, DateTime)

MySQL and PHP are normally bundled together, i assume, because they will both run flawlessly on a Linux/Apache box. A LAMP server for example is a combination of Linux Apache MySql and PHP.

MySQL can be run behind .NET, however, you should download the .NET Libs that the MySQL team developed (They work much like System.Data.SqlClient and provide optimizied code specific to MySQL) You can also use the Generic ODBC class within the .NET framework to connect to MySQL.

================================================== =========
Read this if you want to know how to get a correct reply for your question:
http://www.catb.org/~esr/faqs/smart-questions.html
================================================== =========
Technical Editor for:
Beginning Visual C# 2008
Professional Search Engine Optimization with ASP.NET
Professional IIS 7 and ASP.NET Integrated Programming
Wrox Blox: Introduction to Google Gears
Wrox Blox: Create Amazing Custom User Interfaces with WPF and .NET 3.0
================================================== =========