Go Back   TechArena Community > Software > Software Development
Become a Member!
Forgot your username/password?
Tags Active Topics RSS Search Mark Forums Read

Reply
 
Thread Tools Search this Thread
  #1  
Old 30-01-2009
Member
 
Join Date: Jan 2009
Posts: 16
Difference between MYSQL and MS SQL

I want to know what is the difference between MYSQL and MS SQL ? Which is best ? Max function in MS sql server supports numeric,character and datetime data types.
Reply With Quote
  #2  
Old 30-01-2009
Member
 
Join Date: Nov 2008
Posts: 29
Re: Difference between MYSQL and MS SQL

Technical - As of versions 4.x MySQL does not support views, triggers, stored procedures, user defined functions, XML, while all these are suported by MS SQL
But MS SQL is an expensive proprietory RDBMS developed & owned by Microsoft Corporation while MySql is an open source RDBMS developed & maintained by MySQL AB of sweden with free as well as paid enterprise versions available.
Reply With Quote
  #3  
Old 30-01-2009
Member
 
Join Date: Oct 2008
Posts: 20
Re: Difference between MYSQL and MS SQL

Main differences between commonly used SQL in Microsoft SQL Query

Current Date and timing
MS SQL : SELECT GETDATE()
MY SQL : SELECT NOW()
Optionally: Use CURDATE() for the date only.

Trim function
MS SQL: LTRIM() and RTRIM()
MY SQL: TRIM()

Get List of Tables
MS SQL: SP_TABLES
MY SQL: SHOW TABLES

Find database version
MS SQL: SELECT @@VERSION
MY SQL: SELECT VERSION()
Reply With Quote
Reply

  TechArena Community > Software > Software Development
Tags: ,



Thread Tools Search this Thread
Search this Thread:

Advanced Search


Similar Threads for: "Difference between MYSQL and MS SQL"
Thread Thread Starter Forum Replies Last Post
Unable to install MySQL and MySQL Workbench on Linux mint 10 Zared Windows Software 4 13-01-2011 01:08 AM
What are API in MySQL? Atsushi Software Development 3 16-12-2010 02:57 AM
mysql config file in MySQL Netorious Software Development 4 18-03-2010 09:43 PM
Mysql Error : Can't connect to local mysql server through socket ' var lib mysql mysql.sock' 2 roshan45 Software Development 3 07-11-2009 09:36 PM
MySQL with PHP Gyan Guru Guides & Tutorials 2 18-11-2008 04:53 PM


All times are GMT +5.5. The time now is 01:44 AM.