SQL Server & MySQL?

Discussion in 'Databases' started by sanchyclub, Feb 22, 2011.

  1. #1
    hey mate,

    basically I am a web developer but I can develop a database because I have knowledge on MS. Access, Visual Basic and SQL Server 2000.

    I know MySQL is very popular at this moment. So I need to know what is the differences in between SQL Server and MySQL.

    I already tried to find some useful information from google but still have lots of confusion.

    Can you tell me something about MySQL?

    Thanks,
     
    sanchyclub, Feb 22, 2011 IP
  2. AstarothSolutions

    AstarothSolutions Peon

    Messages:
    2,680
    Likes Received:
    77
    Best Answers:
    0
    Trophy Points:
    0
    #2
    MySQL is simply another RDMS and like all of them it has a little bit of unique elements in terms of its advanced SQL and syntax for stored procedures etc.

    3w School has examples in MSSQL, MySQL and Oracle as a starter for 10 of the differences in terms of language http://www.w3schools.com/sql/default.asp
     
    AstarothSolutions, Feb 23, 2011 IP
  3. leva86

    leva86 Peon

    Messages:
    24
    Likes Received:
    0
    Best Answers:
    0
    Trophy Points:
    0
    #3
    MySql is a crap with the spatial Types and function, mostly of documentation tell me that will be implemented soon. MySql have the deafult table MyIsam that not support the referential integrity, you nedd to use the table InnoDB.
     
    leva86, Feb 23, 2011 IP
  4. prptl709

    prptl709 Guest

    Messages:
    83
    Likes Received:
    0
    Best Answers:
    0
    Trophy Points:
    0
    #4
    Sorry but I am also new for mysql. I have some questions about mysql that in php language only mysql is used or other database is supported by php.
     
    prptl709, Feb 23, 2011 IP
  5. v4vikaskatoch

    v4vikaskatoch Peon

    Messages:
    153
    Likes Received:
    1
    Best Answers:
    0
    Trophy Points:
    0
    #5
    There is some technical differences in MySQL and SQL Server when it comes down to the ANSI SQL standard:

    * MySQL does not support Triggers, SQL Server does.
    * MySQL does not support User Defined Functions, SQL Server does.
    * MySQL does not have Cursor Support, SQL Server does.
    * MySQL does not support Stored Procedures, SQL Server does.
    * MySQL does not have FULL JOIN capabilities, SQL Server does.
    * MySQL has limited Import/Export capabilities, SQL Server has full support for Import/Export.
    * MySQL has limited Transaction Support while SQL Server offers full Transaction Support.
     
    v4vikaskatoch, Feb 23, 2011 IP
  6. ameerulislam10

    ameerulislam10 Peon

    Messages:
    461
    Likes Received:
    3
    Best Answers:
    0
    Trophy Points:
    0
    #6
    I thought MySQL was more popular. I would like to see some advantages of MySQL over SQL , the opposite of what you have just did now. If possible :).
     
    ameerulislam10, Feb 24, 2011 IP
  7. ACME Squares

    ACME Squares Peon

    Messages:
    98
    Likes Received:
    3
    Best Answers:
    0
    Trophy Points:
    0
    #7
    Mysql 5.0 has stored procs, triggers, functions, cursors and transactions. In short, a fully featured database.
    You're using PHP, so pick PDO to connect, because it's more flexible.
     
    ACME Squares, Feb 24, 2011 IP
  8. clau

    clau Guest

    Messages:
    57
    Likes Received:
    1
    Best Answers:
    0
    Trophy Points:
    0
    #8
    PHP can work with many different database servers.
    MySQL is probably the most popular but it also works with MSSQL, PostgreSQL, SQLite and many others.
    It depends mostly on which server is installed on your web server.
     
    clau, Feb 24, 2011 IP
  9. RonBrown

    RonBrown Well-Known Member

    Messages:
    934
    Likes Received:
    55
    Best Answers:
    4
    Trophy Points:
    105
    #9
    Just because it's more popular doesn't mean it is the best. Probably has more to do with mySQL = $0, MS SQL = $Lots. There are free "express" versions of MS SQL available but these have some limitations. The cheapest version of MS SQL that is available to the general public is SQL Server Standard at around $1200 per CPU to purchase.

    When it comes to hosting, MS SQL Standard costs the host around $100 per month per CPU. That can be a lot of money for a small host to recover.
     
    RonBrown, Feb 24, 2011 IP
    ameerulislam10 likes this.
  10. ameerulislam10

    ameerulislam10 Peon

    Messages:
    461
    Likes Received:
    3
    Best Answers:
    0
    Trophy Points:
    0
    #10
    It's making sense now.
     
    ameerulislam10, Feb 25, 2011 IP
  11. AstarothSolutions

    AstarothSolutions Peon

    Messages:
    2,680
    Likes Received:
    77
    Best Answers:
    0
    Trophy Points:
    0
    #11
    The free version of MS SQL is also a relatively new compared to MySQL. Similarly, PHP has built in support for MySQL and whilst it can use MS SQL its not as intuitive and so you very frequently get a LAMP setup and people just use the MySQL blindly.

    MySQL 5 was a significant step forward but the majority of average website designers do not use the extended features like triggers or stored procedures so never saw the limitations of the earlier versions of MySQL
     
    AstarothSolutions, Feb 26, 2011 IP
  12. dlmoredotcom

    dlmoredotcom Peon

    Messages:
    164
    Likes Received:
    1
    Best Answers:
    0
    Trophy Points:
    0
    #12
    Nowadays, people tend to use mySQL because:
    1. Free
    2. Great support for PHP by Oracle :D
    3. Can be customized more.
     
    dlmoredotcom, Mar 26, 2011 IP
  13. teamversion

    teamversion Peon

    Messages:
    79
    Likes Received:
    1
    Best Answers:
    0
    Trophy Points:
    0
    #13
    mySql is free. if you wont be developing enterprise wide application then MySQL should be fine.
     
    teamversion, Mar 27, 2011 IP