Wrox Programmer Forums
Go Back   Wrox Programmer Forums > PHP/MySQL > MySQL
MySQL General discussion about the MySQL database.
Welcome to the p2p.wrox.com Forums.

You are currently viewing the MySQL section of the Wrox Programmer to Programmer discussions. This is a community of software programmers and website developers including Wrox book authors and readers. New member registration was closed in 2019. New posts were shut off and the site was archived into this static format as of October 1, 2020. If you require technical support for a Wrox book please contact http://hub.wiley.com
Old October 22nd, 2007, 05:45 PM
Authorized User
Join Date: May 2007
Posts: 73
Thanks: 4
Thanked 0 Times in 0 Posts
Default mysql and sql server 2000/2005

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)?

Old October 22nd, 2007, 06:01 PM
Wrox Author
Join Date: Oct 2005
Posts: 4,104
Thanks: 1
Thanked 64 Times in 64 Posts
Send a message via AIM to dparsons

X Post.

You asked this here and someone responded:

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:
================================================== =========
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
================================================== =========

Similar Threads
Thread Thread Starter Forum Replies Last Post
Conflict in SQL Server 2000 and SQL Server 2005 ayan.mukherjee SQL Language 0 June 30th, 2008 03:34 AM
Difference B/W sql server 2000 and 2005 bhasker_braj121 SQL Server 2005 1 January 19th, 2008 12:01 PM
Difference between mysql and sql server 2000/2005 Sheraz Khan SQL Language 1 October 22nd, 2007 12:39 PM
migrating from sql server 2000 to sql server 2005 abinashpatra SQL Server 2005 2 December 1st, 2006 03:45 PM
SQL Server 2000 and 2005 ninel SQL Server 2005 4 September 14th, 2006 01:03 PM

Powered by vBulletin®
Copyright ©2000 - 2020, Jelsoft Enterprises Ltd.
Copyright (c) 2020 John Wiley & Sons, Inc.